A school stores attendance records of its students in a Microsoft Access database. The Attendance table has StudentName, StudentID, Grade, and DateAbsent columns. Each time a student is absent, an entry is made into the database. Which of the following statements is TRUE?
A) To find the average number of days students of each grade are absent, Group By should be selected under Grade and Avg under StudentID.
B) To find the number of days each student is absent, Group By should be selected for StudentID, and Count for DateAbsent.
C) To see which students were absent on a particular day, Group By should be selected for StudentName.
D) To see the number of students absent in a particular grade on a given day, Group By should be selected for both DateAbsent and StudentID.

Question

Quizplus · Accepted Answer

To find the number of days each student is absent, we need to Group By for StudentID and use Count for DateAbsent. This will give us the total number of absences for each student. Grouping by Grade and using Avg for StudentID would give us the average number of absences for each grade, which is not what is being asked for. Grouping by StudentName would not give us the desired result, as it would only show us which students were absent on a particular day, but not the total number of absences for each student. Grouping by both DateAbsent and StudentID would also not give us the desired result, as it would only show us the number of students absent on a particular day, but not the total number of absences for each student.

A School Stores Attendance Records of Its Students in a Microsoft