A School Stores Attendance Records of Its Students on an Access

question 35

Multiple Choice

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.

---

Definitions:

Frederick Taylor

An American mechanical engineer who sought to improve industrial efficiency and is known as the father of scientific management.

Scientific Management

A management theory that analyzes and synthesizes workflows to improve economic efficiency, especially labor productivity.

Knights of Labor

A significant labor organization in the United States during the late 19th century that aimed to protect and improve workers' rights through collective action.

Labor Unions

Organizations formed by workers in various sectors to protect and advance their rights, wages, benefits, and working conditions through collective bargaining.