Microsoft Office Tutorials and References
In Depth Information
Searching a Database
5. (Optional) Clear one or more of the check boxes that appear to the left
of the list of data that appears in the field you chose in Step 3.
6. Click OK.
Access displays the filtered view of your database table of only those
items that appeared selected in Step 5.
7. Repeat Steps 3 through 6 for each additional field you want to filter.
Filtering by form
One problem with defining filters in Datasheet view is that you have all your
database table records cluttering the screen. To avoid this problem, Access
lets you define filters by using a form, which basically displays an empty
record so you can click the fields that you want to use to filter your database
To define a filter by form, follow these steps:
1. In the All Tables pane on the left of the screen, double-click the name
of the database table that you want to filter.
Access displays the Datasheet view of your database.
2. Click the Home tab.
3. Click the Advanced icon in the Sort & Filter group.
A pull-down menu appears.
4. Choose Filter By Form, as shown in Figure 17-3.
Access displays a blank record.
5. Click in any field.
A downward-pointing arrow appears.