Microsoft Office Professional 2010 Step by Step eBook

852 Chapter 28 Display Data

Only the six records for customers who live in Vancouver are displayed in the table.

Tip In the list displayed when you click the arrow to the right of a field name (or the

Filter button in the Sort & Filter group) are check boxes for all the unique entries in

the active field. Clearing the Select All check box clears all the boxes, and you can then

select the check boxes of any values you want to be displayed in the filtered table.

In the Sort & Filter group on the Home tab, the Toggle Filter button is now active.

You can use this button to quickly turn the applied filter on and off.

4. In the Sort & Filter group, click the Toggle Filter button.

Access displays all the records. If you click the Toggle Filter button again, the filter

will be reapplied.

Now let’s display a list of all customers with postal codes starting with 880.

5. Click the arrow to the right of the PostalCode field name, and point to Text Filters
   in the list.