Microsoft Office Tutorials and References
In Depth Information
Filter Records
Filter
Records
Jun e Calendar
7
8
You can use an Access filter to view only specific
records that meet criteria you set. For example,
you may want to view all clients buying a
particular product or anyone in a contacts database
who has a birthday in June. You can apply a
simple filter on one field in your database using
the Selection tool, or you can filter several fields
using the Filter by Form command.
14
15
14
R D
21
22
23
E R
28
29
30
s
Filter Records
Apply a Simple Filter
1 Open the form you want to filter.
2 Click in the field by which you
want to filter.
3 Click the Home tab on the
Ribbon.
4 Click the Selection button.
5 Click a criterion.
3
4
5
1
2
Access filters the records.
In this example, Access finds two
records matching the filter
criterion.
You can use the navigation
buttons to view the filtered
records.
To undo a filter, click the Toggle
Filter button.
308
Search JabSto ::




Custom Search