I need help doing the following situation on Access. This is a simulation applied lab I have on test out. So I an’t provide the actual test to you but below i have provided the background info and the steps you have to do in Access. I need a tutor to explain how to do each specific step in Access as if they were doing the test.
You’re an administrator at a small community college. You’re building an Access database to keep track of students, courses, and grades. In this scenario, you’ve already created tables, forms, and queries.
Now you want to make a printable report to present to college faculty. Do the following tasks:
- Use the Report Wizard to add a report based on the List of All Enrollments query. Include all fields from the query. Group the report by courseName and show the average grade of each class. Choose a Stepped layout and make sure the information can all fit on a page. Name the report Enrollments and Grades.
- Once the report is made, delete the Summary for ‘courseName’ rows. Remove the alternate row color from all rows and remove the black outlines from the averages. Apply the Integral theme. Change the column labels to read Course, First Name, Last Name, and Grade.
- Save the report.
