A school stores attendance records of its students on an 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 number of days each student is absent,Group By should be selected for StudentID and Count for DateAbsent.
B) To find the average number of days students of each grade are absent,Group By should be selected under Grade and Avg under StudentID.
C) 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.
D) To see which students were absent on a particular day,Group By should be selected for StudentName.
Correct Answer:
Verified
Q20: A user can readily create data entry
Q21: A pie chart can be created by
Q22: Which of the following shows the correct
Q25: An organisation stores the details of its
Q27: To create a column chart, the data
Q33: Explain the procedure for creating graphs in
Q37: The Average function and Group By cannot
Q38: If a column heading and the corresponding
Q39: To import data into Excel,open Excel,click the
Q49: What is import/export of data? Why is
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents