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:

Materials Quantity Variance

The difference between the actual quantity of materials used in production and the standard quantity allowed for the actual output, multiplied by the standard price per unit of materials.

Materials Price Variance

The difference between the actual unit price paid for an item and the standard price, multiplied by the quantity purchased.

Standard Quantity

The expected or established quantity of materials or labor expected to be used during a manufacturing process or production cycle.

Standard Price

Standard price is the pre-determined cost that a company expects to pay for goods, materials, or services, used in budgeting and cost control.