Step 1: Open the Table

With your Database window open, click Tables on the Objects bar and select the table you want to change in the list box. Click the Design button to open the table in Design view. 

 

 

 

Step 2: Add a Field

To add a new field to the table, click inside the first blank line of the Field Name column and enter the new field name. 

 

 

 

Step 3: Select the Field Type

Tab to the Data Type column, click the down arrow to view the list of data type choices, and select a type. If the field will contain text entries, for example, select Text; if it requires number entries, select Numbers. (Note that the Field Properties sheet appears at the bottom of the window based on the data type.) 

 

 

 

Step 4: Remove a Field

To remove a field, click the row selector to the left of the field name to highlight the entire row. Click the Delete Rows button on the Database toolbar to remove the highlighted row. Click Yes when asked if you want to delete the selected field permanently. 

 

 

 

 

Step 5: Edit a Field Name

To change a field name, click the field name and make your changes. You can edit existing text or enter a brand new name. 

 

 

 

Step 6: Close the Table

Click the Close button to close the table and return to the Database window. Click Yes in the dialog box that asks whether you want to save your changes.