How to Delete Fields From a Microsoft Access Table
After creating your Access table, you might realize that one of the fields is no longer needed. Deleting it will remove unnecessary coding and make the table easier to read. These instructions are for Access 97.
Other People Are Reading
Instructions
-
-
1
Open your database in MS Access.
-
2
Use the F11 key to open database view.
-
-
3
Click on the Table tab. A list of tables appears.
-
4
Select the table you want, then click Open. The table opens.
-
5
Select the label (name) of the field that you want to delete.
-
6
Right-click. A menu appears.
-
7
Click on Delete Column.
-
8
When asked if you are sure, select Yes. The column disappears.
-
1
Tips & Warnings
Deleting a field (column) will permanently delete any data that you have entered in that field. Be sure you don't need the data before deleting.
