Home
>
Articles
>
Data
>
Access
This chapter is from the book
Finding Data
-
Click in the field, or column, on which you want to search. For example, to search by last name, click anywhere in the Last Name column.
-
Open the Edit menu and choose Find.
-
The Find and Replace dialog box opens with the Find tab displayed. In the Find What field, type the entry you want to find.
-
Optionally, to search the entire table rather than the field you chose in step 1, click the down arrow next to the Look in field and choose the table name from the list that appears.
-
-
Click the down arrow next to the Match field and select Whole Field, Any Part of Field, or Start of Field.
-
Click the Find Next button.
-
Access locates and selects the record with the first matching entry. If this is not the record you need, click the Find Next button to find the next match and repeat as needed.
-
Access notifies you when no more matches are found. Click OK.