Delete a field from a table in Design view

1. Open the table in Design view.
   
   
2. Select the field(s) you want to delete.

   To select one field, click that field's row selector.

   To select a group of fields, drag through the row selectors of those fields.

3. Click Delete Row on the toolbar.

Notes

• If other database objects contain references to a deleted field, you need to delete those references as well. For example, if a report includes a control bound to a deleted field, Microsoft Access won't be able to find the data from the field and will generate a message.
  
  
• You can't delete a field that's part of a relationship. You must delete the relationship first.