An Organization Stores the Details of Its Employees Using Microsoft

question 50

Multiple Choice

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.

---

Definitions:

Progressive Relaxation

A technique involving the tightening and then relaxing of different muscle groups to reduce physical tension and stress.

Virtual Reality Exposure Therapy

A form of psychotherapy that uses virtual reality technology to expose patients to simulations of their fears or traumatic memories as a way to treat anxiety disorders.

Counterconditioning Technique

A behavior therapy technique where an undesirable response to a stimulus is replaced with a more desirable response, often used in the treatment of phobias.

Anxiety-arousing Situation

Any circumstance that triggers feelings of anxiety or nervousness.