How to View the Results of a Query in Access
Queries are used in Microsoft Access to extract data out of the database. Queries are unique because they let you question the data that has been added in the database. Use the Query Design option to quickly create queries in your database. When using the design view of the query, you can add the columns and fields that you plan to see in the query results. To view the results of the query in Access, use the execution or run button located on the ribbon.
Other People Are Reading
Instructions
-
-
1
Open Access 2010 and click the "File" button. Click the "Recent" option and select a database that you have been working with. The database opens.
-
2
Click the "Create" tab and select "Query Design." The Show Table dialog box appears. Click a table that you want to include in the query and click the "Add" button. Close the Show Table dialog box by clicking the "X" button.
-
-
3
Add fields to the query by clicking the field name and dragging it to the query. Add criteria to the query by clicking in the "Criteria" field and adding your criteria. For example, if you want to see all invoices overs $1000, enter the following criteria ">1000" in the "Total" field.
-
4
View the results by clicking the red "!" button on the ribbon. The results are displayed in the query datasheet view.
-
1
