Question 1

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

Accepted Answer

A) standard module 
B) function statement 
C) public procedure 
D) declarations module 
A) standard module 
B) function statement 
C) public procedure 
D) declarations module C

Question 2

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 B

Question 3

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

Accepted Answer

The Answer of  Immediate window and Sub statement and is...

Question 4

Match between columns
                        Premises: A set of values for the colors red, green, and blue ranging from 0 to 255 which are used in a specific VB function.

Accepted Answer

The Answer of Assignment statement and Current and  Case is...

Question 5

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

Accepted Answer

A) Yes 
B) No 
C) True 
D) False 
A) Yes 
B) No 
C) True 
D) False

Question 6

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.

Accepted Answer

A) Function 
B) Sub 
C) Reference 
D) Comment 
A) Function 
B) Sub 
C) Reference 
D) Comment

Question 7

In the following code, which field in the associated form is being used for the Case structure?
   Select Case [Course]
   Case "CIS 101"
   lblMessage, Caption = "Prerequisite CIS 100 required"

Accepted Answer

A) CIS 101 
B) Course 
C) CIS 100 
D) Case CIS 101 
A) CIS 101 
B) Course 
C) CIS 100 
D) Case CIS 101

Question 8

Match between columns
                        Premises:  D isplays the event name for the current event procedure

Accepted Answer

The Answer of  Procedure box and  Case statement is...

Question 9

Match between columns
                        Premises: An error that occurs when a procedure produces incorrect results.

Accepted Answer

The Answer of Assignment statement and logic error and bas is...

Question 10

Match between columns
                        Premises: A statement that contains the name of the function and any parameters required by the function.

Accepted Answer

The Answer of RGB and  Case statement and function is...

Question 11

The Immediate window allows the developer to test or ____ individual lines of VBA code.

Accepted Answer

A) restore 
B) compile 
C) debug 
D) append 
A) restore 
B) compile 
C) debug 
D) append

Question 12

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

Accepted Answer

A) markup 
B) object-oriented 
C) compiler 
D) assembly 
A) markup 
B) object-oriented 
C) compiler 
D) assembly

Question 13

The function that accepts a single string argument as input, converts the value of the argument to lowercase letters, then returns the converted value is the LCase function. ____________________

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

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

Accepted Answer

A) vbProperCase 
B) vbLowerCase 
C) vbUpperCase 
D) vbAllCaps 
A) vbProperCase 
B) vbLowerCase 
C) vbUpperCase 
D) vbAllCaps

Question 17

Match between columns
                        Premises: The standard prefix for modules in Access.

Accepted Answer

The Answer of  Immediate window and  Procedure box is...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises:  T ests VBA procedures without changing any data in the database

Accepted Answer

The Answer of  Case statement and Load and bas is...

Question 20

Event procedures are always Sub procedures.

Accepted Answer

A) True 
 B)False

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

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

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

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.

In the following code, which field in the associated form is being used for the Case structure? Select Case [Course] Case "CIS 101" lblMessage, Caption = "Prerequisite CIS 100 required"

The Immediate window allows the developer to test or ____ individual lines of VBA code.

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

The function that accepts a single string argument as input, converts the value of the argument to lowercase letters, then returns the converted value is the LCase function. ____________________

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

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

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

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

Event procedures are always Sub procedures.

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters

Exam 11: Using and Writing Visual Basic for Applications Code

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

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

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

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.

In the following code, which field in the associated form is being used for the Case structure? Select Case [Course] Case "CIS 101" lblMessage, Caption = "Prerequisite CIS 100 required"

The Immediate window allows the developer to test or ____ individual lines of VBA code.

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

The function that accepts a single string argument as input, converts the value of the argument to lowercase letters, then returns the converted value is the LCase function. ____________________

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

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

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

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

Event procedures are always Sub procedures.

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters