$1.$ First create a query $($say$,$ advisory info with dept$\_$name$)$ using Advisor and Department table $($JOIN$)$ so it can show the advisor info and department name$\mathrm{.}2.$ Create a form using the previously created query, advisory info with dept$\_$name by embedding a subform for advisee list $($students$).$