Running Database Queries

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

Challenge!

  • Open the Contact Management database.
  • 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 multiple-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 to the queries you have created in this challenge.
  • Close the Contacts table, and if displayed click the "No" button in response to the Do you want to save changes to the design of table 'Contacts' system prompt.