Asked by Judeline Adolphe on May 27, 2024

verifed

Verified

What criterion would you use in the LastName field to find records that do not contain a last name?

A) Is Null
B) "Null"
C) Is Not Null
D) No LastName

Is Null

A condition or statement in databases that checks if a value is absent or empty.

  • Master the formulation and usage of criteria in database query operations.
verifed

Verified Answer

AK
Aryan KumarMay 29, 2024
Final Answer :
A
Explanation :
The criterion "Is Null" is the best choice because it selects all records where the LastName field is empty or contains a null value. This will give you a list of all records in which the last name is not mentioned. Option B is not correct because "Null" is a string value and not a null value. Option C will select all records that have a value in the LastName field, which is the opposite of what we want. Option D is not correct because it is not a valid criterion in Access.