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.
Emily wants to retrieve records of students who are from China, Italy, and Mexico. Which of the following operators should Emily use for this purpose?
A)In ()
B)Between …
C)=
D) Compare

Question

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.
Emily wants to retrieve records of students who are from China, Italy, and Mexico. Which of the following operators should Emily use for this purpose?
A)In ()
B)Between …
C)=
D) ​Compare

Quizplus · Accepted Answer

The "In ()" operator is used in SQL queries to specify multiple values in a WHERE clause, making it suitable for retrieving records that match any of the specified criteria, such as students from China, Italy, and Mexico.

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