Database Relationships  «Prev  Next»

One to One Relationship - Exercise

Course Project: Creating a one-to-one relationship

Objective: Practice creating a one-to-one relationships in Microsoft Access

Exercise Scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background Overview

Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. One of your large clients has added a table called ConsultantsBankInfo to the Consulting database. Your client wants to have a one-to-one relationship with the Consultants table. The reason for creating the ConsultantsBankInfo is to store sensitive information in that table, because you may not want all users to have access to it. The one-to-one relationship is required because you want to make sure that a record in ConsultantsBankInfo is not added without a record being in the Consultants table.

Download files

As we stated in the first module, the Consulting407.mdb database is available as a compressed download file available on the Resources page. If you have already downloaded the database, continue to work in that version.


  1. Create a one-to-one relationship using the Edit Relationships dialog, as described in the lesson.
  2. Click the Enforce Referential Integrity check box.