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 table.
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.
The Advanced pop-up menu lets you specify the criteria for a specific field.
5. Click in any field.
A downward-pointing arrow appears.
6. Click the downward-pointing arrow.
A pull-down menu appears, listing all the data currently stored in that field, as shown in Figure 17-4.
Filtering by form lets you choose the type of data you want to view from a pull-down menu.
7. Click the data you want.
You can only click on one entry in the list.
8. Click the Toggle Filter icon in the Sort & Filter group.
Access displays a filtered view of your database table.