Running Database Queries

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

Run an existing query

Like tables and forms, a query is a type of database object in Access 2002 XP. 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