Programming Final Review

Helpfulness: 0
Set Details Share
created 5 years ago by bergmanalex13
131 views
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

When the user types input into a TextBox Control, in which property is it stored?

Text

2

Which character is the string concatenation operator?

&

3

You can modify a control's position in the tab order by changing which property?

TabIndex

4

In a flowchart the rectangle indicates...

Processing

5

Relational operators allow you to ______________ numbers.

Compare

6

What does the hide method do?

Removes a form from the screen but does not remove it from memory

7

This operator connects two Boolean expressions into one. One or both expressions must be true for the overall expression to be true. It is only necessary for one to be true, and it does not matter which.

OR

8

Which of the following is NOT an example of an object?

Font Size

9

An input box returns the value entered by the user as this.

String

10

In the code window, which of the following color indicates a key word?

Blue

11

This type of loop is ideal for situations that require a counter because it is specifically designed to initialize, test, and increment a counter variable.

For....Next

12

In what way is a function different from a procedure?

A function returns a value and a procedure does not.

13

When this form is displayed, no other form in the application can receive the focus until the form is closed.

Modal

14

Which of these operations DOES NOT require a Do...Loop?

Adding two variables that are obtained from user input.

15

The process of checking data entered by a user to ensure it meets certain conditions is called:

Data Validation

16

VBA executes the procedure in design-time.

False

17

The result of the operation: 10 MOD 3

1

18

Which financial function calculates the monthly payment for a mortgage?

IMPT

19

You should be very cautious about, and even avoid, placing comments in your code.

False

20

When a string variable is created in memory, Visual Basic assigns the initial value of 0.

False

21

Variables:

All of the above

22

The following block of code shows which of the following?

Workbook("Loan Calculator.xlsx").Worksheets("Payment").Range("B5").Value=150000

How to change the value of a range in a specific worksheet.

23

Which of the following is NOT a property of a function procedure?

They can happen automatically.

24

Which converts values into numeric data for calculations?

Val function

25

Which is one execution of a loop statement?

Iteration

26

Which specifies items that will appear in a list box or combo box at run time?

RowSource property

27

Which is true of Option Explicit?

The programmer must define a variable before it is used.

28

What is needed to create a many to many relationship in Access?

Junction Table

29

Which of the following is NOT a type of relationship used by Access to manage relationships between tables?

Cascade update related records. (are: Enforce Referential Integrity, Cascade update related fields, cascade delete related records)

30

________ allow(s) relationships between two tables to be created on a common field.

Join Lines

31

Date() function enables you to:

insert today's date into an expression

32

Wildcards are:

special characters that represent one or more characters in a text value in a criteria.

33

An argument is:

a variable or constant that is needed to produce the output for a function.