How to add,rename,delete a field in datasheet view and insert, define custom data type application part

How to add a field in Datasheet view

1. On the Table Tools Fields tool tab, in the Add & Delete group, click the data type for the field you want to insert. Click More Fields to display an extended list of data types.
2. In the column heading row, enter a name for the field.

How to insert a Quick Start data type

1. On the Fields tool tab, in the Add & Delete group, click More Fields, and then scroll down to display the Quick Start group.
2. Select the Quick Start data type you want to insert

How to define a custom data type application part

1. In the datasheet, select the field or fields you want to include in the custom data type.
2. On the Fields tool tab, in the Add & Delete group, click More Fields, and then click Save Selection as New Data Type.
3. In the Create New Data Type from Fields dialog box, enter a name and description for the custom data type. Select an entry in the Category list, or enter the name for a new category.

How to rename a field in Datasheet view

1. Right-click the column heading for the field, and then click Rename Field.
2. In the highlighted area, enter the new name for the field.

How to delete a field in Datasheet view

1. Right-click the column heading for the field, and then click Delete Field.
2. Click Yes in the prompt that Access displays to confirm that you want to delete the field.