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

To change the text displayed in a label on a form, choose the VBA code that will allow you to update the property.

Which code will allow user to edit a password protected worksheet.

When stepping through code as a way to see how the values in variables change, use the:

Choose the VBA code that will allow you to verify that an Item exists in the Dictionary object Dict1. 

What value is x holding after this statement is executed: x = Left("Apple",3) & Right("People", 3)

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.

What will Format(“A123”, “&&&&&&”) output?

Which is NOT a method of the Workspace object:

You want to count how many records for a given customer based on CustomerID which is of field type short text in table tblCustomer. The customer id we want the count for is 123-AC. We are using the domain aggregate function DCount and assign it to an integer variable intC what is the correct syntax.

Which function will allow you to convert a value to number?