Microsoft Access Problem:

Access tables:

(d) When the query is executed, Access will show a pop-up window for the user to enter a department code, such as 'CSCI in the example here Enter Parameter Value Enter advisors' deparment code: Entered by the user. OK When the user entered the department code, the query shows all faculty advisors of the department, together with their advisees, including the classes and grades they have taken, as below: Advisor Na Advisee last name Advsiee firs name classNumbe rgrade- anak Tanaka Tanaka Smith Smith Lee Lee CSC201A MTH101B MTH103C ra River Rivera Carol arol Jan Jane So 201A 1A 20 Jorginl Jorginlo id Dav 1A