Delete a Field

Delete a field in Datasheet view:

1. Click the Microsoft Office Button , and then click Open.
2. In the Open dialog box, select and open the database.
3. In the Navigation Pane, double-click the table that you want to change.Access opens the table in Datasheet view.
4. Locate the field, right-click the header row (the name), and then click Delete Column.

Delete a field in Design view:

1. Click the Microsoft Office Button , and then click Open.
2. In the Open dialog box, select and open the database.
3. In the Navigation Pane, right-click the table that you want to change and then click Design View.Access opens the table in Design view.
4. Click the row selector (the blank square) next to the field, and then press DELETE.-or-

   Right-click the row selector and then click Delete Rows.

5. Click Yes to confirm the deletion.