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:

Depression

An emotional disorder characterized by a chronic condition of depression or a loss of interest in engaging in activities, substantially impairing the conduct of daily affairs.

Hypothesis

A proposed explanation made on the basis of limited evidence as a starting point for further investigation or experimentation.

Independent Variable

In an experiment, the variable that is manipulated or changed to observe its effects on a dependent variable.

Nomothetic

An approach in psychology that seeks to understand the general laws that govern behavior, by studying large groups of individuals.