Home > Sample chapters > Microsoft Office > Access

Creating Queries in Access 2010

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

  1. Click the Create tab.

  2. Click Query Wizard.

  3. Click Simple Query Wizard.

  4. Click OK.

    httpatomoreillycomsourcemspimages613702.jpg
  5. Click the Tables/Queries down arrow, and then click the table or query with the fields you want to use in your query.

  6. Click the first field to include in the query’s results.

  7. Click Add.

  8. Repeat steps 6 and 7 to add more fields (and step 5 to change the table or query from which you draw fields).

  9. Click Next.

    httpatomoreillycomsourcemspimages613704.jpg
  10. Click the Detail option button.

  11. Click Next.

    httpatomoreillycomsourcemspimages613706.jpg
  12. Type a name for your query.

  13. Click Finish.

    httpatomoreillycomsourcemspimages613708.jpg

Create a Summary Query

  1. Click the Create tab.

  2. Click Query Wizard.

  3. Click Simple Query Wizard.

  4. Click OK.

    httpatomoreillycomsourcemspimages613710.jpg
  5. Click the Tables/Queries down arrow, and then click the table or query with the fields you want to use in your query.

  6. Click the first field to include in the query’s results.

  7. Click Add.

  8. Repeat steps 6 and 7 to add more fields (and step 5 to change the table or query from which you draw fields).

  9. Click Next.

    httpatomoreillycomsourcemspimages613712.jpg
  10. Click the Summary option button.

  11. Click Summary Options.

  12. Select the check boxes representing the summary values you want calculated.

  13. Click OK.

    httpatomoreillycomsourcemspimages613714.jpg
  14. Click Next.

  15. Select the option button representing how you want the query to group rows in the query’s source table.

    httpatomoreillycomsourcemspimages613716.jpg
  16. Click Next.

  17. Type a name for your query.

  18. Click Finish.

    httpatomoreillycomsourcemspimages613718.jpg