Programming Final Review
When the user types input into a TextBox Control, in which property is it stored?
Which character is the string concatenation operator?
You can modify a control's position in the tab order by changing which property?
In a flowchart the rectangle indicates...
Relational operators allow you to ______________ numbers.
What does the hide method do?
Removes a form from the screen but does not remove it from memory
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.
Which of the following is NOT an example of an object?
An input box returns the value entered by the user as this.
In the code window, which of the following color indicates a key word?
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.
In what way is a function different from a procedure?
A function returns a value and a procedure does not.
When this form is displayed, no other form in the application can receive the focus until the form is closed.
Which of these operations DOES NOT require a Do...Loop?
Adding two variables that are obtained from user input.
The process of checking data entered by a user to ensure it meets certain conditions is called:
VBA executes the procedure in design-time.
The result of the operation: 10 MOD 3
Which financial function calculates the monthly payment for a mortgage?
You should be very cautious about, and even avoid, placing comments in your code.
When a string variable is created in memory, Visual Basic assigns the initial value of 0.
All of the above
The following block of code shows which of the following?
How to change the value of a range in a specific worksheet.
Which of the following is NOT a property of a function procedure?
They can happen automatically.
Which converts values into numeric data for calculations?
Which is one execution of a loop statement?
Which specifies items that will appear in a list box or combo box at run time?
Which is true of Option Explicit?
The programmer must define a variable before it is used.
What is needed to create a many to many relationship in Access?
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)
________ allow(s) relationships between two tables to be created on a common field.
Date() function enables you to:
insert today's date into an expression
special characters that represent one or more characters in a text value in a criteria.
An argument is:
a variable or constant that is needed to produce the output for a function.