Database Reference
In-Depth Information
13
With 19 records displayed in the filtered table, right-click
2/1/2012
in the
OrderDate
field, and then click
On or After 2/1/2012
to find the six records that meet this
criterion.
TIP
To display a list of the available options for date filters, right-click any cell in the
OrderDate field, and then point to Date Filters.
14
Close the
Orders
table, clicking
No
when prompted to save the table layout.
CLEAN UP
Keep the GardenCompany04 database open for use in later exercises.
Filtering information by using forms
When you want to filter a table based on the information in several fields, the quickest
method is to use the Filter By Form command, which is available from the Advanced Filter
Options list in the Sort & Filter group on the Home tab. If you choose this command when
a table is active, Access displays a filter form that resembles a datasheet. Each of the cells in
the form has an associated list of all the unique values in that field in the underlying table.
4
In the filter form for a table, clicking the cell below a field name displays an arrow that you can use
to display a list of that field's unique values.
