Exam 11: Using and Writing Visual Basic for Applications Code

Explore all topics

To convert a string to proper case where the first letter of every word in the string is uppercase,the StrConv function is used in VBA code.____________________

(True/False)

5.0/5

(84)

Question 61

All event procedures in a class module are a(n)____ procedures which means they may only be used for the form or report for which the class module was created.

(Multiple Choice)

4.8/5

(70)

Question 62

Displays the event name for the current event procedure

(Multiple Choice)

4.7/5

(78)

Question 63

An error that occurs when a procedure produces incorrect results.

(Multiple Choice)

4.8/5

(73)

Question 64

The way an object responds when an event occurs is determined by an associated object property.____________________

(True/False)

4.7/5

(69)

Question 65

VBA is considered to be what type of language?

(Multiple Choice)

4.8/5

(85)

Question 66

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.

(Multiple Choice)

4.7/5

(73)

Question 67

Which VB constant used in conjunction with the StrConv function will convert all characters of a string to upper case letters?

(Multiple Choice)

4.7/5

(76)

Question 68

The type of procedure that may be used by more than one object in a database is a(n)____.

(Multiple Choice)

4.7/5

(84)

Question 69

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

(True/False)

4.9/5

(78)

Question 70

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

(Multiple Choice)

4.9/5

(81)

Question 71

The type of procedure that executes instructions and accepts input values,but does not return a value and cannot be used in expressions,is a(n)____ procedure.

(Multiple Choice)

4.9/5

(71)

Question 72

The statement that indicates a Case control structure ends with End Select.

(True/False)

4.9/5

(61)

Question 73

A control is hidden in Access when the Visible property is False in a Case statement.

(True/False)

4.7/5

(93)

Question 74

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

(True/False)

4.8/5

(74)

Question 75

Showing 61 - 75 of 75

To convert a string to proper case where the first letter of every word in the string is uppercase,the StrConv function is used in VBA code.____________________

All event procedures in a class module are a(n)____ procedures which means they may only be used for the form or report for which the class module was created.

Displays the event name for the current event procedure

An error that occurs when a procedure produces incorrect results.

The way an object responds when an event occurs is determined by an associated object property.____________________

VBA is considered to be what type of language?

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.

Which VB constant used in conjunction with the StrConv function will convert all characters of a string to upper case letters?

The type of procedure that may be used by more than one object in a database is a(n)____.

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

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

The type of procedure that executes instructions and accepts input values,but does not return a value and cannot be used in expressions,is a(n)____ procedure.

The statement that indicates a Case control structure ends with End Select.

A control is hidden in Access when the Visible property is False in a Case statement.

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

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

To convert a string to proper case where the first letter of every word in the string is uppercase,the StrConv function is used in VBA code.____________________

All event procedures in a class module are a(n)____ procedures which means they may only be used for the form or report for which the class module was created.

​Displays the event name for the current event procedure

An error that occurs when a procedure produces incorrect results.

The way an object responds when an event occurs is determined by an associated object property.____________________

VBA is considered to be what type of language?

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.

Which VB constant used in conjunction with the StrConv function will convert all characters of a string to upper case letters?

The type of procedure that may be used by more than one object in a database is a(n)____.

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

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

The type of procedure that executes instructions and accepts input values,but does not return a value and cannot be used in expressions,is a(n)____ procedure.

The statement that indicates a Case control structure ends with End Select.

A control is hidden in Access when the Visible property is False in a Case statement.

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

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

Displays the event name for the current event procedure