Filtering is a method of retrieving records that meet search 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.

Filtering by Selection is the easiest method.

Open the table.

The following table will be used to illustrate the method. The customers database contains about 125 records.

This list will be sorted by selecting country France.

Click the first field in which the word France is found

Click the Filter by Selection icon

The following list will display

To return to the database

Click the Filter icon

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