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.

graphics/3_icon.jpg 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.


Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318 © 2008-2017.
If you may any questions please contact us: