To find employee records that do not contain an entry in the Email field,use the _____ criterion in the Email field.
A) Is Not Null
B) Is Null
C) Find Unmatched
D) Is Blank

Question

Quizplus · Accepted Answer

The "Is Null" criterion in the Email field will search for all employee records where the Email field does not contain any entry or is blank, which is what we want to find. The other options are not applicable in this case. "Is Not Null" would give us all the employee records that have an entry in the Email field, and "Is Blank" may not include records where the email field is simply empty. "Find Unmatched" is used when searching for unmatched records in a related table.

To Find Employee Records That Do Not Contain an Entry