Access 2003

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.