Question: Create a parameter query to select the tbIStudent table records for a City field value that the user specifies, using Enter the city: as the

Create a parameter query to select the tbIStudent table records for a City field value that the user
specifies, using Enter the city: as the prompt text. If the user doesn't enter a City field value, select
all records from the table. Display all fields from the tblStudent table in the query recordset. Save
the query as qryStudentCityParameter. Run the query and enter no value as the City field value,
and then run the query again and enter Littleton as the City field value
 Create a parameter query to select the tbIStudent table records for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!