Question 1

Procedures include ____ that indicates where the procedure begins.

Accepted Answer

A)  colors 
B)  code 
C)  indents 
D)  arrows 
A)  colors 
B)  code 
C)  indents 
D)  arrows B

Question 2

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. You suggest that Eric ____.

Accepted Answer

A)  use the Sum built-in function 
B)  use the Average built-in function 
C)  create a new function called CalcAvg 
D)  use another programming language 
A)  use the Sum built-in function 
B)  use the Average built-in function 
C)  create a new function called CalcAvg 
D)  use another programming language B

Question 3

Press the ____ to indent a line of code.

Accepted Answer

A)  TAB key 
B)  SHIFT key 
C)  CTRL + SHIFT keys 
D)  CTRL + TAB keys 
A)  TAB key 
B)  SHIFT key 
C)  CTRL + SHIFT keys 
D)  CTRL + TAB keys A

Question 4

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. Eric suspects there will be similar requests in the future and wants the function he creates to be available for various database procedures. You suggest Eric define the function in a ____.

Accepted Answer

A)  control 
B)  subroutine 
C)  case 
D)  module 
A)  control 
B)  subroutine 
C)  case 
D)  module

Question 5

Comments in the VBA window appear in ____.

Accepted Answer

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

Question 6

In order to test a function, you type a(n) ____ before the function name and the variables.

Accepted Answer

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

Question 7

____________________ errors occur when the procedure produces incorrect results.

Accepted Answer

The answer of ____________________ errors occur when the procedure produces...

Question 8

After you create a Text Box control in a form, you can press and hold down the ____ key and then use the arrow keys to move the text box to a desired location.

Accepted Answer

A)  CTRL 
B)  TAB 
C)  SHIFT 
D)  END 
A)  CTRL 
B)  TAB 
C)  SHIFT 
D)  END

Question 9

In VBA code, a(n) symbolic name can be assigned to a value.

Accepted Answer

A) True 
 B)False

Question 10

If you want to make the control label visible in the procedure, you need to add the syntax ____ after the name given to the label.

Accepted Answer

A)  View 
B)  Open 
C)  Show 
D)  Visible 
A)  View 
B)  Open 
C)  Show 
D)  Visible

Question 11

The unbound part of a Text Box control remains unbound until a(n) field with actual data is assigned to the control.

Accepted Answer

A) True 
 B)False

Question 12

A function can contain errors even though the statements have the correct syntax .

Accepted Answer

A) True 
 B)False

Question 13

You add names to the parts of a(n) ____ so that you can use these names in the procedure.

Accepted Answer

A)  unbound function 
B)  record 
C)  label 
D)  control 
A)  unbound function 
B)  record 
C)  label 
D)  control

Question 14

The ____________________ window will return the results of the function based on the values you enter.

Accepted Answer

The answer of The ____________________ window will return the results...

Question 15

Code refers to the syntax used in VBA.

Accepted Answer

A) True 
 B)False

Question 16

A Visual Basic ____ appears when you click the Create tab, and then click Module in the Macros & Code group.

Accepted Answer

A)  form 
B)  module 
C)  window 
D)  macro 
A)  form 
B)  module 
C)  window 
D)  macro

Question 17

After the syntax Visible, you will need to add a(n) ____ and the word True or False so that the label will appear or not appear.

Accepted Answer

A)  arrow 
B)  equal sign 
C)  plus sign 
D)  period 
A)  arrow 
B)  equal sign 
C)  plus sign 
D)  period

Question 18

Each function can perform only one action.

Accepted Answer

A) True 
 B)False

Question 19

You can press the ____ key to accept the text that automatically appears as you type.

Accepted Answer

A)  TAB 
B)  ENTER 
C)  CTRL 
D)  SHIFT 
A)  TAB 
B)  ENTER 
C)  CTRL 
D)  SHIFT

Question 20

As you type VBA code, ____________________ appears to assist you in creating the function.

Accepted Answer

The answer of As you type VBA code, ____________________ appears...

Exam 13: Programming in Access

Procedures include ____ that indicates where the procedure begins.

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. You suggest that Eric ____.

Press the ____ to indent a line of code.

Comments in the VBA window appear in ____.

In order to test a function, you type a(n) ____ before the function name and the variables.

____________________ errors occur when the procedure produces incorrect results.

After you create a Text Box control in a form, you can press and hold down the ____ key and then use the arrow keys to move the text box to a desired location.

In VBA code, a(n) symbolic name can be assigned to a value.

If you want to make the control label visible in the procedure, you need to add the syntax ____ after the name given to the label.

The unbound part of a Text Box control remains unbound until a(n) field with actual data is assigned to the control.

A function can contain errors even though the statements have the correct syntax .

You add names to the parts of a(n) ____ so that you can use these names in the procedure.

The ____________________ window will return the results of the function based on the values you enter.

Code refers to the syntax used in VBA.

A Visual Basic ____ appears when you click the Create tab, and then click Module in the Macros & Code group.

After the syntax Visible, you will need to add a(n) ____ and the word True or False so that the label will appear or not appear.

Each function can perform only one action.

You can press the ____ key to accept the text that automatically appears as you type.

As you type VBA code, ____________________ appears to assist you in creating the function.

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