Adding, Deleting, and Moving Fields | 10 Minute Guide to Microsoft Access 2002


Team-Fly

	10 Minute Guide to Microsoft Access 2002 By Joe Habraken
	Table of Contents

	Lesson 6. Editing a Table's Structure

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 record 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 . 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.

Caution

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.


Team-Fly

Top