Exam 4: Creating Forms and Reports

Field values edited in Form view are also changed in the form's underlying table. ____________________

Report fields and field value boxes may be repositioned while viewing the report in Layout view.

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

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. -The faculty sponsor has asked Carmen to create a report that includes the participant email address and the location site assigned to the participant. He would also like to know how many tables and chairs each participant needs. Which tables and fields does Carmen need to use to create the report?

The first, last, next, or previous page in a report may be displayed using the ____________________ buttons.

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The wildcard character used to match any single alphabetic character.

The Form Wizard limits fields to be used in a form to one table or one query.

To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box.

The Tabular and Justified form report layouts display the fields from multiple records at one time. ____________________

Before applying a conditional format in a report, the ____ box must be selected.

To resize an image without changing its proportions, simply drag ____ of the image.

-In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view.

To print two records from a form, select the ____ option in the Print dialog box.

Why is it important to use Print Preview before printing a report in Access?

A report formatted in _____________________ is wider than it is tall.

When using the Report Wizard, the report title entered in the Wizard is also the name of the report ____________________.

-In the accompany figure, editing mode is indicated by which numbered arrow?