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 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
Get step-by-step solutions from verified subject matter experts
