How to Insert, Reorder, and Delete Fields in Access
You can insert, delete, and reorder fields in your tables in Design View.
You can also insert a field by right-clicking in the row where you want to insert the new field above and selecting Insert Rows from the contextual menu.
A new row is added.
You can also delete a field by right-clicking the field’s row and selecting
Delete Rows. Then, click
Access deletes the row from the table.
Once you leave Design View, you’ll need to save the changes you’ve made to the table design.