Creating Queries in Access 2010
- 6/15/2010
- Introducing Query Types
- Creating a Query Using the Query Wizard
- Editing a Query in Design View
- Using Criteria to Focus Query Results
- Introducing Operators
- Using Queries to Calculate Values
- Creating a Parameter Query
- Finding Duplicate Records
- Finding Unmatched Records
- Writing Query Results to a New Table
- Creating an Update Query
- Creating a Crosstab Query
- Finding the Largest and Smallest Values in a Field by Using a Query
Creating a Query Using the Query Wizard
When you create a basic select query, you identify the table (or tables) with the data you want to find, name the fields to appear in the query results, and then save the query. The Query Wizard walks you through the process, making it easy to identify the tables and fields to appear in your query. What’s more, you can choose whether to have Access display detailed results (that is, the individual query rows) or summarize the query’s contents.
Create a Detail Query
Click the Create tab.
Click Query Wizard.
Click Simple Query Wizard.
Click OK.
Click the Tables/Queries down arrow, and then click the table or query with the fields you want to use in your query.
Click the first field to include in the query’s results.
Click Add.
Repeat steps 6 and 7 to add more fields (and step 5 to change the table or query from which you draw fields).
Click Next.
Click the Detail option button.
Click Next.
Type a name for your query.
Click Finish.
TIP
To add all of a table’s fields to your query, click the Add All (>>) button. You can also remove a field by clicking the Remove (<) button or remove all fields by clicking the Remove All (<<) button.
TIP
The step of the wizard that asks whether you want to create a detail or summary query appears only for some types of queries; don’t panic if you don’t see it.
Create a Summary Query
Click the Create tab.
Click Query Wizard.
Click Simple Query Wizard.
Click OK.
Click the Tables/Queries down arrow, and then click the table or query with the fields you want to use in your query.
Click the first field to include in the query’s results.
Click Add.
Repeat steps 6 and 7 to add more fields (and step 5 to change the table or query from which you draw fields).
Click Next.
Click the Summary option button.
Click Summary Options.
Select the check boxes representing the summary values you want calculated.
Click OK.
Click Next.
Select the option button representing how you want the query to group rows in the query’s source table.
Click Next.
Type a name for your query.
Click Finish.
