Filtering Information by Using Forms 855
- In the OrderDate field, right-click 2/1/2010, and then click On or After 2/1/2010.
Tip To see a list of the available options for date filters, right-click any cell in the
OrderDate field, and then point to Date Filters.
You now have a list of the orders customers placed with the selected employee on or
after the specified date. You could continue to refine the list by filtering on another
field, or you could sort the results by a field.- Close the Orders table, clicking No when prompted to save the table layout.
CLEAN UP Retain the GardenCompany04 database 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. When you choose this command
with a table displayed, Access displays a filtering 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 under-
lying table.Using the Filter By Form command with a table.