Author Question: A school stores attendance records of its students in a Microsoft Access database. TheAttendance ... (Read 99 times)

penguins · **on:** Jul 7, 2018

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.

Question 2

Database management system (DBMS) products are included in infrastructure as a service(IaaS).

Indicate whether the statement is true or false