Finding Records

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

Challenge!

  • Open the Contacts table in Datasheet view.
  • Perform a Find function against the Contacts:Table Look In field to locate the Margaret record.
  • Perform a Find Next function against the Contacts:Table Look In field to locate the William Henderson record.
  • Perform a Find function against the Contacts:Table Look In field to locate the Don Mattingly record. Reply to the system prompt.
  • Perform a Find function against the Contacts:Table Look In field and using a H* wild card combination to locate the first record. Perform and repeat a Find Next function against the same wild card combination as you move your way through the records in the database.
  • Close the Contacts table. If displayed, click No in response to the Do you want to save changes to the design of table 'Contacts'? system prompt.