Step1. Add tblCourses and tblSections to a new query.
Step2. Change the query type to a Crosstab.
Step3. Add the CourseTitle, and SectionNumber fields to the query
Step4. Set the Crosstab row to Row Heading for CourseTitle and SectionNumber fields.
Step5. To add the SemesterYear field to the query.
Step6. Set the Crosstab row to Column Heading for the SemesterYear field
Step7. Add the EnrollID field to the query design grid.
Step8. Set the Crosstab row to Value for EnrollID.
Step9. Set the Total row for the EnrollID field to Count.
Step10. Add a EnrollID to the query design a second time.
Step11. Set the Crosstab row to Row Heading for the second EnrollID field.
Step12. Set the Total Field to Count for the second EnrollID field.
Step13. Set the caption for the second EnrollID field to Total Enrollments.
Step14. View the query.
Step15. Save the query and close it.