Microsoft Office Tutorials and References
In Depth Information
Searching a Database
record in a
6. (Optional) Click in the Match list box and choose one of the following:
• Any Part of Field: The Find What text can appear in any part of a
• Whole Field: The Find What text is the only text stored in a field.
• Start of Field: The Find What text can be only at the beginning of a
7. (Optional) Click in the Search list box and choose one of the following:
• Up: Searches from the record where the cursor appears, up to the
beginning of the database table
• Down: Searches from the record where the cursor appears, down
to the end of the database table
• All: Searches the entire database table
8. Click Find Next.
Access highlights the field where it finds the text you typed in Step 4.
9. Repeat Step 8 to search for more records that might contain the text
you typed in Step 4.
10. Click Cancel or the Close button.
Filtering a database
Searching a database is easy but somewhat limited because you can retrieve
only a record that matches any text that you want to find. If you want to find
multiple records, you can use a filter.
A filter lets you tell Access to display only those records that meet certain
criteria, such all records that contain people who earn more than $200,000 a year,
are currently married, live in Las Vegas, Nevada, and own two or more cats.