Deck 11: Analyzing Data With Business Intelligence

Question 1

Describe the two different types of modules.

Answer 1

• Visual Basic programming allows users to store group of procedures together at a place, they are called as Modules.
• Each Module consists of a declaration section followed by the group of procedures which are related to each other.
• There are two types of modules Standard Module and Class Module.
• Standard Module consists of set of procedures which can be used by more than one object of the database, these procedures are also called as public procedures as they can be accessed by any number of objects and also from anywhere in the database. Usually the standard modules are stored in the memory along with other database objects.
• Class Module consists of procedures which are specific to a particular database object like a form or a report. Only that particular object can access them.
• For example: in most of the programming languages we use two type of variables Local variables and global variables, local variables usage and value is restricted to the program similar to a Class Module procedures. Global variables can be used by any program from anywhere like a standard module and the values usually do not change.

Question 2

The
of a procedure is either private or public.

Answer 2

Sub procedures or subroutine code is always included between two sub statements indicating the beginning and end of a procedure. That is the subroutine code usually begins with a "Sub" statement followed by the set of instructions and end with an "End Sub" statement.
The begin "Sub" statement usually specifies the scope of the procedure that is whether the procedure is public or private. So Sub of a procedure can be declared either public or private.

Question 3

What can you accomplish in the Immediate window?

Answer 3

• Using Code window the different instructions, procedures of VBA are executed. Before that the procedures written using VBA can be tested in a window called immediate window. This window is used to test the procedures.
• We provide the procedure name and the input parameters required for executing the procedure. The result is also displayed on the window. When we test the procedure in an immediate window the data in the database is not changed.

Question 4

The VBA
statement executes one of two groups of statements based on a condition.

Question 5

What happens when you compile a module?

Question 6

What is the purpose of the Dim statement?

Question 7

The _________ function returns the numbers contained in a specified string as a numeric value.

Question 8

What is the purpose of the DoCmd statement?

Question 9

What is a method?

Question 10

What is a VBA constant?

Question 11

You can use the UCase function or the
function to convert a string to all uppercase letters.

Question 12

What does the Visible property determine?

Question 13

What does the ForeColor property determine?

Question 14

Why is Visual Basic for Applications called an event-driven, object-oriented language?

Question 15

What is an event procedure?

Question 16

What are the differences between a Function procedure and a Sub procedure?