How to Save a Query in Access

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.

...
Save Access queries by using the "Save" icon on the Quick Access Toolbar.

Step

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

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

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

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.