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.

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

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

Applies To: Access 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language