Sometimes you just need to find a particular piece of data within a table, perhaps you remember the name and need to find the address.
The Find and Replace dialog box is the perfect solution because it allows you to search for one piece of data within one table.
To use the Find and Replace dialog box you need to know which table the data you are looking for is in.
Open that table before you begin your search.
The following simulation shows you how to use the Find and Replace dialog box to find the data you are looking for.
Although you can move to a specific record (if you know the record number) or to a specific field in the current record, usually you will want to find a certain value in a record.
You can use one of these methods for locating a value in a field:
- Select the Find command (a pair of binoculars) from the Find group of the Ribbon.
- Press Ctrl+F.
- Use the Search box at the bottom of the Datasheet window.
The first two methods display the Find and Replace dialog box (shown in Figure 2.2). To limit the search to a specific field, place your cursor in the field you want to search before you open the dialog box.
Change the Look In combo box to Current Document to search the entire table for the value.