Robert, a Manager, Uses Microsoft Access 2016 to Retrieve Employee

Multiple Choice

Robert, a manager, uses Microsoft Access 2016 to retrieve employee details. He types 50000 in the Criteria box in the Salary column in the design grid and runs the query. The results for the query include all the records _____. ​

A) with values less than 50,000 in the Salary field
B) except the ones with 50,000 in the Salary field
C) with 50,000 in the Salary field
D) except the ones with values greater than 50,000 in the Salary field