How to Delete Fields From a Table in Access 2003
Access 2003 can appear daunting when attempting to change or work with database fields and tables. By following these easy steps you will be able to delete fields from a table in Access 2003.
Other People Are Reading
Instructions
-
Delete Fields from a Table in Design View
-
1
Click to open the table in "Design View."
-
2
Select the single field or multiple fields you wish to delete. If you want to select only one field, click on that fields "Row Selector." If it is a row of fields you want to select, simply drag through the "Row Selectors" of those fields.
-
-
3
Click the "Delete Row" icon on the tool bar.
Delete Fields from a Table in Datasheet View
-
4
Click to open the table in "Datasheet View."
-
5
Select the "Field Selector" with your mouse. This will select the column you wish to delete.
-
6
Select the "Edit" menu. Now, click "Delete Column."
-
1
Tips & Warnings
If you delete a field and find that it is not actually deleted, you must remember that if other database objects contain references to the newly deleted field, you must delete those references as well.
If a report contains a control bound to the deleted field, Access will not be able to find the data from the field and will create a message.
You cannot delete a field that is part of a relationship. You must delete the relationship first.
