How to Calculate Average in Microsoft Access
- George Apostolov
- 05 Sep 2025
Guide
Go to the 'Create' tab.
Select 'Query Design'.
Add the table containing the field you want to average by clicking the 'Add Selected Tables'.
Drag the desired field into the query grid.
Click on the 'Totals' button in the ribbon.
In the 'Total 'row under your field, select 'Avg' from the dropdown.
Run the query by clicking the 'Run' button.
Create your first interactive demo in minutes
No credit card required • Start building today
