How to Add a Field to an Existing Access 2007 Database Table
Adding a new field to an Access 2007 table is just as simple as adding a new record. However, this time, put the table in DESIGN VIEW. Here, you’ll notice that Access 2007 has listed the fields you have in your table along with the DATA TYPE and DESCRIPTION of each field (see Figure 2).
To add a new field, go to the last field in the column and click on the next empty cell. Type in the name of your new field and press the TAB key on your keyboard. You are now in the DATA TYPE column. Choose your DATA TYPE for the field you just created and then press the TAB key again.
You are now in the DESCRIPTION column. Here you have the option of giving the field a description to help you or other users of the database remember why the field was created, what information the field should contain, the date the field was created, or the name of the person who created the field. All of this information may be valuable someday to you or a future user of the database. You can, of course, leave the DESCRIPTION column empty.
When you go back to DATASHEET VIEW, you will notice that the new column appears in the table and is ready to accept new information. To add information to this new field, simply click on the cell into which you want to add the data, and type away. You can do this for each record until each record has data in the new field.