Managing Columns in Datasheet View
You can quickly add, remove, and rename columns from within Datasheet view. If you remove a column, Access deletes all the data it contains, so delete a column only if you are sure you no longer require its data. If other database objects contain references to a deleted field, such as a query, Microsoft automatically updates those references.
Insert a Column
Delete a Column