One to One Relationship - Exercise

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.

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.