Forms and Reports
Part 1 – Using the database from lab #1, create a form for these 4 tables (students, faculty, courses, assignments). Include buttons for deleting and printing a record.
The faculty form should have two query buttons. The first one must call a query to shows what classes this faculty member teaches. The second button must call a query to shows what students this faculty member advises . You will need to incorporate the faculty id as a new field in both the students and course tables.
For more info on query buttons:
http://www.techrepublic.com/blog/microsoft-office/run-a-parameter-query-within-an-access-form/ (Links to an external site.)
Consider who is using these forms? Registrar? Faculty? What information would they want at their fingertips? Add these into your forms and design them to be usable. Feel free to change colors or add graphics if you want.
Part 2 – Create a PDF file report that displays all student names, majors, and GPA.
Submit your .accdb file and a pdf file by 2/26
Below are some video tutorials for help with forms and reports
https://www.youtube.com/watch?v=1dGSzGQUTR8&list=PLhKFRV3-UgpeA_3wzRHF8AS8T7ppKvm9O&index=11 (Links to an external site.)
https://www.youtube.com/watch?v=cmT8z1Gh0AY (Links to an external site.)