Deck 11: Exploring Pivottable Design

Question 1

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

Answer 1

True

Question 2

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

Answer 2

D

Question 3

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

Answer 3

B

Question 4

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 5

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

Question 6

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

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

Question 7

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

Question 8

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

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

Question 9

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 10

Tables contain and execute class modules.

Question 11

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 12

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 13

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 14

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 15

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 16

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

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

Question 17

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 18

Class modules are stored in an individual form or report.

Question 19

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 20

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

Question 21

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

Question 22

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

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

Question 23

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 24

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

Question 25

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 26

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 27

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 28

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 29

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

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

Question 30

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 31

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

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

Question 32

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

Question 33

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

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

Question 34

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

Question 35

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 36

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

Question 37

Comments appear _____ of a macro.

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

Question 38

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 39

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

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

Question 40

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 41

Which procedure is triggered after a field is updated?

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

Question 42

In VBA,comments appear in _____ text.

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

Question 43

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 44

_____ 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 45

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 46

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 47

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

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

Question 48

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 49

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 50

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

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

Question 51

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

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

Question 52

A_____ procedure is generally executed when an event occurs.

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

Question 53

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 54

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 55

A(n)_____ procedure manipulates controls and objects.

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

Question 56

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 57

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 58

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

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

Question 59

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

Question 60

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 61

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

Question 62

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

Question 63

_____ a database means to identify the database file as safe to open.

A) Securing
B) Enabling
C) Trusting
D) Splitting

Question 64

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

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 65

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 66

Which of the following Access options provides a way to set security,macro,and other privacy settings?

A) Add-ins
B) Current Database
C) Customize Ribbon
D) Trust Center

Question 67

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 68

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 69

How do you add an If statement to a module in the Visual Basic window?

A) Type the If keyword.
B) Double-click the If object in the Action Catalog.
C) Drag the If statement from the Statements list.
D) Click the Add Statement arrow on the Standard toolbar.

Question 70

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

A) Current Database
B) Trust Center
C) Client Settings
D) General

Question 71

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

Question 72

In an If statement,the _____ statement is executed when all If and ElseIf statements evaluate to false.

A) Then
B) End If
C) Else
D) True

Question 73

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 74

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

Question 75

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 76

A database in a trusted folder enables all database content,including all macros and VBA.

Question 77

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

A) Store the database in a trusted folder.
B) Change the Enable Content startup option.
C) Split the database.
D) Compact and repair the database.

Question 78

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