How to Save a Query in Access

By Emmanuelle Douglas

Access is the database component of the Microsoft Office suite. Databases let you configure large quantities of data into concise queries and reports. The queries used in Access let you ask a question of your database. Based on the criteria entered, you can find data from millions of records. Access queries can be performed manually using select queries or automatically by using the query wizard. Either method lets you choose which fields are used during the query.

Step 1

Open Access 2007 and select a database you created earlier. Select the "Office" button and select "Open." Browse your computer and locate the database. Click on the database and click "Open." The database opens.

Step 2

Create a query by using the "Create" tab on the ribbon. Select "Query Design." The Show Table dialog box appears. Click on the table that the query will be applied to. Click "Add." Click "Close."

Step 3

Double-click on the fields you want included in your query. Add criteria you want to include in your query. Type the criteria in the "Criteria" field. Run the query by clicking on the "Run" button. View your query results.

Step 4

Save your query by clicking on the "Save" icon on the Quick Access Toolbar. Give your query a name that identities it. Your query can begin with "Qry_" to indicate that it is a query. Click "OK" once you have named your query. Your named query appears in your query list.