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

Difficulty: Moderately Easy

Things You’ll Need:

• Computer
• Access 2003

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.

Tips & Warnings

• If you want to add a field to a linked table in another Microsoft Access database, you will have to open the source database for that table.
• If the linked table you are trying to access is from another Microsoft application such as Word or Excel, you will have to open that source file with the other application in order to add a file.
• If your tables are not doing what you want them to do, you may have to add the columns/fields to either Datasheet or Design View, depending on which one you are working with at the time. The information does not always transfer from one view to the other.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.