When you have added a new linked table using VBA code and it does not appear in Navigation Pane that displays the list of tables, forms, macros, and queries in the database.  Which VBA code would you use to update the list of database objects displayed in the Navigation Pane.

Choose the VBA code that you would use to call a public function named VBAFunction from a form called FormA while passing a variant x1 in the module of FormB form. 

The ____________ allow(s) for multiple controls in a user form, to execute the same sub.

Which statement will assign a random integer from 1 to 5 to the variable x?

Without using SQL, choose the VBA code to allow you to delete the table Employees.

Choose the VBA code to filter the rowsource in a multiple column listbox that will allow you to filter the records listed using the LIKE statement and the variable xCompany.

Combine into one line: If x > 5 Then y = x - 5 End If

To change a comment in cell A1, which will do the job?

What is the difference between activating and initializing a user form?

Which of the following actions will NOT cause a macro to run in Excel?

Choose the VBA code that switches control from the application to the OS.