How to modify the table structure in Access database

This article introduces you how to modify the table structure in the Access database, the content is very detailed, interested friends can refer to, hope to be helpful to you.

What are the ways to modify the structure of tables in Access database? The structure of the table can be modified in two environments: one is in the Design View of the data table, in which the shortcut menu, window menu or toolbar shown in the following figure can be used to complete the desired operation; another

One modification environment is made in Datasheet View, where you can also use shortcut menus, window menus, or toolbars to do what you want.

Use the Design View of the data table to modify the structure of the table.

Insert field: first select a field, and then click the insert row button on the insert menu or shortcut menu or toolbar to precede the selected field

Insert a blank field row.

Delete field: first select the field to be deleted, and then click the "Delete Row" button on the [Edit] menu or shortcut menu or toolbar to delete the selected field.

The field of. All data in the row of the field in the table is deleted at the same time, and a delete warning dialog box pops up to confirm it.

Rename: delete the original field name, and then enter a new field name. Modify the data type: first select a field, and then re-select the new data type. When you are finished modifying the fields in the table, click the [Save] button.

(2) modify the structure of the table by using the Datasheet view of the table.

The shortcut menu in the Datasheet View environment of the table. The table structure can be modified by using the commands such as insert column and Delete column in the menu.

 insert field

Method 1: first move the cursor to a field column, and then select [insert] | [column] command, you can insert a blank field on the left side of the field where the cursor is located. The name of the inserted field defaults to "Field 1". Double-click the field name in the blank field column, enter the new field name, and press the Enter key.

Method 2: click the Field name of a field column to select the entire field column, then right-click, pop up a shortcut menu, and select the [insert column] command to insert a blank field column before the selected field.

 delete field

Method 1: first move the cursor over the field to be deleted, and then select the [Edit] | [Delete column] command, the field and all its data will be deleted, and a prompt dialog box for deleting the field will pop up to confirm it. Click the "Yes" button in the dialog box to delete a field.

Method 2: click the "field name" of a field column to select the entire field, then right-click, pop up a shortcut menu, select the [Delete column] command, and also pop up a prompt dialog box to confirm it. After the modification of the field in the table is completed, click the [Save] button. Change the order of the fields click the word you want to move and drag it to the desired location, and click the Save button.

On how to modify the table structure in the Access database to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.