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

 
 
 Queries V: Use And, Or, and In to set multiple conditions 
 
  Overview  
 Show/Hide lesson sections Set multiple conditions in a query
  Feedback  
 Quick Reference Card Quick Reference Card  
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.
Bookmark and ShareShare
Overview
Use And and Or in your queries  

Learn how to use conditions with the "And", "Or", and "In" operators in queries. These operators can help you find data that matches multiple conditions, such as all your French customers who own their businesses.

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 20–25 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Use complex criteria in queries.
  • Work with the And, Or, and In operators.
  
ABOUT THIS COURSE

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.
  • A test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.
AUDIO TEXT

The fourth course in this series explained how to use mathematical functions and create calculated fields in your queries. This course shows you how to use three logical operators — AND, OR, and IN.

You use them to create complex criteria and retrieve data that matches more than one condition. For example, do you need to find the sales representatives who work in the London office AND report to a given manager? How about finding all the customers IN France, Belgium, OR Germany?

This course explains how to use complex conditions with logical operators to return those kinds of results.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

  
BEFORE YOU BEGIN
  Go to previous page (disabled)    Next Go to next page
advertisement