Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Overview
Values in queries  

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

  • Length: 45–50 minutes
 


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.
 
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.
COURSE TEXT

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.

 
BEFORE YOU BEGIN

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

  Go to previous page (disabled)    Next Go to next page
advertisement