Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years? A) 10 B) #10# C) =10 D) 10

Question

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years?
A) >10
B) #10#
C) =>10
D) <>10

Quizplus · Accepted Answer

The correct query criteria to show all employees that have worked for the company more than ten years is ">10". This means the query will select records where the number of years an employee has been with the company is greater than 10.

Jen Is Working on a Database That Stores Employee Data