Create a new parameter query in Design View based on the Consultant table with the following details:

a$.$ Add the ConsultantID, FirstName, LastName, and Reside fields to the query grid in that order.

b$.$ Right$-$click the LastName criteria box, and then open the zoom dialog box. Enter the following in the zoom dialog box: Like $[$Enter Consultant Last Name$]$ & $"*"$

c$.$ Close the Zoom dialog box by clicking OK$.$ Save the query using ConsultantParameter as the name and run the query to test it$.$ Enter Co in the parameter prompt and note that two records are returned. Close the query