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-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.
In the examples below, the query criteria uses both a wildcard and an operator.