Exam 1: Access-2019

When you select a control in Form Design view and then press an arrow key, you _____ the control.

What happens when you close a module?

When designing a form for navigational purposes, it's best to set form properties such as Navigation Buttons, Record Selectors, and Control Box to No.

What types of errors occur only after you start running the code in the Visual Basic window?

Which of the following is a difference between Table Design view and Table Datasheet view?

What property would you use in an If statement to display a label in some records but not others?

You can use the _____ to apply the same formatting to multiple controls in a report.

If you want the State field to display "Iowa" in each new form record, you set the Control Value property for the State field.

When you convert an Access macro to VBA code, the VBA is stored in a standard module listed in the Navigation Pane with a name that starts with " New Macro."

Which Access tool guides you through the steps of creating a report?

To display the Visual Basic window, you click the Create tab on the ribbon, and then click Visual Basic.

Which field is always on the "one" side of a one-to-many relationship between two tables?

In which one of the following views can you edit the text in a label?

To change the text displayed on the report tab, you set the _____ property of the report.

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

A form ____ is the general way that the data and controls are arranged on the form.

_____ connects an Access database to data in an external file such as an Outlook folder.

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

Which of the following is a comment you could add to a VBA procedure?

The Name property for a form determines the text to display in the form's tab.