Advanced Search Tips

You can perform an advanced search using the More Search Fields and Enter Where Clause dialog boxes. These dialog boxes are accessed via Advanced Search on the List tab.

Note: A few applications consist of only one page; therefore, they do not have a List tab. With the exception of Bookmarks, one-page applications have a Search Toolbar with the same search options found on the List tab.

More Search Fields Dialog Box

You use the More Search Fields dialog box to search for a particular records using additional fields. The number of fields available to perform a search varies for each application.

Tips:

Enter Where Clause Dialog Box

You can search the database for particular records via entering a SQL WHERE clause in the Where Clause dialog box.

Note: To perform advanced queries, you should be familiar with both Structured Query Language (SQL) and the database. Constructing SQL queries is more commonly performed by system administrators and database administrators, and is not covered within the scope of the help system.

Tips:

See Also

Use More Search Fields

Enter a WHERE Clause

Use Wildcards and the Equal Sign in Searches