Exam 8: Access

Run the steps in a saved export using the _____ button on the External Data tab.

Each item on a form is called a _____.

If you do not enter a Caption property for a field, Access uses the field name to label the field.

To replace "coffee" with "beverage" in any part of a field, you click the _____ in the Find and Replace dialog box.

The edit record symbol (a pencil icon) appears to the left of a table record when you are selecting the record.

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

What is the result of selecting four text boxes, clicking the Size/Shape button on the Arrange tab, and then clicking To Narrowest?

Standard modules are available to which of the following objects? Select all the options that apply.

In Table Design view, you create a lookup list of values you enter using the _____ Lookup property of a field.

You use the _____ control when you want to link two reports together in the same report.

What would you use to quickly create an Issues table and related forms?

When you _____ a database, you make more storage space available and enhance the performance of the database.

When you import data from Excel, you can create a new table or add the records to an existing table.

To relate two tables in a one-to-many relationship, you connect them using a common field.

How do you align the right edges of selected controls in Form Design view?

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

In Report Layout view, you use the Format Painter to change the theme of a report.

Which of the following are action queries? Select all the options that apply.

If you move the source of a linked table, you must update its location using the Linked Table Manager.