Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Overview
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.

  • Length: 40–45 minutes
 


GOALS

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.
 
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.
COURSE TEXT

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.

 
BEFORE YOU BEGIN

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

  Go to previous page (disabled)    Next Go to next page
advertisement