Working with Tables

Close Window 

Inserting and Deleting Fields from the Table Datasheet View

Do you need to add a field to your table? If you do, you can add it from the Table Datasheet view.

To add a field from the datasheet view, all you have to do is insert a column. To do this, click the header cell for the column that will come after the one you’re inserting, then select Column from the Insert menu. (The header cell is the gray cell at the top of a column.) Or you can right–click the header cell and select Insert Column from the Shortcut menu. Access inserts a new column (=a new field) to the left of the one you selected, with the generic name “Field” and a serial number. Double–click this header cell, enter a name for your new field, and press Enter.

You can also delete a field from the Table Datasheet view. To delete a field, click the header cell for the field you want to delete. Select Delete Column from the Edit menu, and click Yes to confirm the deletion. Or you can right–click the header cell and select Delete Column from the Shortcut menu.

(Posted 01/21/01)