VBA MCQs

To create one array variable to store monthly mortgage rates over the course of a year, the following is the best declaration statement.

To concatenate two lines of VBA code into one line, insert which character between the two joined lines?

In order to prevent users from deleting database objects displayed in the Navigation Pane, what VBA code would be used?

To return the value of the Access database file's path, what VBA code will retrieve the value?

How can we declare a subroutine or function in VBA?

Declaring a public variable allows the user to..

Which of these is not a Visual Basic object?

Is it possible to create an array with the lowerbound being two?

Choose the VBA code that will allow you to obtain information about an error.

The shortcut keystroke to open the VBA IDE is: