An organization stores the details of its employees using 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, we need to group the data by department and sum the salaries. Therefore, the correct option is 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. Option A is incorrect because we need to group by department, not by salary. Option B is incorrect because we need to count the number of employees per department, not per EmployeeID. Option D is incorrect because we don't need to count the number of employees who have the same salary.

An Organization Stores the Details of Its Employees Using Access