Create queries for a new Access 2007 database

Learn to create queries in Access 2007

Learn how to create queries. In Access 2007, you use queries to extract data from your database, and to provide data for forms and reports.

Start course button

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Use the Query Designer to create a select query that returns data from a single table.

  • Create a select query that asks you to enter parameters, then returns results that match those parameters.

  • Use a formula in a query to calculate a sum.

  • Use the Query Wizard to create a select query that returns data from two tables.

  • Use a text expression to concatenate fields.

Before you begin

Topics in this course

  1. Get answers from your data

  2. The basics of creating select queries

  3. Ways to use query results

  4. Query a single recordsource

  5. Make a query ask you for input

  6. Use a formula in a query

  7. Query multiple recordsources

  8. Practice

  9. Quick reference card

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!