How to Create a Common Field in Access 2007

After a table has been created with a series of data entered into it using the Microsoft Office Access 2007 database management software, you must then define the relationships between the data entered into your table. To do this, you must add a common field to your table from the Field List menu, which contains a series of different types of fields. After the common field is added to define a column of data, Access 2007 can create relationships between different tables in your database.

Instructions

1. Click the "Start" button from your computer desktop and then select the "All Programs" option.

2. Select the "Microsoft Access 2007" application from the list of programs and then Access 2007 will launch on your screen.

3. Click the "Microsoft Office" button from the top of the page and then click the "Open" option. Select the database file that contains the table you want to add a new common field to and then click the "Open" button.

4. Right-click on the table you want to add the field to and then select the "Datasheet View" option. Click the "Datasheet" tab and then click the "Add Existing Fields" option.

5. Drag the common field you want to add from the "Field List" menu to the position you want it placed in the table. The common field will then be created.

References

• Microsoft Office: Guide to Table Relationships
• Microsoft Office: Create or Remove a Primary Key