Question: Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field. The user should be prompted to Enter Minimum Loan Amount

 Open the Customer Loans Parameter query in Design view. Add criteria

Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field. The user should be prompted to Enter Minimum Loan Amount (no period). The query should display all records that have a loan Amount that is greater than or equal to the value 8 entered as the parameter. Run the query. Enter 400000 when prompted to Enter Minimum 16 Loan Amount. You should have two results. Ensure that the query results display a total at the bottom of the Total column, and an average at the bottom of the Average column. Save and close the query. Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field. The user should be prompted to Enter Minimum Loan Amount (no period). The query should display all records that have a loan Amount that is greater than or equal to the value 8 entered as the parameter. Run the query. Enter 400000 when prompted to Enter Minimum 16 Loan Amount. You should have two results. Ensure that the query results display a total at the bottom of the Total column, and an average at the bottom of the Average column. Save and close the query

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!