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 create 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.

Q&A Education