Question 1

Comments appear _____ of a macro.

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Class modules are stored in an individual form or report.

Accepted Answer

A) True 
 B)False

Question 10

Why would you create a function in a standard module?

Accepted Answer

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 
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 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

Comments appear _____ of a macro.

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

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

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

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

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

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

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

Class modules are stored in an individual form or report.

Why would you create a function in a standard module?

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

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

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

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

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

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

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

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

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Developing an Excel Application

Filters

Exam 11: Exploring Pivottable Design

Comments appear _____ of a macro.

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

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

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

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

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

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

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

Class modules are stored in an individual form or report.

Why would you create a function in a standard module?

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

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

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

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

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

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

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

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

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Developing an Excel Application

Filters

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