Running Database Queries
In Access 2003 running database queries may seem confusing at first. This free lesson offers step-by-step instructions.
- 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.