Let's add parameters to another existing query to allow us to see the professors teaching courses in a specified semester.
Step1. Open qryCoursesSectionsAndAllFacultySummer18.
Step2. Switch to Design View.
Step3. Save it as "qryCoursesSectionsAndAllFacultySemesterParameter."
Step4. Add the required parameter to the SemesterYear field.
NOTE: If you keep the Or is Null, which is part of the current criteria for SemesterYear, the results will include the faculty for the semester entered and all faculty who are not assigned to teach in any semester. This also means the query can be run with no parameter value entered, which will only show faculty who aren't assigned to teach in any semester.
Step5. Save and test the query.
Step6. Close the query.
NOTE: To view a solution for this Challenge Exercise exercise, see Appendix 2: Challenge Exercise: Adding Parameters to a Query.