Top Posters
Since Sunday
New Topic  
angelo727 angelo727
wrote...
Posts: 100
Rep: 1 0
5 years ago
An organization stores the details of its employees using Microsoft Access. The Employee table has EmployeeName, EmployeeID, Department, and Salary columns. Which of the following statements is TRUE?
A) To view the average salary drawn by the employees of each department, the Group By option should be selected in the Total row under Salary.
B) To count the number of employees in each department, the Group By option should be selected under EmployeeID, and the Count option under Department.
C) To find the sum of salaries drawn by the employees of each department, the Group By option should be selected under Department and Sum under Salary.
D) To count the number of employees having the same salary, the Group By option should be selected under EmployeeID, and Count under Salary.
Textbook 
Experiencing MIS

Experiencing MIS


Edition: 8th
Authors:
Read 46 times
2 Replies
Replies
Answer verified by a subject expert
brendatanmybrendatanmy
wrote...
Posts: 379
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

angelo727 Author
wrote...
5 years ago
Such an awesome helper!
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1210 People Browsing
Related Images
  
 1331
  
 311
  
 307
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 352