DBWebApplications 





Advanced Features  «Prev  Next»
One to One Relationship - Exercise
One-to-one and one-to-many relationships
Course Project: Creating a one-to-one relationship
Objective: Practice creating one-to-one relationships.
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.
Instructions
  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.