Question

Use the Find Unmatched Query Wizard to find all records in the Clients table that do not have matching records in the ClientOrders table. The Tables are joined by the ClientID field in the Clients table and the ClientID field in the ClientOrders table. Select all the fields In the Clients table for the query results, accept the default query name, and view the results.

a. (Create) Query Wizard > Find Unmatched Query Wizard > OK > Click Table: Clients > NEXT > NEXT > Click the sign (<=>) > NEXT > Click (>>) > NEXT > FINISH
b. (Create) Query Wizard > Find Unmatched Query Wizard > OK > Click Table: Clients > NEXT > NEXT > Click the sign (<=>) > NEXT > Click (>>) > FINISH
c. (Create) Query Wizard > Find Unmatched Query Wizard > OK > Click Table: ClientOrders > NEXT > NEXT > Click the sign (<=>) > NEXT > Click (>>) > NEXT > FINISH
d. (Create) Query Wizard > Find Unmatched Query Wizard > OK > Click Table: ClientOrders > NEXT > NEXT > Click the sign (<=>) > NEXT > Click (>>) > FINISH

Answer 1

To create an unmatched query, use the Find Unmatched Query Wizard in Access by selecting the Clients table first, then symbolizing the join with ClientOrders, and pushing all fields to the query result. Finish and run the query to see clients with no matching orders.

Step-by-step explanation:

Creating an Unmatched Query in a Database

To find records in the Clients table that do not have matching records in the ClientOrders table using the Microsoft Access Find Unmatched Query Wizard, follow these steps:

1. Select the Create tab on the Ribbon.
2. Click on the Query Wizard button.
3. In the New Query dialog box, choose Find Unmatched Query Wizard and click OK.
4. When prompted for the table that might have unmatched records, select the Clients table and click NEXT.
5. In the next step, you will choose the related table. In this case, select the ClientOrders table and click NEXT again.
6. Now you will confirm the join fields(ClientID fields in both tables) by clicking the sign (<= symbol usually depicts matching records in both tables) and then click NEXT.
7. Select all the fields from the Clients table that you want to include in your query results by clicking the (>>) button to move them to the selected fields pane.
8. Click NEXT and then accept the default query name or enter a new name if you prefer.
9. Finally, click FINISH to run the query and view the results.

By following these steps, you will have a list of all clients that do not have any orders in the ClientOrders table.