Deck 13: Programming in Access

Question 1

Defining a function in a module makes it inaccessible elsewhere in the database.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

It is easier to read and identify the purpose of a function if it has recognizable control names.

Question 7

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

Question 8

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

Question 9

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

Question 10

You need to assign a data type to a ____.

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

Question 11

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

Question 12

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

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

Question 13

A comment helps the person looking at the code identify the purpose of the code.

Question 14

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

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

Question 15

Each function can perform only one action.

Question 16

Comments in the VBA window appear in ____.

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

Question 17

Even the simplest functions can contain errors.

Question 18

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

Question 19

Code refers to the syntax used in VBA.

Question 20

____ is the programming language for Access.

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

Question 21

Press the ____ to indent a line of code.

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

Question 22

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

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

Question 23

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

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

Question 24

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

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

Question 25

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.

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

Question 26

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

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

Question 27

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

Question 28

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.

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

Question 29

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 ____.

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

Question 30

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.

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

Question 31

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

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

Question 32

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

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

Question 33

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 ____.

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 34

Defining a function in a module makes it ____.

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

Question 35

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

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

Question 36

Procedures include ____ that indicates where the procedure begins.

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

Question 37

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 ____.

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

Question 38

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.

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

Question 39

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 ____.

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 40

When a form is selected in the Form window, the Form Selector box appears with a ____.

A) dark square
B) highlight
C) beveled edge
D) dotted outline

Question 42

____________________ errors occur when the procedure produces incorrect results.

Question 43

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

Question 44

Describe the general syntax of the IF procedure.

Question 45

A(n) ____________________ is a group of statements written in VBA code that can include several functions.

Question 46

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