Knowing all of the options when querying in forms will help take users beyond average and toward ‘power user’ status.
Master the use of query wildcards, and query operators as described below.
Query Basics
Query-by-Example is a simple three step process:
- While in a form, switch to query mode by selecting <F11> from the keyboard
- enter the criteria for the query
- execute the query by selecting <ctrl><F11> simultaneously from the keyboard
While performing step 2 (enter the criteria), with either wildcards or operators as shown in the tables below.
Query Wildcards
Query Operators
In the examples below, the query criteria uses both a wildcard and an operator.