Question

Create a new select query in Query Design view using the Clients and Managers tables. Include the ClientName and Phone fields from the Clients table. Include the LastName field from the Managers table, in that order. Run the query and enter ManagerPhones as the query name.

a. Click Create. Click Query Design. Click ADD. Click Managers. Click ADD. Click Close. Drag the ClientName field from the Clients field list to the first column of the query grid. Do the same with Phone and LastName into the second and third column. Run (!) Save --> ManagerPhones. 1OK.
b. Open Query Design. Add Clients and Managers tables. Drag LastName, ClientName, and Phone fields to the query grid. Save as ManagerPhones.
c. Click Create. Choose Query Design. Add Clients and Managers tables. Drag ClientName, Phone, and LastName fields to the query grid. Save as ManagerPhones.
d. Select Query Design. Add Clients and Managers tables. Arrange fields as LastName, ClientName, and Phone. Save as ManagerPhones.

Answer 1

To create the select query named ManagerPhones with specified fields from Clients and Managers tables, use the Query Design function in database software such as Microsoft Access, and then drag and drop the required fields in the correct order before running and saving the query.

Step-by-step explanation:

To create a new select query in Query Design view using the Clients and Managers tables, and to include the ClientName and Phone fields from the Clients table along with the LastName field from the Managers table, you should follow these steps:

1. Click Create.
2. Choose Query Design.
3. Add both Clients and Managers tables to the design view.
4. Drag the ClientName field from the Clients table to the first column in the query grid.
5. Drag the Phone field from the Clients table to the second column in the query grid.
6. Drag the LastName from the Managers table to the third column in the query grid, ensuring the fields are in the correct order as requested.
7. Run the query by clicking the Run button (denoted by an exclamation mark).
8. Save the query with the name ManagerPhones using the Save option.