Question 1

A(n) ____________________ performs operations, returns a value, accepts input values, and may be used in expressions.

Accepted Answer

function,user-defined function

Question 2

Which of the following Access events accepts new or changed data from a user entry by default.

Accepted Answer

A)  OnClick 
B)  AfterUpdate 
C)  OnChange 
D)  OnKeyPress 
A)  OnClick 
B)  AfterUpdate 
C)  OnChange 
D)  OnKeyPress B

Question 3

An example of a conditional control structure is the Case control structure.____________________

Accepted Answer

A) True 
 B)False  True

Question 4

Event procedures are always Sub procedures.

Accepted Answer

A) True 
 B)False

Question 5

When using the RGB function in VBA, the color range for each value must be between the numbers of 0 through 150.

Accepted Answer

A) True 
 B)False

Question 6

It is important to enter VBA code using appropriate capitalization in all statements so that the code can be read and maintained properly.

Accepted Answer

A) True 
 B)False

Question 7

Case-Based Critical Thinking Questions Case 11-1
Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible.
Luca wants to be sure that a message appears to the user prompting that an email be sent to all program participants reminding them of the date the program begins when the Paid field in the form is marked paid.  What type of structure will Luca use to code an expression that tests the Paid field for an entry?

Accepted Answer

A)  If structure 
B)  Case control structure 
C)  Compare control structure 
D)  If, then structure 
A)  If structure 
B)  Case control structure 
C)  Compare control structure 
D)  If, then structure

Question 8

Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?

Accepted Answer

A)  Private Sub EventProcedure _ VB Constant     'Convert City to proper case     [ Field ] = VBA Function ([ Field ],   Event Procedure
End Sub 
B)  Private Sub Field _ EventProcedure     'Convert City to proper case     [ Field ] = VBA Function ([ Field ], VB Constant
End Sub 
C)  Private Sub Field _ EventProcedure     'Convert City to proper case     [ VB Constant ] = VBA Function ([ Field ], Field
End Sub 
D)  Private Sub VB Function _ EventProcedure     'Convert City to proper case     [ VBAFunction ] = ([ Field ], VB Constant
End Sub 
A)  Private Sub EventProcedure _ VB Constant     'Convert City to proper case     [ Field ] = VBA Function ([ Field ],   Event Procedure
End Sub 
B)  Private Sub Field _ EventProcedure     'Convert City to proper case     [ Field ] = VBA Function ([ Field ], VB Constant
End Sub 
C)  Private Sub Field _ EventProcedure     'Convert City to proper case     [ VB Constant ] = VBA Function ([ Field ], Field
End Sub 
D)  Private Sub VB Function _ EventProcedure     'Convert City to proper case     [ VBAFunction ] = ([ Field ], VB Constant
End Sub

Question 9

Which of the following is a method used in a procedure to move the focus to a specific object or control.

Accepted Answer

A)  Dim 
B)  SetFocus 
C)  Me.Undo 
D)  IsNull 
A)  Dim 
B)  SetFocus 
C)  Me.Undo 
D)  IsNull

Question 10

A ____ module is automatically created when the first event procedure for a form or report is created and it is associated with that specific form or report.

Accepted Answer

A)  class 
B)  local 
C)  standard 
D)  public 
A)  class 
B)  local 
C)  standard 
D)  public

Question 11

The default scope of event procedures in an Access database is ____________________ which means the procedure is only available to the object in which it was created.

Accepted Answer

The answer of The default scope of event procedures in...

Question 12

To assign a purple ForeColor property to a control, the ____ function of VBA must be used.

Accepted Answer

A)  vbColor 
B)  vbPurple 
C)  RGB 
D)  RGCYK 
A)  vbColor 
B)  vbPurple 
C)  RGB 
D)  RGCYK

Question 13

In the accompanying figure, Access will execute a group of statements only when the condition of the If statement is true; therefore, the false-statement group which is preceded by ____ in an If statement is omitted.

Accepted Answer

A)  Else 
B)  Then 
C)  If Else 
D)  If Not 
A)  Else 
B)  Then 
C)  If Else 
D)  If Not

Question 14

In addition to the single quotation mark ('), a comment line in VBA code may begin with ____.

Accepted Answer

A)  REM 
B)  COMMENT 
C)  slash (/) 
D)  semi-colon (;) 
A)  REM 
B)  COMMENT 
C)  slash (/) 
D)  semi-colon (;)

