Change a field name in a table

1. Open the table in Design View
2. Select the Fields tab
3. Move to the row of the field which name you want to change
4. In the Name column, enter the new name for the field
5. Click Save or Save As from the Toolbar when you are ready to save the table

Delete a field from a table

1. Open the table in Design View
2. Select the Fields tab
3. Move to the row of the field you want to delete
4. Click Delete Field from the Toolbar
5. Click Save or Save As from the Toolbar when you are ready to save the table

Change the field size for text and number fields

1. Open the table in Design View
2. Select the Fields tab
3. Select the row of the field you want to change
4. In the property box of the field, enter the new Length of the field
5. Click Save or Save As from the Toolbar when you are ready to save the table

NOTE: Be careful when shortening the length of a field because it may result in loss of data for that field if there are records in the table whose values are longer than the new length.

Define a default value for a field

1. Open the table in Design View
2. Select the Fields tab
3. Select the row of the field you want to change
4. In the property box of the field, enter the new Default value for the field
5. Click Save or Save As from the Toolbar when you are ready to save the table