Exam 4: Creating Forms and Reports

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below. -Before printing the report, Carmen uses ____ to view the page breaks and make sure that no records are split across pages.

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n) ____________________.

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -A report must be in Design view or this view to apply conditional formatting.

Access allows all pages, a range of pages, or a currently selected record to be printed from Form view. ____________________

-In the accompanying figure, which numbered arrow indicates the button that moves the Form Wizard to the second dialog box where a form layout may be chosen.

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. -Sergio would like to create a form for Carmen to use to enter information about the participants. Which table should Sergio use to create the form?

-In the accompanying figure, the ____ Access database object is indicated by the icons shown in bracket number 3.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The easiest way to move a picture on a form is to first remove the picture from the ____.

Clicking the button moves all fields from the Available Fields box to the Selected Fields box using the Report Wizard.

A report formatted where the page is taller than it is wide is formatted in ____.

The less precise way to move objects in report Layout view is to ____.

-In the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in ____ view.

Data in a form may only be modified in ____ view.

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. -The Facet theme is currently the theme for the form Sergio has created. He wants to change the theme to the Slice theme and apply the Slice theme to all of the database objects. To apply the new theme, Sergio must be in the ____ or Design view.

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. ____________________

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. -After reviewing the form Sergio decides he wants to create a form that will allow Carmen to enter both the participant information and the amount due by the participant. Sergio will need to use two tables to accomplish this. The second table will be the ___ in the form.

A form created from more than one table uses the primary table for the main form.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The Report Wizard window makes this option available to display tips for creating reports.

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.