Filtering is a method of retrieving the records that meet certain criteria. There are different methods of filtering. Open the database you want to work with. Make sure you are in Datasheet View / Tables. It is easier to see the entire database and all the retrieved records.

Open the Table
Click the Filter by Form icon
A blank table record will display

Select any of the field names and a black diamond displays
Example: search the City field

Click the black diamond and a drop down list will display all the names of the cities included in this database

Click the Apply Filter icon to return to the table

Multiple fields can be searched … apply the Filter by Form to various fields

Example: Seattle and USA
Search for multiple items within the same field
Example: France or Germany or Austria

Do you want to print the list?

Click Edit
Click Select All Records

Reminder: Many of the database lists must be printed on landscape orientation

Click Edit

Click Page Setup…
Select Page tab
Click Landscape radio button
OK

Click File
Click Print…
Click Selected Records radio button
OK

February 02, 2010

Sr. Arlene Callahan
Training Manager
Office 897-8660
E-mail: acallahan@rivier.edu