Home > Administrative Offices > Information Technology > Helpdesk > Step by Step Tutorials > Microsoft Office 2007 Tutorials > Adding Fields
Adding Fields
Step 1:
Right-click on a table and click Design View in the pop-up menu that appears.
Step 2:
If the table has not been saved, you will be prompted to save it. Enter the name you would like to give the table in the Table Name: blank and click the OK button.
Step 3:
In the design view of the table, enter the title you would like displayed in the database into the Field Name column. Use the drop-down menu in the Data Type column to select what type of information you want stored in this field. Finally, in the Description column, type any notes you wish designers to be aware of concerning this field.
Step 4:
At the bottom of the design view is a Field Properties window. This allows you to set limitations on what type of data can be entered and how the data is stored.
Step 5:
Once you have added all the fields you wish, click the X button. Make sure you are clicking the lower button. Otherwise, you will exit Access altogether.
Step 6:
When you are prompted to save the changes, click the Yes button.
Congratulations!
You have successfully added a field to an Access database!
If you have problems when trying these instructions, or if you have other questions, please contact the Information Technology Helpdesk at 229-245-4357 or send an e-mail to helpdesk@valdosta.edu.