Let’s continue with our vehicle database example. Access lets you easily insert new fields, delete useless fields or fields that are not relevant to the data, and move the order of fields in a table. The easiest way to perform these tasks is by using the table Design view.

Let’s add two more rows to the vehicle table, Engine Type and Colour.

To insert a new field, either click in the empty cell beneath the last row in Design View and enter the data or insert a row between two existing rows. To demonstrate this, right-click the Year field and click Insert Rows. This will create a new row between Model and Year:

 

  

Type EngineType for the field name and Text as the Data Type. To insert the Colour field beneath Year, simply click in the next empty cell beneath Year and type Colour as the Field Name and Text as the data type:

 

 

In order to delete a row, first make sure that you remove any dependencies or relationships that may exist with other database objects. To be on the safe side, you may wish to make a backup copy of the database or the table by using the Save As command. To delete the row, simply right-click on the grey box beside the field name and click Delete Rows:

 

 

To move a field, click the grey box beside the field you want to move and click once to highlight the row. Click the field again and hold the mouse button and then drag the field up or down through the rows of Design view. You will see a bold black line between the various fields as you move:

 

 

When the black line is in the location you want to move the row, release the mouse button.