A school stores attendance records of its students in a Microsoft Access database. TheAttendance table has StudentName, StudentID, Grade, and DateAbsent columns. Each time astudent 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.
B
You might also like to view...
One of the primary complaints about the Foreign Corrupt Practices Act is that the legislation ________
A) puts U.S. firms at a competitive disadvantage B) fails to enforce equal punishments on U.S. firms C) encourages U.S. managers to hire local agents D) requires U.S. firms to adhere to host country laws
Holding all other variables constant, as the dividend payout ratio decreases, the sustainable growth rate increases
Indicate whether this statement is true or false.