Page 1 of 23PREVNEXT

Queries II: Limit your data and calculate values

Values in queries
Make your Microsoft Access queries more powerful and limit your results by using criteria and performing calculations.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Use expressions as criteria to limit your results and perform calculations.
  • Use Expression Builder for complex expressions.
  • Retrieve the highest or lowest values, such as the 10 associates with the highest sales last quarter.
  • Total values and use other built-in functions, such as counting and averaging records.

Before you begin

You should take Queries I: Get answers with queries or be familiar with basic select queries.


So you know how to create a basic query to retrieve data, such as retrieving all the sales associates in Paris, but now you're ready to take your skills further.

What if you want to retrieve a list of the top-selling products in Europe, or total all the sales in France? Perhaps you want to calculate the tax for your products?

You can do all this and more with queries, which not only retrieve your data, but can be used as a data source in forms and reports.

This course will show you how to make your queries more valuable by using criteria and calculations.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 23PREVNEXT