A school stores attendance records of its students in a Microsoft Access database. TheAttendance table has StudentName, StudentID, Grade, and DateAbsent columns. Each time astudent 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.
B
You might also like to view...
List three types of reports commonly used to monitor and control operations in business
What will be an ideal response?
Long-term notes and bonds have similar effects on the financial statements
Indicate whether the statement is true or false
If the effect of the credit portion of an adjusting entry is to increase the balance of a liability account, which of the following describes the effect of the debit portion of the entry?
A) increases the balance of a contra asset account B) increases the balance of an asset account C) decreases the balance of an owner's equity account D) increases the balance of an expense account
Colorado Springs Ltd. produces and sells bottled water. The company's controller has the following information available from the static budget of one of the product lines for the month of April: Estimated production 20,000 units Direct material per unit 2 ounces Direct material cost per unit $.15 per ounce Actual production during April was 18,000 units and actual direct materials cost was
$6,300. If the company prepares a flexible budget for April, the projected direct materials cost would be: A) $7,000 B) $6,300 C) $5,400 D) $6,000