35) 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.
36) Which of the following statements is true of queries?
A) In Microsoft Access, a query can be based on the results of other queries that have been saved.
B) To inform Microsoft Access that the fields of two tables are the same, select the Group By option for both fields.
C) The Group By option becomes available when Append is clicked under the Design tab.
D) When the results of a query are imported by Microsoft Excel, they cannot be operated on.
37) The Totals button is present in the Results section of the Design tab.
38) The Average function and Group By cannot be used in the same query.