How to Create a Simple Access Query
Create simple access queries by using the query wizard. The query wizard gives you four types of queries to create. The first option is the Simple Query Wizard. This query lets you pick the table and fields you want in your query. Once this information is specified, you are prompted to save the query. The results of the query are displayed in the datasheet view. This query can be printed, saved or added to reports for further analysis.
Other People Are Reading
Instructions
-
-
1
Open Access 2010 and select a database. Click the "File" tab and select the "Open" button. Select a database from the recent database list in the File menu list.
-
2
Click the "Create" tab and select "Query Wizard." Select "Simple Query Wizard" and click "OK." In the "Tables/Queries" field, select the table that you want to use in the query. Add field names by clicking the field name and clicking the right arrow. Click "Next."
-
-
3
Click "Detail" and select "Next." Add a title to your query in the "Title" field. It's common to add a prefix of "qry" to queries. Click "Finish." Review the results of the query in the datasheet view.
-
1
