Queries II: Create basic select queries

Learn to create queries in Access 2007

Learn how to create basic select queries. Select queries retrieve data from your database, and they're one of the most frequently used and versatile tools Access provides.

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.

Goals

After completing this course you will be able to:

  • Create a select query by using the Query Wizard.

  • Create a select query by using Design view.

  • Add criteria to a select query and filter your results.

  • Sort your results.

Before you begin

Topics in this section

  1. Create a select query

  2. Use the wizard to create a query

  3. Use Design view to create a query

  4. Specify criteria to focus your data

  5. Show or hide your fields

  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!

Support resources

Change language