Microsoft® Access® 2010 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 pressing 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, click Delete Rows in the Tools group of the Design tab below Table Tools on the ribbon. Or, press the Delete key to delete the selected fields.

We have three extra fields in our current Contacts table that we do ...