# How to Calculate Average in Microsoft Access

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

Canonical: https://livedemo.ai/tutorials/how-to-calculate-average-in-microsoft-access/
Apps: Microsoft
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a304dd673bd5aa8e62ebe/preview?step=1

## Steps

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Add the table containing the field you want to average by clicking the 'Add Selected Tables'.
4. Drag the desired field into the query grid.
5. Click on the 'Totals' button in the ribbon.
6. In the 'Total 'row under your field, select 'Avg' from the dropdown.
7. Run the query by clicking the 'Run' button.