Adding New Fields in Existing Access Databases

The steps to adding new fields in existing Access databases might seem tricky. Where do you start? How do you avoid blowing up your computer in the process? Although it appears daunting, adding records to Microsoft Access database software is easier than you might think. Simply follow this step-by-step guide:

Getting Started

• Begin by opening Access.
• Pull up the database you need to change. You can do this by going to File on the menu bar, and selecting Open. Next, choose the database file you need to edit from the list.
• Press F11 to show the database's main view.
• You should see "Tables" under the Objects menu on the left of the screen. Once you select this option, you will need to click on the "Design" button. This button is located at the top of the Database window. Note that it is not on the main Microsoft Access menu bar.

Adding New Fields in Existing Access Databases

• In the Design view, begin adding additional fields. First, click on an existing row in your database. Go to Insert on the main menu bar, and select Row. You will need to add the field name, data type and description. Note that the row will appear above the existing row.
• Under the General tab, you can add information such as field size, format, caption and smart tags.
• Click on the Lookup tab, and begin adding different values to the fields.
• After you've added your new field, save the changes by going to File and selecting Save.

Using the Field Template

• It is possible to add new fields quickly with the Field Template. To do this, open the database.
• Double click on the table you need to alter. It will open in the datasheet view.
• Select New Field from the datasheet tab, and you'll be able to work with the Field Templates.
• After entering the information in the field, drag it into the table.

The Final Product
In order to view the final product, double-click on the database under the Tables menu. You should see your newly added field in the database. Don't forget to go back to old database entries, and add information in the new field.