How to Access a Query to Find a Record

Access queries are one of the output objects in Access databases. The queries let you specify how the information is extracted out of your database. A query is constructed using query wizards or the query design view, which lets you specify additional criteria to refine your query results. Use the query criteria to help find specific records in your database. When more criteria are added to the query, the query will display fewer results.

• 1

  Open Access 2010 and select a database. Click the "File" tab and select the "Open" icon. Browse your computer files and locate the database. Click the database and select "Open." The database opens.

• 2

  Click the "Create" tab and select "Query Design." The Show Table dialog box appears. Add a table to the query by clicking the table name and the "Add" button. Close the Show Table dialog box by clicking the "Close" button.

• 3

  Add fields to the query by clicking the table field names and dragging them to the query. Add criteria to find specific records by adding criteria in the "Criteria" field. For example, if you are looking for your green widgets in your database, change the criteria for the color column to "green."

• 4

  Run the query by clicking the "Run" button on the ribbon. The query displays the records matching this criteria in the datasheet view.