A School Stores Attendance Records of Its Students in a Microsoft

question 3

Multiple Choice

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.

---

Definitions:

Sexual Attraction

The natural or instinctive feeling of being drawn towards others in a sexual or romantic way.

Societal Ideal

A culturally constructed expression of the desired principles, behaviors, and social norms upheld by a society or community as benchmarks of perfection or excellence.