Exam 1: Access 2019

Which control provides consistent descriptive text as you navigate from record to record in a form?

To add VBA code to a macro embedded in a report, you can first _____ the macro to VBA code.

What happens if you delete a row from the query design grid?

A(n) _____ is a common control to place within an option group.

What is the result of using the Database Documenter?

To delete a field in Table Datasheet view, you click _____.

After editing a procedure, click the Reset button to execute the procedure.

The _____ property makes sure that controls in the report section repeat at the top of every page.

When you import data from Excel, you use the link option to add the Excel data to an existing Access table.

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

Comment lines start with an exclamation point (!) and are red in the Visual Basic Editor.

What does the criterion

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Which of the following object prefixes is short for Visual Basic and applies to standard (global) modules?

The fields and data types in an Append query must _____.

Sorting a table datasheet temporarily displays only those records that match given criteria.

To create a backup of a module, you can right-click a module to copy and paste it like any other object.

How does VBA treat comments when you run the code in the Visual Basic window?

In an Employees table, what is the appropriate data type for a field that shows the hiring date?