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

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2007.

  • A Quick Reference Card you can take away from the course.


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

Topics in this course

  1. Use expressions and formulas in queries

  2. A criteria refresher

  3. Types of selection criteria

  4. Expressions that compare values

  5. Expressions that go between

  6. Make a query ask for input before it runs

  7. Use wildcards in parameters

  8. Practice

  9. Quick reference card

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!