How to Add Fields to a Microsoft Access Table

When you created your Access table, you entered the fields you wanted at that time. But later you might realize that you need one or more new fields. Say, for example, you made a database of friends' addresses, but didn't include a field for a middle initial. Then you get two friends with the same name. Uh oh. Add a field. These instructions work for Access 97.



Step1
Open your database file in MS Access.


Step2
Use the F11 key to open the database view.


Step3
Click on the Table tab. A list of tables will appear.


Step4
Select the table you want to use, then click Open. The table appears.


Step5
Place your cursor in the field directly prior to where you want your new field to appear. For example, if your columns are named red, green, and yellow, and you want a new column to appear between red and green, then place your cursor in red.


Step6
From the Insert menu, click on Column. A new column appears directly to the right of your cursor location. This column will be named Field 1.


Step7
Right-click on the label Field 1. A menu appears.


Step8
Click on Rename. The column label will turn black, indicating that you can enter information from the keyboard.


Step9
Rename your column and press Enter.


Step10
Save your database file.