In the Declarations statement "Option Compare Database," Database determines how the procedure will ____ the data.
A)organize
B)filter
C)run
D)sort

Question

Quizplus · Accepted Answer

The "Option Compare Database" statement is used when working with text data in VBA. It determines how string comparisons are made in the procedure. The Database option performs a binary sort by default, which means that uppercase letters are sorted before lowercase letters. Therefore, the correct answer is D - sort.

In the Declarations Statement "Option Compare Database," Database Determines How