Use the Find button to access records. Access scans all the selected fields beginning with the first to the last record.

The following table will be used as a model:

Highlight the column where you would like to find data.
For purposes of brevity, only a part of the table will be used.

Click the Find icon
Find what: I would like to find all the companies in Berlin; therefore, type in the world Berlin

Look in: Click the black diamond
Notice the word City is already listed as I highlighted this column before the search for quicker results

The entire table could be selected

Match: Click on the black diamond
Select Any part of Field
Click the button if you need to be more specific
Not needed for regular searches

Search: All Up Down
Always select All is the default
Match Case (Not recommended)
Search Fields as Formatted
This option is good for date fields Ex: 06/27/00

Click Find Next button to move to the next record, etc.

February 02, 2010

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