Question 1

You need to assign a data type to a ____.

Accepted Answer

A)  variable 
B)  control 
C)  process 
D)  function 
A)  variable 
B)  control 
C)  process 
D)  function

Question 2

FIGURE 13-3   In Figure 13-3 above, item 2 points to ____.

Accepted Answer

A)  data types 
B)  data names 
C)  variable names 
D)  procedure names 
A)  data types 
B)  data names 
C)  variable names 
D)  procedure names

Question 3

When you enter dates in the Immediate window, you place a(n) ____ before and after the date to define when the date starts and ends.

Accepted Answer

A)  pound sign (#) 
B)  question mark (?) 
C)  asterisk (*) 
D)  apostrophe (') 
A)  pound sign (#) 
B)  question mark (?) 
C)  asterisk (*) 
D)  apostrophe (')

Question 4

You can add controls to a form that display the results of a calculation.

Accepted Answer

A) True 
 B)False

Question 5

You can highlight a line of code before you type it to make it easier to see in the window.

Accepted Answer

A) True 
 B)False

Question 6

____ is the programming language for Access.

Accepted Answer

A)  Microsoft Excel 
B)  Virtual C++ for Microsoft 
C)  Visual Basic for Applications 
D)  Java Development Kit 
A)  Microsoft Excel 
B)  Virtual C++ for Microsoft 
C)  Visual Basic for Applications 
D)  Java Development Kit

Question 7

Even the simplest functions can contain errors.

Accepted Answer

A) True 
 B)False

Question 8

To add a comment in VBA, you begin by typing a(n) ____ before the sentence.

Accepted Answer

A)  pound sign (#) 
B)  question mark (?) 
C)  asterisk (*) 
D)  apostrophe (') 
A)  pound sign (#) 
B)  question mark (?) 
C)  asterisk (*) 
D)  apostrophe (')

Question 9

Average, Min, and Max are examples of VBA ____.

Accepted Answer

A)  syntax 
B)  controls 
C)  variables 
D)  built-in functions 
A)  syntax 
B)  controls 
C)  variables 
D)  built-in functions

Question 10

AC Adv Case 13-2 John has written a VBA program that uses the following IF statement. He tests the program and the IF statement is not working as expected, so he asks for your help. 'This If statement checks for an empty input value 'Then it divides 100 by that value If IsEmpty(divisor) then 'Input field has a value so continue result = 100 / divisor End If You explain that the result is not being displayed correctly because ____.

Accepted Answer

A)  the code was not compiled correctly 
B)  the result equation is part of the comment statement above it 
C)  John should use the IsNull syntax 
D)  John cannot divide by a variable name 
A)  the code was not compiled correctly 
B)  the result equation is part of the comment statement above it 
C)  John should use the IsNull syntax 
D)  John cannot divide by a variable name

Question 11

A(n) ____________________ is an action that can be defined in VBA code where you use statements to describe the action you want performed.

Accepted Answer

The answer of A(n) ____________________ is an action that can...

Question 12

Defining a function in a module makes it ____.

Accepted Answer

A)  public 
B)  private 
C)  local 
D)  unusable 
A)  public 
B)  private 
C)  local 
D)  unusable

Question 13

When testing functions in Visual Basic, the answer appears in the Results window.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: Wording that is used in VBA
Identifies what will appear in the unbound part of the text box control
A symbolic name that you assign to a value
Used to indicate the end of a label name
A statement that does not perform an action

Accepted Answer

The Answer of comment and period (.) and variable name is...

Question 15

If you are going to use a control in a procedure, you first add the control to the database .

Accepted Answer

A) True 
 B)False

Question 16

If a procedure is working correctly, the results of the procedure will show accurate results.

Accepted Answer

A) True 
 B)False

Question 17

You assign specific functions to the parts of a control in the Control Sheet.

Accepted Answer

A) True 
 B)False

Question 18

Describe the general syntax of the IF procedure.

Accepted Answer

The IF procedure begins with the code wo

Question 19

AC Adv Case 13-2 John has written a VBA program that uses the following IF statement. He tests the program and the IF statement is not working as expected, so he asks for your help. 'This If statement checks for an empty input value 'Then it divides 100 by that value If IsEmpty(divisor) then 'Input field has a value so continue result = 100 / divisor End If John wants to display an error message if there is no input value. You suggest that John ____.

Accepted Answer

A)  use another programming language 
B)  display a message up front informing the user to enter a value 
C)  use a Message statement 
D)  use an Else statement 
A)  use another programming language 
B)  display a message up front informing the user to enter a value 
C)  use a Message statement 
D)  use an Else statement

Question 20

VBA requires the use of specific syntax so that the procedure performs actions ____.

Accepted Answer

A)  repeatedly 
B)  efficiently 
C)  correctly 
D)  quickly 
A)  repeatedly 
B)  efficiently 
C)  correctly 
D)  quickly

Exam 13: Programming in Access

You need to assign a data type to a ____.

FIGURE 13-3 In Figure 13-3 above, item 2 points to ____.

When you enter dates in the Immediate window, you place a(n) ____ before and after the date to define when the date starts and ends.

You can add controls to a form that display the results of a calculation.

You can highlight a line of code before you type it to make it easier to see in the window.

____ is the programming language for Access.

Even the simplest functions can contain errors.

To add a comment in VBA, you begin by typing a(n) ____ before the sentence.

Average, Min, and Max are examples of VBA ____.

A(n) ____________________ is an action that can be defined in VBA code where you use statements to describe the action you want performed.

Defining a function in a module makes it ____.

When testing functions in Visual Basic, the answer appears in the Results window.

If you are going to use a control in a procedure, you first add the control to the database .

If a procedure is working correctly, the results of the procedure will show accurate results.

You assign specific functions to the parts of a control in the Control Sheet.

Describe the general syntax of the IF procedure.

VBA requires the use of specific syntax so that the procedure performs actions ____.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters