Running Database Queries

In Access XP running database queries may seem confusing at first. This free lesson offers step-by-step instructions.

Challenge!

  • Open the Contacts table in Datasheet view.
  • Use the wizard to create a single-table query:
    • Select the Contacts table.
    • Select the following fields in the Contacts table: Last Name, First Name, Address, City, State/Province, Postal Code, Work Phone, Work Extension, and Email Name.
    • When prompted to name the query, call it Address Book Contacts.
  • Use the wizard to create a multi-table query:
    • Select the following fields in the Contacts table: Last Name, First Name, Company Name, Work Phone, and Work Extension.
    • Select the following fields in the Calls table: Call Date, Subject, and Notes.
    • Select a Detail query.
    • When prompted to name the query, call it Job Search Progress.
  • Build onto the sorting, finding, and filtering capabilities learned in previous lessons by applying these techniques on the queries you have created in this challenge.
  • 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.