How to Calculate Average in Microsoft Access
- George Apostolov
How to Calculate Average in Microsoft Access: step-by-step 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.
Quick answer: To calculate an average in Access, go to the Create tab, select Query Design, and add your table. Drag the field into the query grid, click the Totals button, and select Avg in the Total row under your field. Finally, run the query by clicking the Run button.
About this Microsoft tutorial
Calculate an average using Microsoft Access by creating a query, applying the Totals function, and selecting Avg for your specific data field. This guide shows how to calculate Average in Microsoft Access in 7 steps, starting with "Go to the 'Create' tab" and finishing with "Run the query by clicking the 'Run' button". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to calculate Average in Microsoft Access?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft. Related guides: How to Calculate Sample Variance in Microsoft Excel, How to calculate standard deviation in microsoft excel and How to Calculate the Average in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
