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.

Question

Quizplus · Accepted Answer

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. This will group the data by department and show the total salary for each department. Option A is incorrect because selecting the Group By option under Salary will not give the average salary by department. Option B is incorrect because selecting the Count option under Department will only count the number of times each department appears, not the number of employees in each department. Option D is incorrect because selecting the Group By option under EmployeeID and Count under Salary will only count the number of employees with a specific salary.

An Organization Stores the Details of Its Employees Using Microsoft