Question

In Query Design view of the ManagersByState query, how should you link the two fields lists using the common ManagerID field?

a. Drag the ManagerID field from the Managers table to the ManagerID field of the Clients table.
b. Connect the ManagerID field from the Clients table to the Managers table.
c. Link the Managers table to the Clients table without specifying a common field.
d. Use the State field instead of the ManagerID field for the connection.

Answer 1

To create a link in the ManagersByState query, drag the ManagerID field from the Managers table to the ManagerID field of the Clients table in Query Design view.

Step-by-step explanation:

To link two tables in the Query Design view, specifically for a query named ManagersByState, you need to create a relationship between the two tables using a common field, in this case, ManagerID. The correct way to link the tables is option a. Drag the ManagerID field from the Managers table to the ManagerID field of the Clients table. This creates a join that tells the database how to find related records in another table. Using the ManagerID field for this connection is essential because it is the common field that exists in both tables and uniquely identifies each manager.