Getting Information with a Query

Access saves and lists the queries you create on the Queries tab in the Database window. You can double-click a query to run it and display the results. When you run a query, the query results show only the selected fields for each record in the table that matches your selection criteria.

Open and Run a Query

In the Database window, click Queries on the Objects bar.

Click the query you want to run.

Click the Open button.

The query opens in a table called a dynaset. The dynaset displays the records that meet the specifications set forth in the query.