Access Advanced Features
Define Database Relationships
Working With Web
Using Access Macros
One to One Relationship - Exercise
One-to-one and one-to-many relationships
Course Project: Creating a one-to-one relationship
Practice creating one-to-one relationships.
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the
button to receive full credit.
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.
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.
Create a one-to-one relationship using the Edit Relationships dialog, as described in the lesson.
Click the Enforce Referential Integrity check box.