I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Study Test
PRESTWOODCERTIFIED
Access Study Test◄╣
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► Prestwood Certified   Print This    All Groups  
Printable Version Print Answers

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:
  • True
  • False
  • 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:
  • True
  • False

  • Intermediate

    3 Intermediate Level Questions

    Question #3: True or False?

    Arrays in Access VBA are 0 based.

    Answer:
  • True
  • False
  • Question #4: True or False?

    The default for parameters for subroutines and functions is by reference.

    Answer:
  • True
  • False
  • 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:
  • Yes
  • No

  • 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:
    1. 

    Class_New

    2. 

    New

    3. 

    Class_Initialize

    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?

    Answer:
    1. 

    Class_Destroy

    2. 

    Class_Free

    3. 

    Class_Terminate

    4. 

    Object_Destroy

    5. 

    Object_Terminate


    Follow PrestwoodBoards on: 


    ©1995-2019 PrestwoodBoards  [Security & Privacy]
    Professional IT Services: Coding | Websites | Computer Tech