en uk

Filtering by form Microsoft Access 2007

    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.

    Filtering by form Microsoft
Access 2007

    Figure 17-3:

    The Advanced pop-up menu lets you specify the criteria for a spe­cific 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 Microsoft
Access 2007

    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.


Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.