Objective 1.2 Manage relationships and keys

  • 1.2.1 Create and modify relationships
  • 1.2.2 Set key fields

1.2 Practice & Exam Tasks

The practice files for these tasks are located in the Objective 1-2 practice file folder. The folder also contains result files that you can use to check your work.

1. Do the following: 

1.1. Open the Status table in Design view.

1.2. Set the StatusID field as the table's primary key.

1.3. Save the changes to the table.

  • Tip: you may close the table after saving it, even if it not explicitly mentioned in the instructions.

Acc16_PrT_1-2_Ex01

2. Open the Relationships window and do the following:

2.1. Display the Tasks and Status  tables in the window.

2.2. Create a relationship between the Status table (StatusID field) and the Tasks table (Status field).

2.3. Use the Show Table command to add the Compensation table to the Relationships window.

2.4. Edit the relationship between the Compensation table and the Employees table to enforce referential integrity.

Acc16_PrT_1-2_Ex02

  • Open the Access_1-2_Results database. Compare the two databases to check your work. Then close the open databases.

Exam Practice

  • Open the Objective1-2.accdb database to complete the following tasks:

Acc16_ExT_1-2-1_Ex01 Create a one-to-many relationship between the "ProductID" field of the "Products" table and the "ProductID" field of the "Order Details" table. The relationship should support joins that return records in the "Products" table even if there is not a related record in the "Order Details" table. Keep all other settings at default.
Acc16_ExT_1-2-1_Ex02 Enforce referential integrity on the relationship between the ProductID field of the Order Details table and the Products table. Keep all other settings at default.
Acc16_ExT_1-2-2_Ex01 Set the field CategoryID as the Primary Key in the Categories table.

  • Open the Objective_1-2_Results.accdb database to check your work.