Review the Data: Find
Let's Find the same records that we did in
Excel. The steps are similar.
2.
Try it: Find a Record
tblMovies is open
in Datasheet View.
Select a
Field: Stars.
Go to
Home ->Find ->Find.
Find What:
Depp.
Look In:
Current field.
Match: Any
Part of Field.
Click
Find Next.
What Do
You See? Microsoft Access will highlight each Field that
contains "Depp."
Close the
Find and Replace window.
Keep
going, please.
Memo to Self: The default
selection in Microsoft Access is to Match the Whole Field. When you
select Match Any Part of the Field, Access will look for
anything the matches the criteria in the Find box.