Which database function should be used to count records with empty cells?
A)DCOUNT
B)DCOUNTA
C)DGET
D)DSUM

Question

Quizplus · Accepted Answer

The DCOUNTA function should be used to count records with empty cells, as it includes non-blank cells as well as numbers, text or logical values. The DCOUNT function only counts cells that contain numbers or dates, while DGET and DSUM have different purposes and do not involve counting empty cells.

Which Database Function Should Be Used to Count Records with Empty