An Organization Stores the Details of Its Employees Using Microsoft

question 28

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:

Basic Language Skills

Fundamental linguistic abilities involving reading, writing, listening, and speaking that enable communication and comprehension.

Read Lips

The ability to understand spoken words by visually interpreting the movements of the lips, face, and tongue, often used by individuals who are deaf or hard of hearing.

Functional Morphemes

The smallest linguistic units that carry meaning and function within a language, such as prepositions, articles, and conjunctions.

Grammatical Principles

Fundamental rules that govern the structure and organization of sentences and phrases in a language.