Microsoft Office Tutorials and References
In Depth Information
Searching a Database
Figure 17-1:
Search for
a specific
record in a
database
table.
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
field.
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
field.
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.
 
Search JabSto ::




Custom Search