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.
United States
