Page 1 of 11PREVNEXT

Queries III: Use expressions and other criteria

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?".

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.

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.

Before you begin


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.

Page 1 of 11PREVNEXT