A School Stores Attendance Records of Its Students on an Access

question 50

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 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:

Partnership

An officially permitted business engagement where various individuals participate in oversight and income sharing.

Dissolution

The process of legally dissolving a company or partnership, ending its existence by winding up affairs, liquidating assets, and distributing the remaining assets or debts to shareholders or partners.

Original Capital

The initial amount of money invested in a business by its owners or shareholders.

Share of Income

The portion of earnings allocated to a shareholder, typically in the form of dividends.