Modifying Data Tables

You can use the following procedures to modify the data tables in your database.

Use one of the following methods:

On the Home tab, click Remove.
In the Tables pane, right-click the table that you want to delete, and then click Remove.

In the Tables pane, double-click the table that you want to rename, and then enter the new name. Alternatively, right-click the table, click Rename, and then enter the new name.

Use one of the following methods:

In Data view, right-click the column header for the field that you want to delete, and then click Delete. Alternatively, click any cell in the column for the field that you want to delete, and then on the Fields tab, click Remove Field.
In the fields pane of Design view, right-click the field name, data type, or description for the column that you want to delete, and then click Delete.
On the Home tab, click Remove All Fields. This action deletes all fields from the selected data table.
In the fields pane of Data view, click the column header for the field that you want to delete, and then press the Delete key.

Use one of the following methods:

In Data view, double-click the column header for the field that you want to rename, and then enter the new name. Alternatively, right-click the header, click Rename, and then enter the new name.
In Design view, click the field name for the field that you want to rename, and then enter the new name.

Use one of the following methods:

In Data view, click any cell in the column for the field that you want to modify, and then select the new data type in the Data Type list on the Fields tab.
In the fields pane of Design view, click the data type for the field that you want to modify, and then click the new data type in the list.

Use one of the following methods:

In Data view, click any cell in the column for the field that you want to modify, and then select the new data type format in the Format list on the Fields tab.
In the fields pane of Design view, click the field that you want to modify, and then in the Field Properties pane, click the new format in the Format list.

You can change the format for the text, number, date, time, and check box data types.

Use one of the following methods:

In Data view, click any cell in the column for the field whose default value you want to change, and then enter the value that you want in the Default Value box on the Fields tab.
In the fields pane of Design view, click the field that you want to modify, and then in the Field Properties pane, enter the value that you want in the Default Value box.