Case-Based Critical Thinking Questions
Case 11-1
Luca is the database administrator for a city parks and recreation department. The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible.
-Luca needs to use a VBA function in his code to return a value of True if the Paid field has no data or a value of False if the Paid field is not empty. Which VBA function should Luca use?
A)IsPaid
B)IsNum
C)IsNull
D)IsBound

Question

Case-Based Critical Thinking Questions
Case 11-1
Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible.
-Luca needs to use a VBA function in his code to return a value of True if the Paid field has no data or a value of False if the Paid field is not empty. Which VBA function should Luca use?
A)IsPaid
B)IsNum
C)IsNull
D)IsBound

Quizplus · Accepted Answer

The IsNull function in VBA returns a value of True if the specified variable contains no valid data or has been explicitly set to Null, otherwise it returns a value of False. This makes it the best choice for Luca's requirement to check if the Paid field has no data. The IsPaid function or IsBound functions do not exist in VBA, and the IsNum function checks whether a variable contains a numeric value, which is not relevant to Luca's requirement.