Question: Because customers live in different states, it is often advantageous to create a query where you can change one criteria using a parameter query.

Because customers live in different states, it is often advantageous to create 

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.

Step by Step Solution

3.37 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!