Database Reference
In-Depth Information
Filtering information in tables
Sorting the information in a table organizes it in a logical manner, but you still have the
entire table to deal with. For locating only the records containing (or not containing) spe-
cific information, filtering is more effective than sorting. For example, you could quickly
create a filter to locate only customers who live in Seattle, only items that were purchased
on January 13, or only orders that were not shipped by standard mail.
When you filter a table, Access doesn't remove the records that don't match the filter; it
simply hides them. To filter information by multiple criteria, you can apply additional filters
to the results of the first one.
4
The Filter commands are available in the Sort & Filter group on the Home tab, on the menu
displayed when you click the arrow at the right end of a field name, and on the shortcut
menu displayed when you right-click anywhere in a field's column. However, not all Filter
commands are available in all of these places.
TIP
You can filter records while displaying them in a form by using the same commands as
you do to filter records in a table.
In this exercise, you'll filter records by using a single criterion and then by using multiple
criteria.
SET UP
You need the GardenCompany04 database you worked with in the preceding
exercise to complete this exercise. If necessary, open the database. Then follow the steps.
1
In the
Navigation
pane, in the
Tables
group, double-click
Customers
to open the
Customers
table in
Datasheet
view.
2
In the
City
field, click any instance of
Vancouver
.
3
On the
Home
tab, in the
Sort & Filter
group, click the
Selection
button, and then in
the list, click
Equals “Vancouver”
. Notice that a small filter icon shaped like a funnel
appears at the right end of the
City
field name to indicate that the table is filtered
by that field. The record navigation bar at the bottom of the table changes to
1 of
6
because only six records have the value
Vancouver
in the
City
field. Also on the
record navigation bar, the filter status changes to
Filtered
.
