Exam 8: Access

When you add a field to a form in Form Layout view, Access creates a text box but not a label.

In Print Preview, you can display the next page of a report by pressing the PAGE DOWN key.

The Database Documenter provides step-by-step help for using an Access database.

To use the Command Button Wizard, the _____ button must be toggled on.

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

If the _____ property for a form control is set to No, you cannot edit data in the control in Form view.

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

You must specify arguments for each action in a macro.

If you want to export records to another Access database, create a Top Values query.

When you use the _____, Access asks you for the information it needs to create a query.

To organize objects in the Navigation Pane, you can create a custom group.

To change an inner join relationship between tables for one query only to an outer join, you double-click the join line in Relationship Design view.

Which argument of the OpenReport macro action determines the report to open?

How do you add an If statement to a macro in Macro Design view?

Entering _____ in the Column Width property for a combo box sets the width of the first column to 0.5" and the width of the second column to 2".

Which of the following form controls could have an After Update event property that triggers a Sub procedure?

What do you use to open a database in Exclusive mode?

Characteristics, such as Field Name and Data Type, are_____ that define a field.

When you start Access, the first screen that appears is one showing a blank database.

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply.