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...