Page 1 of 10PREVNEXT

Queries IV: Use functions and calculated fields in your queries

Learn how to use functions in queries
Learn how to use functions and calculated fields in your queries. Access 2007 provides built-in functions that sum, count, and average data. You can also use expressions to create calculated fields — fields that exist only when you run your query.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.
  • A test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Create a totals query.
  • Use expressions to create calculated fields.
  • Use parentheses to control operator precedence.
  • Include or exclude null values from a record set.

Before you begin

The third course in this series explained how to create a top-values query and use expressions. If you took that course, you did a small amount of math. This course goes deeper and shows you how to use a set of functions that are built into Access, and how to create calculated fields.

You use the built-in functions to sum, average, or count the data in a single field. If you need to use more than one field in a calculation, you can use an expression to create a calculated field — a field that displays the results of an expression instead of stored data. For example, if you need to calculate total sales for last month, you use a built-in function. But if you need to discount your prices, then you use a calculated field.

Don't worry, we don't expect you to become a mathematician, and we'll give you lots of examples.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

Page 1 of 10PREVNEXT