Exam 4: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

When Access creates a form with two record sources having a one-to-many relationship, the one record source is displayed in the main form and the many record source is display in a ________.

The ________ is a file type that was created for exchanging documents independent of software applications and operating systems.

When the form tool is used to create a form with related tables, Access automatically adds a(n) ________ to the main form

The first step in planning a report is to identify the record source.

When viewing a report in Layout view, you see that the records are displayed in order based on the primary key field. You prefer print the records in alphabetical order by last names and then by first names. Explain how to sort the report to display records using the last name and first name fields.

A ________ is a defined set of colors, fonts, and graphics that can be applied to a form or report.

Report tool creates a tabular report based on the selected table or query.

The ________ displays data horizontally across the page.

A(n) ________ form displays all fields from a record source in a tabular layout similar to a table's Datasheet view.

Form view allows changes to the data and layout.

Design view displays a form's data and layout.

________ is used to see exactly what a report will look like when it is printed.

Referencing the image above, this form is shown in ________ view.