This module discussed how to find the data you need when it resides in a single table.
Terms and concepts
This module introduced you to the following key terms and concepts:
Filter
Filter by Form
Filter by Selection
Filter For
Find
Sort
You can enter a specific value or choose to use wildcard characters. Table 2.7 lists the wildcard characters available in the Find dialog box.
Table 2.7 Wildcard characters
You can combine wildcard characters for more robust searches. For example, 196[!2.8] will find 1961 and 1969, but nothing in between. The Match drop-down list contains three choices:
Any Part of Field: If you select Any Part of Field, Access searches to see whether the value is contained anywhere in the field. This search finds Ford anywhere in the field, including values like Ford Mustang, 2008 Ford F-150, and Ford Galaxy 500.
Whole Field: The default is Whole Field, which finds fields containing exactly what you have entered. For example, the Whole Field option finds Ford only if the value in the field being searched is exactly Ford, and nothing else.
Start of Field: A search for Ford using the Start of Field option searches from the beginning of the field and returns all the rows containing Ford as the first four characters of the description.