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

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

Quizplus · Accepted Answer

The term "Dim" is used in VBA to declare a variable, which is a named storage location that can hold data that may change during the execution of a program.

Aaron and Jeff Are in the Same Advanced Access Class