Page 1 of 19PREVNEXT

Queries IV: Working with complex criteria

Complex criteria and wildcards in queries
Limit your Microsoft Office Access query results by using complex criteria, such as setting two conditions that must be met and using wildcards to retrieve data that matches a pattern.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Use complex criteria in queries.
  • Work with the And, Or, and In operators.
  • Use wildcards to find data that matches a pattern.

Before you begin

You should be familiar with select queries or take Queries I: Get answers with queries.

Queries can make your database more powerful by getting you just the data you want. In this course, you'll learn how to use complex criteria to beef up your queries.

Want to retrieve data that matches more than one condition, such as all the sales representatives who report to the same boss? Or perhaps all the customers whose last name starts with "B"?

In this course, you'll learn how to enter complex criteria in Design view, and how to use operators that set multiple conditions and wildcards that find data that matches a pattern.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 19PREVNEXT