Exam 8: Access

To add a title to a report in Report Layout view, you click the _____ button on the Design tab.

To display the contents of a text box in more than one font size or color, set the _____ property of the text box to RTF.

A(n) _____ relates a record of a table to another record in the same table.

How do you display the records in a subdatasheet?

What could you do to clarify that the TaxRate field in a report contains percentages?

After you split a database, what does the back-end database contain?

_____ connects an Access database to data in an external file, such as an Excel spreadsheet or Outlook folder, but does not copy the data into the database.

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Which of the following commands can you use to add a picture to a form? Select all the options that apply.

Delete queries delete entire records, not just selected fields within records.

An Access chart displays data in rows and columns, similar to a spreadsheet.

Which of the following types of external files can you link to an Access database? Select all the options that apply.

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

You use _____ to mark up structured data so you can easily share the data with other programs.

A(n) _____ is a template for creating a table that contains fields and specifies their data types.

A common way to run a macro is to assign it to a command button.

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

Which of the following are common macro actions? Select all the options that apply.

To move a field in Query Design view, you drag the field by its field selector.

When do most class modules run?