Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
To Use a Common Filter
You can ﬁ lter individual ﬁ elds by clicking the arrow to the right of the ﬁ eld name and using a Common Filter.
If you have determined you want to include those clients whose city begins with Ber, Filter By Selection would not
be appropriate. You would need to use a Common Filter. The following steps use a common ﬁ lter to include only
those clients whose city begins with Ber.
• Be sure the Home tab is selected.
• Click the City arrow to display the
common ﬁ lter menu.
clear any existing ﬁ lter
for this ﬁ eld (currently
there is none)
sort the data
in the column
• Point to the Text Filters command
to display the custom text ﬁ lters
I selected the City ﬁ eld and then
clicked the Filter button on the
Home tab. My screen looks the
same. Is this right?
Yes. That is another legitimate way
to display the common ﬁ lter menu.
text ﬁ lters
With ﬁ lter
check box to select
or deselect all values
check boxes to
include speciﬁ c values
custom text ﬁ lters
• Click Begins With to display the
Custom Filter dialog box.
• Type Ber as the City begins with
value (Figure 3–16).
If I wanted certain cities included,
could I use the check boxes?
Yes. Be sure the cities you want are
the only ones checked. One way
to do this is to click the Select All
check box to remove all the check
marks and then click the check
boxes for the cities you want to
include. Another way is to clear the
check boxes for the cities you don’t
want. Use whichever technique
you ﬁ nd more convenient.
• Try other options in the Common
Filter menu to see their effect.
When done, once again select
those clients whose city begins