Question 1

Use a(n) If statement to document a macro with explanatory text.

Accepted Answer

False
 - c

Question 2

Every If block of code must end with an End If statement.

Accepted Answer

A) True 
 B)False

Question 3

What happens when you click the Build button for a property on the Event tab of a form's Property Sheet?

Accepted Answer

A)  You set the property value to Yes. 
B)  The Query Builder window opens. 
C)  You add a calculated control to the form. 
D)  The Visual Basic window opens. 
A)  You set the property value to Yes. 
B)  The Query Builder window opens. 
C)  You add a calculated control to the form. 
D)  The Visual Basic window opens.

Question 4

A_____ procedure is generally executed when an event occurs.

Accepted Answer

A)  method 
B)  sub 
C)  module 
D)  declaration 
A)  method 
B)  sub 
C)  module 
D)  declaration

Question 5

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Accepted Answer

A)  You create a new module for the form. 
B)  Any modules attached to the form begin to run. 
C)  You display the VBA code for the form. 
D)  You add a standard module to the form. 
A)  You create a new module for the form. 
B)  Any modules attached to the form begin to run. 
C)  You display the VBA code for the form. 
D)  You add a standard module to the form.

Question 6

Which of the following object prefixes is short for Visual Basic and applies to standard (global) modules?

Accepted Answer

A)  mod 
B)  bas 
C)  vis 
D)  sub 
A)  mod 
B)  bas 
C)  vis 
D)  sub

Question 7

Which of the following are errors that prevent VBA code from running successfully? Select all the options that apply.

Accepted Answer

A)  Mistyping the word function 
B)  Using too many comments 
C)  Forgetting an End If statement 
D)  Dividing by zero 
A)  Mistyping the word function 
B)  Using too many comments 
C)  Forgetting an End If statement 
D)  Dividing by zero

Question 8

On Click is an example of a(n) _____.

Accepted Answer

A)  event property 
B)  bound control 
C)  macro action 
D)  Command Button Wizard option 
A)  event property 
B)  bound control 
C)  macro action 
D)  Command Button Wizard option

Question 9

An Access Part is a template that creates an Access object such as a table or form.

Accepted Answer

False 
- Application

Question 10

Which of the following are types of procedures? Select all the options that apply.

Accepted Answer

A)  Sub 
B)  Function 
C)  Declaration 
D)  Event 
A)  Sub 
B)  Function 
C)  Declaration 
D)  Event

Question 11

How does VBA treat comments when you run the code in the Visual Basic window?

Accepted Answer

A)  It highlights the comments only if they contain a syntax error. 
B)  It performs any commands in the comments. 
C)  It corrects spelling errors in the comments. 
D)  It ignores the comments. 
A)  It highlights the comments only if they contain a syntax error. 
B)  It performs any commands in the comments. 
C)  It corrects spelling errors in the comments. 
D)  It ignores the comments.

Question 12

A(n) event is a procedure that returns a value.

Accepted Answer

False
 - function
Fa

Question 13

A(n) submacro is something that happens to a form, window, toolbar, or control-such as the click of a command button or an entry in a field-that can start running a macro.

Accepted Answer

False
 - e

Question 14

A _____ module is stored as a part of the form or report in which it was created.

Accepted Answer

A)  global 
B)  class 
C)  standard 
D)  sub 
A)  global 
B)  class 
C)  standard 
D)  sub

Question 15

How do you add an If statement to a module in the Visual Basic window?

Accepted Answer

A)  Type the If keyword. 
B)  Double-click the If object in the Action Catalog. 
C)  Drag the If statement from the Statements list. 
D)  Click the Add Statement arrow on the Standard toolbar. 
A)  Type the If keyword. 
B)  Double-click the If object in the Action Catalog. 
C)  Drag the If statement from the Statements list. 
D)  Click the Add Statement arrow on the Standard toolbar.

Question 16

To run the code in the Visual Basic window, you click the Run button on the Standard toolbar.

Accepted Answer

A) True 
 B)False

Question 17

To add a heading to the Detail section of a form, you use a text box control.

Accepted Answer

False
 - l

Question 18

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

Accepted Answer

A)  Current Database 
B)  Trust Center 
C)  Client Settings 
D)  General 
A)  Current Database 
B)  Trust Center 
C)  Client Settings 
D)  General

Question 19

Comments appear _____ of a macro.

Accepted Answer

A)  at the beginning 
B)  at the end 
C)  next to the actions 
D)  in the footer 
A)  at the beginning 
B)  at the end 
C)  next to the actions 
D)  in the footer

Question 20

When you convert an Access macro to VBA code, the VBA is stored in a standard module listed in the Navigation Pane with a name that starts with "New Macro."

Accepted Answer

False 
- Converted
F

Use a(n) If statement to document a macro with explanatory text.

Every If block of code must end with an End If statement.

What happens when you click the Build button for a property on the Event tab of a form's Property Sheet?

A_____ procedure is generally executed when an event occurs.

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Which of the following object prefixes is short for Visual Basic and applies to standard (global) modules?

Which of the following are errors that prevent VBA code from running successfully? Select all the options that apply.

On Click is an example of a(n) _____.

An Access Part is a template that creates an Access object such as a table or form.

Which of the following are types of procedures? Select all the options that apply.

How does VBA treat comments when you run the code in the Visual Basic window?

A(n) event is a procedure that returns a value.

A(n) submacro is something that happens to a form, window, toolbar, or control-such as the click of a command button or an entry in a field-that can start running a macro.

A _____ module is stored as a part of the form or report in which it was created.

How do you add an If statement to a module in the Visual Basic window?

To run the code in the Visual Basic window, you click the Run button on the Standard toolbar.

To add a heading to the Detail section of a form, you use a text box control.

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

Comments appear _____ of a macro.

When you convert an Access macro to VBA code, the VBA is stored in a standard module listed in the Navigation Pane with a name that starts with "New Macro."

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

Use a(n) If statement to document a macro with explanatory text.

Every If block of code must end with an End If statement.

What happens when you click the Build button for a property on the Event tab of a form's Property Sheet?

A_____ procedure is generally executed when an event occurs.

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Which of the following object prefixes is short for Visual Basic and applies to standard (global) modules?

Which of the following are errors that prevent VBA code from running successfully? Select all the options that apply.

On Click is an example of a(n) _____.

An Access Part is a template that creates an Access object such as a table or form.

Which of the following are types of procedures? Select all the options that apply.

How does VBA treat comments when you run the code in the Visual Basic window?

A(n) event is a procedure that returns a value.

A(n) submacro is something that happens to a form, window, toolbar, or control-such as the click of a command button or an entry in a field-that can start running a macro.

A _____ module is stored as a part of the form or report in which it was created.

How do you add an If statement to a module in the Visual Basic window?

To run the code in the Visual Basic window, you click the Run button on the Standard toolbar.

To add a heading to the Detail section of a form, you use a text box control.

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

Comments appear _____ of a macro.

When you convert an Access macro to VBA code, the VBA is stored in a standard module listed in the Navigation Pane with a name that starts with "New Macro."

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