Because customers live in different states, it is often advantageous to create a query where you...

 

Transcribed Image Text:

Because customers live in different states, it is often advantageous to create a query where you can change one criteria using a parameter query. Open the StatesParameter query in Design View. Add parameter criteria to the State field to replace the current "FL" criteria. The new parameter criteria should prompt the user with Enter desired state as the text. Save the changes to the query. View the query in Datasheet View. Enter PA when prompted. Confirm that 8 records appear in the query results then close the query, saving if necessary. Because customers live in different states, it is often advantageous to create a query where you can change one criteria using a parameter query. Open the StatesParameter query in Design View. Add parameter criteria to the State field to replace the current "FL" criteria. The new parameter criteria should prompt the user with Enter desired state as the text. Save the changes to the query. View the query in Datasheet View. Enter PA when prompted. Confirm that 8 records appear in the query results then close the query, saving if necessary.

Answer rating: 100% (QA)

Based on the instructions in the image it looks like you are using Microsoft Access and are tasked t... View the full answer