Exam 11: Using and Writing Visual Basic for Applications Code

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. -If the Paid field is marked as paid in the Participant Information form,Luca wants the following message to appear on the screen "Email the participant with the start date of the program." Which type of VBA control should Luca use in the procedure to create the message?

(Multiple Choice)

4.8/5

(33)

Question 41

Visual Basic for Applications is a(n)____ provided with Microsoft Office programs.

(Multiple Choice)

4.8/5

(41)

Question 42

A comment line in the Code windows is indented and appears in the color ___.

(Multiple Choice)

4.8/5

(37)

Question 43

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

(Multiple Choice)

4.8/5

(35)

Question 44

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. -After creating the message control using VBA,which property of the control must be coded to display the message "Email the participant with the start date of the program"?

(Multiple Choice)

4.7/5

(30)

Question 45

It is not possible to convert an Access macro to VBA code.

(True/False)

4.8/5

(28)

Question 46

A statement that contains the name of the function and any parameters required by the function.

(Multiple Choice)

4.8/5

(30)

Question 47

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 needs to use a VBA function in his code to return a value of True if the Paid field has no data or a value of False if the Paid field is not empty.Which VBA function should Luca use?

(Multiple Choice)

4.8/5

(29)

Question 48

Which VB data type stores values of True or False?

(Multiple Choice)

4.9/5

(31)

Question 49

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

(True/False)

4.8/5

(45)

Question 50

VBA is considered to be a(n)____ programming language because instructions are executed on objects in the database.

(Multiple Choice)

4.8/5

(34)

Question 51

Which of the following color options may be assigned to a control property as a VBA constant?

(Multiple Choice)

4.8/5

(41)

Question 52

The standard prefix for modules in Access.

(Multiple Choice)

4.9/5

(38)

Question 53

The event name for a procedure being viewed in the VBE is indicated in the Object box.____________________

(True/False)

4.9/5

(32)

Question 54

When a module is created it must begin with a Procedures section that applies to all procedures in the module.____________________

(True/False)

5.0/5

(35)

Question 55

A control is not displayed when the Visible property is to ____.

(Multiple Choice)

4.7/5

(39)

Question 56

The purpose of a VBA ____ is to respond to an event that occurs with an object or form control in an Access database.

(Multiple Choice)

4.7/5

(46)

Question 57

Designates the start of an alternative set of actions

(Multiple Choice)

4.8/5

(41)

Question 58

To declare variables and the VBA data types associated with those variables in a procedure a(n)____ must be used.

(Multiple Choice)

4.9/5

(43)

Question 59

List four advantages of using VBA rather than macros in Access.

(Essay)

4.8/5

(40)

Question 60

Showing 41 - 60 of 75

Visual Basic for Applications is a(n)____ provided with Microsoft Office programs.

A comment line in the Code windows is indented and appears in the color ___.

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

It is not possible to convert an Access macro to VBA code.

A statement that contains the name of the function and any parameters required by the function.

Which VB data type stores values of True or False?

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

VBA is considered to be a(n)____ programming language because instructions are executed on objects in the database.

Which of the following color options may be assigned to a control property as a VBA constant?

The standard prefix for modules in Access.

The event name for a procedure being viewed in the VBE is indicated in the Object box.____________________

When a module is created it must begin with a Procedures section that applies to all procedures in the module.____________________

A control is not displayed when the Visible property is to ____.

The purpose of a VBA ____ is to respond to an event that occurs with an object or form control in an Access database.

Designates the start of an alternative set of actions

To declare variables and the VBA data types associated with those variables in a procedure a(n)____ must be used.

List four advantages of using VBA rather than macros in Access.

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 Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 11: Using and Writing Visual Basic for Applications Code

Visual Basic for Applications is a(n)____ provided with Microsoft Office programs.

A comment line in the Code windows is indented and appears in the color ___.

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

It is not possible to convert an Access macro to VBA code.

A statement that contains the name of the function and any parameters required by the function.

Which VB data type stores values of True or False?

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

VBA is considered to be a(n)____ programming language because instructions are executed on objects in the database.

Which of the following color options may be assigned to a control property as a VBA constant?

The standard prefix for modules in Access.

The event name for a procedure being viewed in the VBE is indicated in the Object box.____________________

When a module is created it must begin with a Procedures section that applies to all procedures in the module.____________________

A control is not displayed when the Visible property is to ____.

The purpose of a VBA ____ is to respond to an event that occurs with an object or form control in an Access database.

​Designates the start of an alternative set of actions

To declare variables and the VBA data types associated with those variables in a procedure a(n)____ must be used.

List four advantages of using VBA rather than macros in Access.

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 Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Securing a Database

Relational Databases and Database Design

Filters

Designates the start of an alternative set of actions