How to Calculate Average in Microsoft Access

‍

‍

To calculate the average in Microsoft Access, here’s how to do it:

‍

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.