An Organisation Stores the Details of Its Employees Using Access

question 28

Multiple Choice

An organisation 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 count the number of employees having the same salary,the Group By option should be selected under EmployeeID and Count under Salary.
• B)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.
• C)To count the number of employees in each department,the Group By option should be selected under EmployeeID and the Count option under Department.
• D)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.

---

Definitions:

Working Relationship

The interaction and communication between colleagues or business associates that is professional and aimed at achieving work-related goals.

Project Activities

The tasks, actions, or operations performed during the execution of a project to achieve its objectives and deliverables.

Transmittal Organization

Pertains to the structured process or system used for sending or conveying information or documents from one entity to another.

Facebook Page

A public profile created on Facebook for businesses, organizations, and public figures to share their stories and connect with people.