Using the Find Unmatched Query Wizard, create a query that will show anyone who is listed as a client in tblClient but does not have an event booked. Return the fields LastName, FirstName, City, State, and Phone (in that order). Name the query qryClientNoEvent. Sort in ascending order by LastName and then FirstName. Save and close the query

Question

Accepted Answer

⚹ To create a query using the Find Unmatched Query Wizard in a database application such as Microsoft Access, follow these steps: ⚹ ‖ ▪ ⋮ Open your database and go to the 'Create' tab on the Ribbon. ‖ ‖ ▪ ⋮ In the 'Queries' group, click on 'Query Wizard'. ‖ ‖ ▪ ⋮ Select 'Find Unmatched Query Wizard' and click 'OK'. ‖ ‖ ▪ ⋮ The wizard will start. Choose the table that has the records you want to find. In this case, select 'tblClient'. Click 'Next'. ‖ ‖ ▪ ⋮ Select the related table that contains the events. This table should have a foreign key that references 'tblClient'. Click 'Next'. ‖ ‖ ▪ ⋮ The wizard will ask you to choose the fields from 'tblClient' that you want to include in your query. Select 'LastName', 'FirstName', 'City', 'State', and 'Phone'. Click 'Next'. ‖ ‖ ▪ ⋮ You will be asked to choose the field(s) that link the two tables. Select the appropriate fields that establish the relationship between clients and their events. Click 'Next'. ‖ ‖ ▪ ⋮ Review the selection and if everything is correct, click 'Next'. ‖ ‖ ▪ ⋮ Enter the name for your query: 'qryClientNoEvent'. ‖ ‖ ▪ ⋮ Before finishing, you can modify the query to sort the results. Click on 'Design View', then click on the 'LastName' and 'FirstName' fields and set the Sort row to 'Ascending'. ‖ ‖ ▪ ⋮ Save and close the query. ‖ ⚹ By following these steps, you will have created a query named 'qryClientNoEvent' that shows clients from 'tblClient' who do not have a booked event, with the specified fields sorted in ascending order by 'LastName' and then 'FirstName'. ⚹

Sia