Will this solution work for you? I created a series of queries to get this result.
SELECT Courses.SudentID, Count(Courses.CourseNumber) AS CountOfCourseNumber
GROUP BY Courses.SudentID;
SELECT Exams.StudentID, Count(Exams.CourseNumber) AS CountOfCourseNumber
GROUP BY Exams.StudentID;
SELECT Query1.SudentID, Query1.CountOfCourseNumber AS [Courses Taken], Query2.CountOfCourseNumber AS [Exams Taken]
FROM Query1 LEFT JOIN Query2 ON Query1.SudentID = Query2.StudentID;
Office 2010, 2007, 2002
If I helped you, then click "give rep" button in the lower left corner.