Finding Records

In Access 2000 finding records may seem confusing at first. This free lesson offers step-by-step instructions.

The Find and Replace dialog box

When you are dealing with a large database filled with thousands of records, you may need to quickly locate one of them. Access provides an easy way to find individual records: the Find function.

To use the Find function:

  • Click in the field that contains the data you're searching for.
  • Choose EditactionFind or click the Find button on the toolbar.
    Find button
  • The Find and Replace dialog box opens. Type a piece of information related to the record you're searching for. In the example, "Rob", a piece of information related to the last name "Robinson", appears in the Find What text box.
  • Click Find Next.

Find and Replace dialog box