Case 18-1 Emily, a Professor, Uses Microsoft Access 2016 to Manage

Multiple Choice

Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students except those with the FirstName field value "Andrew," Emily should enter _____ in the Criteria row in the FirstName column in the design grid.

A) !={"Andrew"}
B) "Andrew"
C) NOT LIKE = Andrew
D) EXCEPT(Andrew)