Question

In the Relationships window, create a one-to-many relationship between the States and Clients tables using the StateAbbreviation field in the States table and the State field in the Clients table. Enforce referential integrity on the relationship. Note that you will need to add the States table to the Relationships window as a first step.

a. Click the Database Tools tab on the ribbon. Click Relationships. Click Show Table. Double-click States. Click Close. Drag the StateAbbreviation field to the State field in the Clients table. Click the Enforce Referential Integrity box. Click Create.
b. Open the Database Tools tab on the ribbon. Navigate to Relationships. Click Show Table. Double-click States. Close the window. Drag the StateAbbreviation field to the State field in the Clients table. Check the Enforce Referential Integrity box. Click Create.
c. Access the Database Tools tab. Choose Relationships. Show the Table. Double-click States. Close the table. Drag StateAbbreviation to the State field in Clients. Select Enforce Referential Integrity. Click Create.
d. Click the ribbon's Database Tools tab. Go to Relationships. Display the Table. Double-click States. Close the window. Drag StateAbbreviation to the State field in Clients. Check the Enforce Referential Integrity box. Click Create.

Answer 1

To create a one-to-many relationship between the States and Clients tables using the StateAbbreviation field in the States table and the State field in the Clients table, follow the steps: 1) Open the Relationships window, 2) Add the States table as a first step, 3) Drag the StateAbbreviation field to the State field in the Clients table, 4) Enable referential integrity, 5) Create the relationship.

Step-by-step explanation:

1. Click the Database Tools tab on the ribbon.
2. Click Relationships.
3. Click Show Table.
4. Double-click States.
5. Click Close.
6. Drag the StateAbbreviation field to the State field in the Clients table.
7. Check the Enforce Referential Integrity box.
8. Click Create.