Database Reference
In-Depth Information
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.
This button is dynamic; it is called Apply Filter and is inactive when no filter is applied,
and it is called Remove Filter and is active when a filter is applied. Let's use this but-
ton to quickly turn off the applied filter.
4
In the
Sort & Filter
group, click the
Remove Filter
button to toggle off the filter and
display all the records.
TIP
If you click the Toggle Filter button again, the current 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
Tex t Filters
to display a list of criteria.
