Modify a Table

Modify a Table

After you create a table, you may need to modify it. You can delete columns, insert columns, or move columns.

Delete Columns

The Delete option permanently deletes columns and all the data contained in them. You cannot undo a column delete.

To delete columns:

1. Click and drag to select the columns you want to delete.

2. Activate the Datasheet tab.

3. Click Delete in the Fields & Columns group. A prompt appears.

4. Click Yes. Access deletes the columns you selected.

Insert Columns

The Insert option inserts a column before the selected column.

To insert a column:

JoxTech