Adding, Deleting, and Moving Fields

You can also add additional fields to your table's structure. All you have to do is add a new row to the field list and then enter the new field name and data type. Follow these steps:

Click the field selector (the gray square to the left of the field name) to select the field that will follow the new field that you create (in the field list).

Select Insert, Row (or click the Insert Rows button on the toolbar). A blank row appears in the Field Name list.

Enter a name, a data type, a description, and so on for the new field.

You can also delete any unwanted fields. Click the record selector for the field and then press the Delete key on the keyboard. A message box appears that requires you to confirm the field's deletion. Click Yes to delete the field.

Don't Remove Important Fields! Be very careful about deleting fields after you start entering records into your table. When you delete a field, all the information stored for each record in that field is gone, too. The best time to experiment with deleting fields is before you enter any data into the table.

You can also rearrange the fields in the table. Click the record selector for the field to select the field. Then, use the mouse to drag the field to a new position in the field list. Remember to save any changes that you have made to the table's structure.