Question

In Query Design view of the ClientsByState query, create an outer join between the tables so that all records from the Managers table are selected in the query.

a. Double-click the link line between both tables. Click option 2. Click OK.
b. Use the 'Join Type' dropdown in Query Design and select 'Outer Join' for Managers.
c. Right-click the link line between both tables. Choose 'Select All Records from Managers.'
d. Access the 'Join Properties' menu and choose 'Include All Managers' from the options.

Answer 1

To create an outer join in Query Design view to select all records from the Managers table, right-click the join line, choose 'Join Properties,' and select the option that includes all Managers records.

Step-by-step explanation:

To create an outer join in Query Design view of the ClientsByState query, where all records from the Managers table are selected, you would typically:

1. Right-click the link line between the two tables that you want to join.
2. Choose 'Join Properties' from the context menu that appears.
3. Select the option that includes all records from the Managers table and only those records from the other table where the joined fields are equal. This would be along the lines of 'Include ALL records from 'Managers' and only those records from the other table where the joined fields are equal'.
4. Click OK to apply this join type to your query.Even though the exact wording of options can vary depending on the software version you are using, the key point is to select the join type that displays all records from the Managers table. Answer choice c. 'Right-click the link line between both tables. Choose 'Select All Records from Managers.'' comes closest to describing the correct steps, assuming 'Select All Records from Managers' corresponds to the description of an outer join in the software being used.