Queries I: Get started with queries

Retrieve data with queries

Learn how to create queries. Queries retrieve information from your database, and they can also do some heavy lifting, such as calculating the sales figures for last quarter, or finding just the right set of customers in France.

Start course button

About this course

This course includes:

  • 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:

  • Design a select query.

  • Run select queries.

  • Open a select query in Design view.

Before you begin

You must be familiar with the basics of database design, tables, and relationships. If you aren't, take these preparatory courses, and then return to this course.

Topics in this course

  1. Get started with queries

  2. Types of queries

  3. Start by asking questions

  4. Build your query

  5. Run your query

  6. Practice

  7. Quick reference card

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language