I.T. Discussion Community!
 Access
 Access Group Home eMag: Access Edition WEEKLYLESSON MYGROUPSETTINGS
 Message Board
 Access KB
 Access Study Test PRESTWOODCERTIFIED Access Study Test◄╣
 Access Store PRESTWOODSTORE Store Home Buy Access Items
 Members Only

#### Prestwood eMagazine

January Edition
Subscribe now! It's Free!

 ► Prestwood Certified All Groups

# 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.

# 7 Questions

## 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 = Trueb = Truec = Trued = False  If Not (a And b) And (c Or d) Then  MsgBox ("True")Else  MsgBox ("False")End If` Answer: TrueFalse
 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: TrueFalse

## Intermediate

3 Intermediate Level Questions

 Question #3: True or False? Arrays in Access VBA are 0 based. Answer: TrueFalse
 Question #4: True or False? The default for parameters for subroutines and functions is by reference. Answer: TrueFalse
 Question #5: Yes or No? Given the following two functions:`Function This()    This = FalseEnd Function`` ``Function That()    That = TrueEnd Function`   Will the That function in the following code execute?`Private Sub Command0_Click()    If This And That Then        MsgBox ("hi")    End IfEnd Sub` Answer: YesNo

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?

1.
 Class_Initialize
2.
 Class_New
3.
 New
4.
 Initialize
5.
 Class_Create
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?

1.
 Class_Destroy
2.
 Class_Free
3.
 Object_Destroy
4.
 Object_Terminate
5.
 Class_Terminate