James, a manager at Sugar Maple Inc., uses Microsoft Access 2016 to retrieve flight details. He wants to obtain information about all the flights except those with a SourceCity field value not equal to "Wisbane" To get the information, James should type _____ in the Criteria row in the SourceCity field.
A)NE (Wisbane)
B)!={Wisbane}
C)"Wisbane"
D)EXCEPT "Wisbane"

Question

James, a manager at Sugar Maple Inc., uses Microsoft Access 2016 to retrieve flight details. He wants to obtain information about all the flights except those with a SourceCity field value not equal to "Wisbane" To get the information, James should type _____ in the Criteria row in the SourceCity field. ​
A)NE (Wisbane)
B)!={Wisbane}
C)"Wisbane"
D)EXCEPT "Wisbane"

Quizplus · Accepted Answer

In Microsoft Access, to filter records to include only those where a specific field (in this case, SourceCity) matches a particular value ("Wisbane"), you would enter the value in quotes in the Criteria row. Therefore, "Wisbane" is the correct notation to use.

James, a Manager at Sugar Maple Inc