Find Options

3. Try it: Review the Find Options

There are three options for matching the criteria in Microsoft Access:

Whole Field

Any Part of Field

Start of Field

 

If you select Whole Field, Access will search for an exact match.

 

If you select Any Part of Field, Access will parse the data and look for whatever includes the criteria, whether it is in the beginning, middle or end of the data.

 

If you select Start of Field, then the Find search will only return records that include the criteria at the beginning.

 

Click Cancel. Keep going...

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.6. Sort and filter records for reporting: Use the Find command

Home->Find->Find