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

________ view allows users to make changes to the layout while viewing the data on a form.

The table or query that supplies the underlying data for a form or report is called the ________ or data source.

A theme can be applied to a single form or to all the forms in a database.

To add a field to a report using the Add Existing Fields button, you must be in Design view.

To create a form, you click Form in the Forms group on the ________ tab.

The ________ view allows alterations to the form design while still viewing the data.

When viewing a form in Form view, you see that the records are displayed in order based on the primary key field. You prefer to temporarily view the records in alphabetical order by last names. Explain how to change the form to display records using the last name field, and how to return the form to display records in primary key order.

The ________ creates a customizable form that displays the data in a form in both Form view and Datasheet view at the same time.

All of the following are form creation tools EXCEPT:

Match each Report tool with its function: I. Report II. Report Design III. Blank Report IV. Report Wizard V. Labels A. Uses preformatted label templates B. Creates a custom report based on questions you answer C. Creates a tabular report showing all of the fields in the record source D. Creates an a new blank report in Layout view E. Creates an new blank report in Design view

ACCDB is a file type used to exchange documents independent of software applications and operating systems.

Which database object is used to add data into or edit data in a table?

You can sort the data in a form by double-clicking a field and selecting Sort A to Z or Sort Z to A.

When modifying a report, the ________ tab is used to change the layout of a report.

To sort the order of records in a form, you need to open the form in:

Labels and Text Boxes are known as controls.

The width of a field in a report can be changed in either Report or Design views.

When you use the Split Form tool, the ________ views are synchronized with each other at all times.

The Remove Layout command is only available when using Layout view.