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.
Video of the Day
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.
