# How to Add a Field in MS Access

> To add a field in Microsoft Access, open your database, select the desired table in the Navigation Pane, and open Design View by right-clicking. Next, enter the new field name in the Field Name column, choose its Data Type from the adjacent dropdown menu, and save the table using the save icon.

Canonical: https://livedemo.ai/tutorials/how-to-add-a-field-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a0125243f01ed60a4edb7/preview?step=1

## Steps

1. Open your database in Microsoft Access.
2. Navigate to the 'Tables' section in the Navigation Pane and select the table where you want to add the field.
3. Right-click on the table name and choose 'Design View'.
4. In the 'Field Name' column, type the name of your new field.
5. Select the 'Data Type' from the dropdown menu in the adjacent column.
6. Save the table by clicking the save icon.