GCFLearnFree.org

One of the best-designed sites ever. Learning is made so easy.”

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

Run an existing query

Like tables and forms, a query is another type of database object in Access 2003. A query is a search for records that match the exact criteria you define. In this example, we will run a query against the Contacts table and list all records found by Last Name, First Name, and Work Phone.

To run an existing query:

  • Open the Contact Management database.
  • In the database window, choose the Queries tab from the Objects palette.
  • To open a query, double-click the query title, click once on the query title and then click the Open button, or right-click the title and choose Open from the shortcut menu.

    Contacts Query Selection under Queries Object
  • The query searches the database and then displays the results on the screen.

    Query Results
previous next
previous 1 2 3 4 5 6 7 8 next
Terms Of Use

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