Deck 11: Exploring Pivottable Design

Question 1

Standard modules are also called universal modules.

Answer 1

False - global
False - Global
False - GLOBAL

Question 2

You must use the correct _____, or rules, when creating a VBA statement.

A) syntax
B) executors
C) procedures
D) rubrics

Answer 2

A

Question 3

Class modules are stored in an individual form or report.

Answer 3

True

Question 4

Standard modules contain _____.

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 5

A function created in a standard module can be used in any query in the database.

Question 6

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

A) Start Function
B) Function
C) Option Function
D) Declare Function

Question 7

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

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

Question 8

Tables contain and execute class modules.

Question 9

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

Question 10

What happens if you write VBA code in all lowercase letters?

A) The Visual Basic Editor converts the code to the correct case.
B) The Visual Basic Editor displays a syntax error.
C) The Visual Basic Editor will not run the code when you click the Run button.
D) The Visual Basic Editor will treat the code as a comment.

Question 11

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

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

Question 12

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.

Question 13

You might want to create a function to calculate a value based on your company's unique business rules.

Question 14

You can use a function created in a standard module in any query in the database.

Question 15

If you create a function in a standard module, it applies only to the current object.

Question 16

What must you use to create a custom function in Access?

A) The Custom Function Wizard
B) An Access module
C) An Access macro
D) A data macro

Question 17

_____ modules are displayed as module objects in the Navigation Pane.

A) Class
B) Standard
C) Macro
D) Method

Question 18

Which of the following statements creates a function named Bonus with an argument named Salary?

A) Bonus(Salary) = Function
B) Function Bonus(Salary)
C) Function (Bonus, Salary)
D) '=Function(Bonus, Salary)

Question 19

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

A) End Function
B) End Sub
C) End Statement
D) Close Function

Question 20

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

A) the syntax
B) the Code Builder
C) Visual Sense guidelines
D) IntelliSense technology

Question 21

Why would you create a function in a standard module?

A) To embed the function in the open form
B) To use the function in any query, form, or report in the database
C) To prepare for converting the function to a macro
D) To avoid having to use VBA syntax

Question 22

Which of the following are form events? Select all the options that apply.

A) On Load
B) On Close
C) Before Print
D) After Update

Question 23

Comments appear _____ of a macro.

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

Question 24

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

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

Question 25

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

Question 26

When do most class modules run?

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 27

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

Question 28

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

A) Option Compare Database
B) On Text GoTo
C) Select Case
D) Option Sort Text

Question 29

In a macro's conditional expression, you refer to a value of a form control using the following syntax: ____.

A) [Forms]![formname]![controlname]
B) {Forms}!{formname}!{controlname}
C) Forms.formname(controlname)
D) Forms.(formname).(controlname)

Question 30

Which of the following are built-in Access functions? Select all the options that apply.

A) Sum
B) Now
C) If
D) Count

Question 31

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

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

Question 32

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.

Question 33

When building a conditional expression that refers to a value in a form control, use the syntax called _____. ​

A) bang notation
B) Boolean syntax
C) procedural notation
D) event syntax

Question 34

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

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

Question 35

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

A) syntax
B) run-time
C) logic
D) compile-time

Question 36

The On _____ event occurs when focus moves from one record to another.

A) Close
B) Click
C) Caption
D) Current

Question 37

Which of the following are event procedures you can assign to a report? Select all the options that apply.

A) On Open
B) On Close
C) On Click
D) On Page Break

Question 38

To indicate you want to run the AssignGradeA submacro of the Grades macro, what do you enter in a control's event procedure property?

A) AssignGradeA.Grades
B) Grades.AssignGradeA
C) Grades!AssignGradeA
D) [Grades].[AssignGradeA]

Question 39

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

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

Question 40

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

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

Question 41

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

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

Question 42

You use a(n) apostrophe to begin a comment line.

Question 43

To display the Visual Basic window, you click the Create tab on the ribbon, and then click Visual Basic.

Question 44

Visual Basic for Applications (VBA) is only available for Microsoft Access.
​

Question 45

A_____ procedure is generally executed when an event occurs.

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

Question 46

Which of the following are form events? Select all the options that apply.

A) Clicking a command button
B) Adding an action to a macro
C) Opening a form
D) Closing a form

Question 47

Which procedure is triggered after a field is updated?

A) Current Record
B) Before Insert
C) After Update
D) On Got Focus

Question 48

Comment lines start with an exclamation point (!) and are red in the Visual Basic Editor.

Question 49

To add VBA code to a macro embedded in a report, you can first _____ the macro to VBA code.

A) export
B) send
C) assign
D) convert

Question 50

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.

Question 51

_____ are statements in the code that document the code and do not affect how it runs.

A) Methods
B) Variables
C) Comment lines
D) Blue keywords

Question 52

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

Question 53

When you display the Visual Basic window, one line is highlighted in yellow. What does that mean?

A) The code cannot run successfully.
B) The yellow line will change data when you run the code.
C) A new section of the code starts after the yellow line.
D) An error has been corrected automatically.

Question 54

The On Current event of a form is triggered when you navigate through records.

Question 55

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

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

Question 56

Class modules most commonly run in response to an event, such as a user clicking a command button.

Question 57

You write VBA code in the Visual Basic Design Pane.

Question 58

In VBA, comments appear in _____ text.

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

Question 59

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

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

Question 60

In VBA code, green text indicates a VBA keyword.

Question 61

What is the first step to convert a report's macros to VBA code?

A) Right-click the report in the Navigation Pane, and then click Convert.
B) Open the report in Macro Design View.
C) Display the report in Report Design View.
D) Open the Visual Basic Editor.

Question 62

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

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 63

What types of errors occur only after you start running the code in the Visual Basic window?

A) Syntax errors
B) Logic errors
C) Run-time errors
D) Code-run errors

Question 64

You use _____ to document and explain the statements in VBA code.

A) comments
B) keywords
C) breakpoints
D) event procedures

Question 65

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

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 66

When does the Visual Basic Editor display text in red?

A) When a syntax error is preventing the code from running
B) When the text is a VBA keyword
C) When the text begins with an apostrophe, indicating a comment
D) When a new If…Then…Else block of code begins

Question 67

Which of the following text colors have meaning in VBA? Select all the options that apply.

A) Red
B) Blue
C) Black
D) Yellow

Question 68

What can you use to test logical conditions and execute statements only if the conditions are true?

A) an event procedure
B) a function
C) If…Then logic
D) Run logic

Question 69

In a report, label controls display data from underlying fields.

Question 70

Which of the following controls would you use to describe another control on a report?

A) Line
B) Text box
C) Label
D) Subreport

Question 71

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

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

Question 72

Which control provides consistent descriptive text as you navigate from record to record in a form?

A) text box
B) label
C) combo box
D) tab control

Question 73

To display the VBA code for a form, click the Build button in one of the form's event properties.

Question 74

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

Question 75

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

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

Question 76

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

Question 77

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

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 78

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

Question 79

A(n) _____ procedure manipulates controls and objects.

A) class
B) action
C) sub
D) method

Question 80

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