Microsoft Office Tutorials and References
In Depth Information
Searching a Database
To filter a database table, you must tell Access which field to use as a filter,
and then you must define the criteria for that filter. For example, if you want
to filter your database table to see only those records listing the names of
people who are at least 65, you filter the Age field and set the criterion to
Greater than or equal to 65.
Filtering simply hides all records in a database table that don’t match your
criteria. Filtering doesn’t delete or erase any records.
Using an exact match for a filter
The simplest filtering criterion searches for an exact match. When you filter
a field by an exact match, you’re telling Access, “I want to see only those
records that contain this specific chunk of data in this particular field.” By
using an exact match filter, you could display only those records that contain
CA in the State field.
To filter a database table, follow these steps:
1. In the All Tables pane on the left of the screen, double-click the name
of the database table you want to filter.
Access displays the Datasheet view of your database.
2. Click the Home tab.
3. Click in the field (column) that you want to use as a filter.
4. Click the Filter icon in the Sort & Filter group.
A pop-up menu appears, as shown in Figure 17-2.