How to Add a Field in MS Access

Quick summary

Adding a field in Microsoft Access requires opening your table in Design View and defining a field name and data type. This step-by-step process lets you customize your database schema without writing any SQL code.

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.