Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

Which of the following controls has an After Update event property? ​

Accepted Answer

A)  label 
B)  text box 
C)  command button 
D)  rectangle 
A)  label 
B)  text box 
C)  command button 
D)  rectangle

Question 5

Standard modules contain _____.

Accepted Answer

A)  code that can be executed only from a form or report 
B)  macros from earlier versions of Access 
C)  a list of standard functions built into Access,such as Sum 
D)  global code that can be executed from anywhere in the database 
A)  code that can be executed only from a form or report 
B)  macros from earlier versions of Access 
C)  a list of standard functions built into Access,such as Sum 
D)  global code that can be executed from anywhere in the database

Question 6

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 7

Why are the parts of an If statement indented in the Visual Basic window?

Accepted Answer

A)  Indentation makes the code easier to read. 
B)  VBA runs the indented code first. 
C)  The code will not run if it is not indented. 
D)  The indented code is optional. 
A)  Indentation makes the code easier to read. 
B)  VBA runs the indented code first. 
C)  The code will not run if it is not indented. 
D)  The indented code is optional.

Question 8

Clicking a command button or making an entry in a field is considered a(n)____. ​

Accepted Answer

A)  macro 
B)  event 
C)  condition 
D)  argument 
A)  macro 
B)  event 
C)  condition 
D)  argument

Question 9

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

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

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 12

Which built-in Access function returns today's date?

Accepted Answer

A)  TodayDate 
B)  Now 
C)  Day 
D)  DateAndTime 
A)  TodayDate 
B)  Now 
C)  Day 
D)  DateAndTime

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

How do you begin an If statement that determines whether an employee's salary is less than $50,000?

Accepted Answer

A)  Is Salary < 50000? 
B)  If Salary < 50000 
C)  Else Salary < 50000 
D)  Rem Salary If < 50000 
A)  Is Salary < 50000? 
B)  If Salary < 50000 
C)  Else Salary < 50000 
D)  Rem Salary If < 50000

Question 17

When do most class modules run?

Accepted Answer

A)  When you double-click a module in the Navigation Pane 
B)  After all the standard modules finish running 
C)  When you double-click a macro in the Navigation Pane 
D)  In response to an event such as clicking a command button 
A)  When you double-click a module in the Navigation Pane 
B)  After all the standard modules finish running 
C)  When you double-click a macro in the Navigation Pane 
D)  In response to an event such as clicking a command button

Question 18

When a module is embedded in a form or report,it is called a(n)_____.

Accepted Answer

A)  class module 
B)  event handler 
C)  sub procedure 
D)  sub module 
A)  class module 
B)  event handler 
C)  sub procedure 
D)  sub module

Question 19

The programming language used in Access modules is called Visual Basic for _____.

Accepted Answer

A)  Access 
B)  Modules 
C)  Applications 
D)  Macros 
A)  Access 
B)  Modules 
C)  Applications 
D)  Macros

Question 20

You can create a comment by starting the statement with _____.

Accepted Answer

A)  dim 
B)  com 
C)  rem 
D)  ignore 
A)  dim 
B)  com 
C)  rem 
D)  ignore

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

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

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 of the following controls has an After Update event property?

Standard modules contain _____.

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

Why are the parts of an If statement indented in the Visual Basic window?

Clicking a command button or making an entry in a field is considered a(n)____.

Which procedure is triggered after a field is updated?

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

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

Which built-in Access function returns today's date?

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

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

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

How do you begin an If statement that determines whether an employee's salary is less than $50,000?

When do most class modules run?

When a module is embedded in a form or report,it is called a(n)_____.

The programming language used in Access modules is called Visual Basic for _____.

You can create a comment by starting the statement with _____.

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

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

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

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 of the following controls has an After Update event property? ​

Standard modules contain _____.

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

Why are the parts of an If statement indented in the Visual Basic window?

Clicking a command button or making an entry in a field is considered a(n)____. ​

Which procedure is triggered after a field is updated?

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

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

Which built-in Access function returns today's date?

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

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

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

How do you begin an If statement that determines whether an employee's salary is less than $50,000?

When do most class modules run?

When a module is embedded in a form or report,it is called a(n)_____.

The programming language used in Access modules is called Visual Basic for _____.

You can create a comment by starting the statement with _____.

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

Which of the following controls has an After Update event property?

Clicking a command button or making an entry in a field is considered a(n)____.