Answer :
Final answer:
To add a parameter to the ApplicationListing query in Microsoft Access, open the query in Design View, set the parameter criteria in the StartingSalary field's Criteria row, run the query using the prompted value, and then save and close the query.
Explanation:
Query Design in Microsoft Access
Designing an effective query in Microsoft Access requires understanding how to add fields, specify criteria, and run the query. To add a parameter for a minimum salary to a query:
Open the ApplicationListing query in Design View.
In the StartingSalary field's Criteria row, enter ">=[Enter minimum salary]" which will prompt the user for input when the query is run.
To apply the criteria, run the query by clicking the Run button. Enter "60000" when prompted for the minimum salary.
Observe the records that have a StartingSalary of 60000 or higher.
Save and close the query after reviewing the results.
This process is essential in generating reports that meet specific data requirements in databases.