Queries III: Use expressions and other criteria
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 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.