Aaron and Jeff are in the same advanced Access class and have teamed up to help each other understand VBA. In order to prepare for the VBA test, each has created a quiz for the other. Two of Aaron's questions are shown below.
-Which of the following contains the term that is described by the following statement? "Declares a variable, a named storage location that contains data that can be modified during program execution."
A) Option Explicit
B) Option Compare Database
C) Dim
D) Private Sub

Question

Quizplus · Accepted Answer

The "Dim" statement is used to declare variables in VBA.

Answer: A, B, D are not correct.
 Option Explicit is used to force variable declaration, Option Compare Database is used to set the string comparison method, and Private Sub is used to define a procedure. None of these statements directly declare a variable.

Aaron and Jeff Are in the Same Advanced Access Class