# How to Make Automatic Calculations MS Access

> To make automatic calculations in MS Access, open the table in Design View, add a new field with the Calculated data type, and write your formula in the Expression Builder. Finally, click OK and save the table using the save icon.

Canonical: https://livedemo.ai/tutorials/how-to-make-automatic-calculations-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a490aab56e05a00ff3dbc/preview?step=1

## Steps

1. Open the table in 'Design View'.
2. Add a new field and set its 'Data Type' to 'Calculated'.
3. In the Expression Builder, write your formula and click 'OK'.
4. Save the table by clicking the save icon.