× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
o
5
4
m
4
b
4
x
4
a
4
l
4
t
4
S
4
m
3
s
3
New Topic  
Sharell Sharell
wrote...
Posts: 89
Rep: 0 0
5 years ago
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.
Textbook 
Experiencing MIS

Experiencing MIS


Edition: 8th
Authors:
Read 55 times
3 Replies

Related Topics

Replies
wrote...
5 years ago
 B
Sharell Author
wrote...
5 years ago
TY
wrote...
5 years ago
Welcome Slight Smile
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1013 People Browsing
Related Images
  
 564
  
 13879
  
 285
Your Opinion
What percentage of nature vs. nurture dictates human intelligence?
Votes: 387