Exam 8: Access

A_____ procedure is generally executed when an event occurs.

Which of the following are settings you can select as you import data from Excel using the Import Spreadsheet Wizard? Select all the options that apply.

You can drag a report from the Navigation Pane to an [Add New] button to add the report to the navigation form in Form Layout view.

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

Which of the following are properties you can set for a query? Select all the options that apply.

Which argument of the MessageBox macro action determines the icon in the message dialog box?

Clicking in the vertical ruler in Report Design view selects _____.

Which of the following views provides the most options for creating and modifying a report?

Class modules most commonly run in response to an event, such as a user clicking a command button.

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

If you export form data as a(n) _____ file, you can view the data but not change it.

In which of the following circumstances would you copy an entire table?

_____ are statements in the code that document the code and do not affect how it runs.

To use data from an Access form on a webpage, you can _____.

Which two properties control how a form and subform are linked?

You use the _____ button in the Sort & Filter group to use features such as Save As Query and Clear All Filters.

You can format a table datasheet by setting the alternate record color in Table Datasheet view.

A(n) _____ procedure manipulates controls and objects.

Which of the following changes can you make to a form in Form Layout view? Select all the options that apply.

The _____ refers to the data you would edit if you started typing.