GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Running Database Queries

Access 2003

Single page view print copy

Running Database Queries

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.
previous next
previous 1 2 3 4 5 6 7 8 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.