Access 2003

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.
  
  
• The query searches the database and then displays the results on the screen.