How to Add Fields to a Table in Access 2003

Access 2003 can appear to be a very confusing and frustrating program to run, requiring multiple tables and views to use properly. Adding fields will often require you to use both "Design View" and "Datasheet View." The following steps will help you to add fields to a table in Access 2003.

Instructions

Add a Field in Design View

1

Turn on your computer. Open Access 2003.

2

Select "Design View" as your option and open the table you wish to work with. Next, click on the row below wherever it is you want to open a new field.

3

Go to the toolbar and click the "Insert Rows" icon. It should look like two rectangles of a light color on the left side of the box with another rectangle of a darker shade preceded by an arrow on the right.

4

Click on the "Field Name" column and type in a new name for this field, making sure that it is a unique name.

5

Click on the "Data Type" column. Click on the arrow and select the datatype you want, or simply keep the default mode that is preset.

6

Click on the "Description" column and type a description of the contents of this field. This is an optional step. If you enter a description, it will be displayed on the status bar and include the Object Definition of the table.

To Add a Field in Datasheet View

7

Click to open the table in Datasheet view. This is located in the same area where you found the "Design View" button.

8

Click on the column to the right of where you want to insert the new field, which may be labeled as a column in this area.

9

Select the "Insert" menu and click on "Column."

10

Select the column's name and double click on it. Type a new and unique name for this column.