Access Study Test
Practice tests to further your career.
Intro
The following study test contains practice certification questions along with a study link for each question.
These questions were prepared by Mike Prestwood and are intended to stress an important aspect. All our practice questions are intended to prepare you
specifically to earn your Prestwood certification and generally for passing any certification test as well as prepare you for
professional work.
Features:
Each question has a popup [Review] link.
Hover over answers to reveal correct answer.
7 Questions
Mouse over answers to reveal correct answer.
Beginner
2 Beginner Level Questions
Question #1: True or False?
Given the following code, which MsgBox will display? The True or the False one?
Dim a, b, c, d As Boolean a = True b = True c = True d = False If Not (a And b) And (c Or d) Then MsgBox ("True") Else MsgBox ("False") End If
Answer:
Question #2: True or False?
Access VBA is not case sensitive. If you type any other case for command or variable names, Access VBA will change it to the "accepted" or "defined" case.
Answer:
Intermediate
3 Intermediate Level Questions
Question #3: True or False?
Arrays in Access VBA are 0 based.
Answer:
Question #4: True or False?
The default for parameters for subroutines and functions is by reference.
Answer:
Question #5: Yes or No?
Given the following two functions:
Function This() This = False End Function Function That() That = True End Function
Will the That function in the following code execute?
Private Sub Command0_Click() If This And That Then MsgBox ("hi") End If End Sub
Answer:
Advanced
2 Advanced Level Questions
Question #6: Multiple Choice
In Access object oriented programming, when an object instance is created from a class, Access VBA calls a special parameter-less sub named what?
Answer:
Question #7: Multiple Choice
In Access object oriented programming, when an object instance is destroyed, Access VBA calls a special parameter-less sub named what?
Answer: