An Organization Stores the Details of Its Employees Using Access

question 3

Multiple Choice

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.

---

Definitions:

Recruiting Efforts

Activities and strategies employed by an organization to attract and hire suitable candidates for job openings.

Workforce

The collective group of individuals engaged in work within an organization or the labor market at large.

Management Consulting

Professional services that advise businesses on how to improve their performance through the analysis of existing organizational problems and the development of improvement plans.

Recruitment Drive

A concerted effort by an organization to attract and hire new employees.