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:

Standardized Questionnaires

Pre-designed sets of questions used to collect data from individuals in a uniform manner, allowing for comparisons and statistical analysis.

Genetic Contribution

The portion of variation in a trait among individuals in a population that is due to genetic differences.

Temperaments

Inherent parts of an individual's personality, including aspects like moodiness, energy level, and emotional reactivity.

Central Traits

Key characteristics of a personality that influence behavior and are consistent across different situations.