Interactive Tutorial
How to Insert, Reorder, and Delete Fields in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
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 Yes.
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.