How to Calculate Average in Microsoft Access

Quick summary

This tutorial shows how to calculate an average in Microsoft Access using the built-in Query Design tool and the Avg aggregate function. By following these steps, you can instantly summarize numeric field data without writing any manual SQL.

Steps

1. Go to the Create tab in the Microsoft Access ribbon.
2. Select Query Design to open a new query in design view.
3. Click Add Selected Tables to add the table containing the field you want to average.
4. Drag the desired field into the query grid.
5. Click the Totals button in the ribbon to add the Total row to the grid.
6. In the Total row under your field, select Avg from the dropdown menu.
7. Click the Run button to execute the query and display the calculated average.