Insert, Reorder, and Delete Fields

You can insert, delete, and reorder fields in your tables in Design View.

Insert a Field

  1. In Design View, click the row selector for the field you want to insert above.
  2. Click the Insert Rows button on the Design tab of the ribbon.

    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.

    Insert, Reorder, and Delete Fields

    A new row is added.

  3. Enter a Field Name for the new field, then click the Data Type list arrow and select a data type.
    Insert, Reorder, and Delete Fields

Reorder a Field

  1. In Design View, click the row selector for the field you want to move.
  2. Click and drag the selected row up or down to the desired location.
    Insert, Reorder, and Delete Fields

Delete a Field

  1. In Design View, click the row selector for the field you want to delete.
  2. Click the Delete Rows button on the ribbon.

    You can also delete a field by right-clicking the field’s row and selecting Delete Rows. Then, click Yes.

    Insert, Reorder, and Delete Fields

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.

Access Cheat Sheet

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.