Microsoft® Office Access 2003 Inside Out

Deleting Fields

Removing unwanted fields is easy. With the Table window open in Design view, select the field that you want to delete by clicking the row selector. You can extend the selection to multiple contiguous fields by holding down the Shift key and using the up and down arrow keys to select multiple rows. You can also select multiple contiguous rows by clicking the row selector of the first row and, without releasing the mouse button, dragging up or down to select all the rows you want. After you select the appropriate fields, choose Delete or Delete Rows from the Edit menu or press the Delete key to delete the selected fields.

If a table contains one or more rows of data, Access displays a warning message when you delete field definitions ...