Question 15

Which of the following is a type of VBA procedure?

Accepted Answer

A)  Format 
B)  Control 
C)  Reference 
D)  Function 
A)  Format 
B)  Control 
C)  Reference 
D)  Function

Question 16

List the five VBA naming rules that must be followed when naming VBA elements such as Sub procedures, arguments, and functions

Accepted Answer

1. The name must begin with a letter. 
2

Question 17

Match between columns
                        Premises: A statement that assigns the value of an expression to a field, control, or property.

Accepted Answer

The Answer of Visual Basic window and logic error and is...

Question 18

An action that operates on specific objects or controls such as clearing a field in a form when the information entered does not meet the validation requirements as specified in a procedure is called a(n) ____________________.

Accepted Answer

The answer of An action that operates on specific objects...

Question 19

Access events all have associated event properties.____________________

Accepted Answer

A) True 
 B)False

Question 20

Which code statement will test a control to see if the data meets specific requirements?

Accepted Answer

A)  VisitDate.ForeColor=vbRed 
B)  ZipCode=27531 
C)  Select Case [State] 
D)  If VisitDate 
A)  VisitDate.ForeColor=vbRed 
B)  ZipCode=27531 
C)  Select Case [State] 
D)  If VisitDate

A(n) ____________________ performs operations, returns a value, accepts input values, and may be used in expressions.

Which of the following Access events accepts new or changed data from a user entry by default.

An example of a conditional control structure is the Case control structure.____________________

Event procedures are always Sub procedures.

When using the RGB function in VBA, the color range for each value must be between the numbers of 0 through 150.

It is important to enter VBA code using appropriate capitalization in all statements so that the code can be read and maintained properly.

Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?

Which of the following is a method used in a procedure to move the focus to a specific object or control.

A ____ module is automatically created when the first event procedure for a form or report is created and it is associated with that specific form or report.

The default scope of event procedures in an Access database is ____________________ which means the procedure is only available to the object in which it was created.

To assign a purple ForeColor property to a control, the ____ function of VBA must be used.

In the accompanying figure, Access will execute a group of statements only when the condition of the If statement is true; therefore, the false-statement group which is preceded by ____ in an If statement is omitted.

In addition to the single quotation mark ('), a comment line in VBA code may begin with ____.

Which of the following is a type of VBA procedure?

List the five VBA naming rules that must be followed when naming VBA elements such as Sub procedures, arguments, and functions

An action that operates on specific objects or controls such as clearing a field in a form when the information entered does not meet the validation requirements as specified in a procedure is called a(n) ____________________.

Access events all have associated event properties.____________________

Which code statement will test a control to see if the data meets specific requirements?

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Sharing a Database

Filters

Exam 12: Using and Writing Visual Basic for Applications Code

A(n) ____________________ performs operations, returns a value, accepts input values, and may be used in expressions.

Which of the following Access events accepts new or changed data from a user entry by default.

An example of a conditional control structure is the Case control structure.____________________

Event procedures are always Sub procedures.

When using the RGB function in VBA, the color range for each value must be between the numbers of 0 through 150.

It is important to enter VBA code using appropriate capitalization in all statements so that the code can be read and maintained properly.

Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?

Which of the following is a method used in a procedure to move the focus to a specific object or control.

A ____ module is automatically created when the first event procedure for a form or report is created and it is associated with that specific form or report.

The default scope of event procedures in an Access database is ____________________ which means the procedure is only available to the object in which it was created.

To assign a purple ForeColor property to a control, the ____ function of VBA must be used.

In the accompanying figure, Access will execute a group of statements only when the condition of the If statement is true; therefore, the false-statement group which is preceded by ____ in an If statement is omitted.

In addition to the single quotation mark ('), a comment line in VBA code may begin with ____.

Which of the following is a type of VBA procedure?

List the five VBA naming rules that must be followed when naming VBA elements such as Sub procedures, arguments, and functions

An action that operates on specific objects or controls such as clearing a field in a form when the information entered does not meet the validation requirements as specified in a procedure is called a(n) ____________________.

Access events all have associated event properties.____________________

Which code statement will test a control to see if the data meets specific requirements?

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Sharing a Database

Filters