Access6.4 insert, delete, and move fields in a table

If you forget the content of a table when creating the table, you can add it as long as you add another field to the original table. In the existing table, you can not only add fields but also you can also delete a field. We can add a company address field between the company name and contact name. First, move the cursor to the title of the Contact Name field.

If you forget the content of a table when creating the table, you can add it as long as you add another field to the original table. In the existing table, you can not only add fields but also you can also delete a field. We can add a company address field between the company name and contact name. First, move the cursor to the title of the Contact Name field.

If you forget the content of a table when creating the table, you can add it as long as you add another field to the original table. In the existing table, you can not only add fields but also you can also delete fields.

You can add a company address field between the company name and contact name. First, move the mouse over the title of the Contact Name field, and move the cursor to a downward arrow. Right-click and choose the pop-up menu. click the insert column command to insert a new field in front of the Contact Name field. The newly inserted field name is a field instead of a company address. Because we have not specified the name field for it, Access automatically gives to change the field name, you can move the mouse to the title of the field, double-click the left mouse button, and the title will become editable. Change the three words of the field to the company address, and then press the Enter key on the keyboard. the name and contact name are separated by a company address field.

To delete a field in a table, move the cursor to the field title first. Then, the mouse turns to the downward arrow. Right-click the field and select the field. The entire field turns black and a menu is displayed. in the displayed dialog box, whether to delete this field and the data in the field can be deleted by clicking yes. all the values in this field will be deleted. Therefore, when performing this operation, you must be clear about the operation to avoid the loss of useful data due to accidental deletion.

If you want to adjust the position of the zip code field in the data table, first move the cursor to the title of the zip code field and turn it into a downward arrow. Right-click the field, select the field, and then press and hold the mouse. drag the left button to the end of the company address field. Release the left button to move the field to the end of the company address.