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 that matches the criteria in the Find box.