Tutorial Home > Access 2007 Tables > Access Filter

Access Filter

The Access Filter is a way of reducing the number of records in a list by excluding those which do not match a given criteria. For example, you might want to view all the records for people with the surname 'Smith'. In this case Smith is the criteria to match. All other records which have records that are not Smith will be filtered out of the list.

There are a number of ways to use this feature. The way that I have found most effective is to use the Filter By Form method.

Filter by Form

  1. If you look at the SORT AND FILTER group on the HOME tab of the Access Ribbon, you will see a large filter icon and three smaller icons entitled SELECTION, ADVANCED, and TOGGLE FILTER. You need to click the ADVANCED icon and select FILTER BY FORM from the drop down context menu (see screenshot below).

    Filter by Form
  2. Access will then open up a blank datasheet with empty cells underneath your column headings. Click on the empty cell in the SURNAME column, and start entering the surname Smith. As you do so, Access suggests surnames from your list based on the letters that you have typed so far. So once you get to "Sm"..., Access completes the rest of the name for you (see screenshot below).

    Filter Form
    The filter form..
  3. The next thing that you need to do is click the TOGGLE FILTER icon on the Ribbon to apply the filter.

Result: a new filtered list is displayed containing all three records from your original table with the surname 'Smith'.

Filter by Form
Filtered list after TOGGLE FILTER icon is clicked.

Next we shall take a look at Sorting Tables

Back to Access Tables