How to Calculate Averages in Microsoft Access

Techwalla may earn compensation through affiliate links in this story.
Use queries to calculate averages in Access.

In database applications queries are commonly used to quickly get the average of a field in a database table. Queries are used to retrieve information from your table and can also do some heavy lifting such as data transformations or calculations. In a query you can use the "Avg" function to calculate the arithmetic mean of a set of values in a specific field.

Advertisement

Step 1

Click the "Create" tab and click "Query Design" to display the Show Table dialog window. Click the table you want to use to calculate an average and click "Add."

Video of the Day

Step 2

Double-click the field you want to use and click the "Totals" icon. Next to "Total:" in the quick table at the bottom of your computer screen select "Avg" to average the field.

Step 3

Click the "View" icon to view the average result.

Advertisement

references