Question 1

Tables contain and execute class modules.

Accepted Answer

A) True 
 B)False

Question 2

When does the Visual Basic Editor display text in red?

Accepted Answer

A)  When a syntax error is preventing the code from running 
B)  When the text is a VBA keyword 
C)  When the text begins with an apostrophe, indicating a comment 
D)  When a new If…Then…Else block of code begins 
A)  When a syntax error is preventing the code from running 
B)  When the text is a VBA keyword 
C)  When the text begins with an apostrophe, indicating a comment 
D)  When a new If…Then…Else block of code begins

Question 3

What must you use to create a custom function in Access?

Accepted Answer

A)  The Custom Function Wizard 
B)  An Access module 
C)  An Access macro 
D)  A data macro 
A)  The Custom Function Wizard 
B)  An Access module 
C)  An Access macro 
D)  A data macro

Question 4

To indicate you want to run the AssignGradeA submacro of the Grades macro, what do you enter in a control's event procedure property?

Accepted Answer

A)  AssignGradeA.Grades 
B)  Grades.AssignGradeA 
C)  Grades!AssignGradeA 
D)  [Grades].[AssignGradeA] 
A)  AssignGradeA.Grades 
B)  Grades.AssignGradeA 
C)  Grades!AssignGradeA 
D)  [Grades].[AssignGradeA]

Question 5

In VBA, comments appear in _____ text.

Accepted Answer

A)  green 
B)  red 
C)  blue 
D)  black 
A)  green 
B)  red 
C)  blue 
D)  black

Question 6

The On _____ event occurs when focus moves from one record to another.

Accepted Answer

A)  Close 
B)  Click 
C)  Caption 
D)  Current 
A)  Close 
B)  Click 
C)  Caption 
D)  Current

Question 7

The Else portion of an If...Then...Else construct is always executed.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following are built-in Access functions? Select all the options that apply.

Accepted Answer

A)  Sum 
B)  Now 
C)  If 
D)  Count 
A)  Sum 
B)  Now 
C)  If 
D)  Count

Question 9

Why would you create a function in a standard module?

Accepted Answer

A)  To embed the function in the open form 
B)  To use the function in any query, form, or report in the database 
C)  To prepare for converting the function to a macro 
D)  To avoid having to use VBA syntax 
A)  To embed the function in the open form 
B)  To use the function in any query, form, or report in the database 
C)  To prepare for converting the function to a macro 
D)  To avoid having to use VBA syntax

Question 10

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

Accepted Answer

A)  End Function 
B)  End Sub 
C)  End Statement 
D)  Close Function 
A)  End Function 
B)  End Sub 
C)  End Statement 
D)  Close Function

Question 11

As you write a VBA statement, visual aids that are part of _____ help you complete it.

Accepted Answer

A)  the syntax 
B)  the Code Builder 
C)  Visual Sense guidelines 
D)  IntelliSense technology 
A)  the syntax 
B)  the Code Builder 
C)  Visual Sense guidelines 
D)  IntelliSense technology

Question 12

When you display the Visual Basic window, one line is highlighted in yellow. What does that mean?

Accepted Answer

A)  The code cannot run successfully. 
B)  The yellow line will change data when you run the code. 
C)  A new section of the code starts after the yellow line. 
D)  An error has been corrected automatically. 
A)  The code cannot run successfully. 
B)  The yellow line will change data when you run the code. 
C)  A new section of the code starts after the yellow line. 
D)  An error has been corrected automatically.

Question 13

_____ modules are displayed as module objects in the Navigation Pane.

Accepted Answer

A)  Class 
B)  Standard 
C)  Macro 
D)  Method 
A)  Class 
B)  Standard 
C)  Macro 
D)  Method

Question 14

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

Accepted Answer

A)  Store the database in a trusted folder. 
B)  Change the Enable Content startup option. 
C)  Split the database. 
D)  Compact and repair the database. 
A)  Store the database in a trusted folder. 
B)  Change the Enable Content startup option. 
C)  Split the database. 
D)  Compact and repair the database.

Question 15

If you create a function in a standard module, it applies only to the current object.

Accepted Answer

A) True 
 B)False

Question 16

You use a(n) apostrophe to begin a comment line.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

Accepted Answer

A)  Option Compare Database 
B)  On Text GoTo 
C)  Select Case 
D)  Option Sort Text 
A)  Option Compare Database 
B)  On Text GoTo 
C)  Select Case 
D)  Option Sort Text

Question 18

A(n) _____ procedure manipulates controls and objects.

Accepted Answer

A)  class 
B)  action 
C)  sub 
D)  method 
A)  class 
B)  action 
C)  sub 
D)  method

Question 19

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

Accepted Answer

A) True 
 B)False

Question 20

Which procedure is triggered after a field is updated?

Accepted Answer

A)  Current Record 
B)  Before Insert 
C)  After Update 
D)  On Got Focus 
A)  Current Record 
B)  Before Insert 
C)  After Update 
D)  On Got Focus

Tables contain and execute class modules.

When does the Visual Basic Editor display text in red?

What must you use to create a custom function in Access?

To indicate you want to run the AssignGradeA submacro of the Grades macro, what do you enter in a control's event procedure property?

In VBA, comments appear in _____ text.

The On _____ event occurs when focus moves from one record to another.

The Else portion of an If...Then...Else construct is always executed.

Which of the following are built-in Access functions? Select all the options that apply.

Why would you create a function in a standard module?

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

As you write a VBA statement, visual aids that are part of _____ help you complete it.

When you display the Visual Basic window, one line is highlighted in yellow. What does that mean?

_____ modules are displayed as module objects in the Navigation Pane.

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

If you create a function in a standard module, it applies only to the current object.

You use a(n) apostrophe to begin a comment line.

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

A(n) _____ procedure manipulates controls and objects.

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

Which procedure is triggered after a field is updated?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Developing an Excel Application

Filters

Exam 11: Exploring Pivottable Design

Tables contain and execute class modules.

When does the Visual Basic Editor display text in red?

What must you use to create a custom function in Access?

To indicate you want to run the AssignGradeA submacro of the Grades macro, what do you enter in a control's event procedure property?

In VBA, comments appear in _____ text.

The On _____ event occurs when focus moves from one record to another.

The Else portion of an If...Then...Else construct is always executed.

Which of the following are built-in Access functions? Select all the options that apply.

Why would you create a function in a standard module?

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

As you write a VBA statement, visual aids that are part of _____ help you complete it.

When you display the Visual Basic window, one line is highlighted in yellow. What does that mean?

_____ modules are displayed as module objects in the Navigation Pane.

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

If you create a function in a standard module, it applies only to the current object.

You use a(n) apostrophe to begin a comment line.

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

A(n) _____ procedure manipulates controls and objects.

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

Which procedure is triggered after a field is updated?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Developing an Excel Application

Filters