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

 
 
 Queries III: Use expressions and other criteria 
 
  Overview  
 Show/Hide lesson sections Use expressions and formulas in queries
  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 formulas and expressions in queries  

Learn to use formulas and expressions in your queries. Formulas can give you critical business information with a single click, and expressions can help you answer important business questions such as, "What are my best or worst selling products?"

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

  • Length: 25–30 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Retrieve highest or lowest values, such as the 10 associates with the highest sales last quarter.
  • Create expressions that compare values.
  • Create a parameter query that asks for starting and ending values before it runs.
  • Make a parameter query more flexible by using wildcard characters.
  
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 second course in this series showed you how to create a basic select query and use selection criteria. Now you're ready to take your skills further.

This course explains how to create a query that finds the most or least of something. We'll also explain how to use a type of criteria called an expression, a formula that does more than add numbers. We'll also show you how to create a parameter query — a query that asks for input before it runs — and you'll see how to use wildcard characters in that type of query.

This course assumes you're familiar with the basics of select queries. If you're not, take the courses listed in the prerequisites before you continue with this course.

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