Exam 5: Creating Forms and Reports

Briefly explain options available for applying a theme to a form or report and other database objects.

A report layout may be changed using options on the ____________________ tab.

The Columnar form layout displays the fields from one record at a time.

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

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

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

The data outlined in the accompanying figure is an example of _____________________ applied to field values meeting one or more conditions.

After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

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

To generate a report with exact results based on specific criteria it is best to base the report on a(n) ____________________ created in the database.

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

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

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

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

Case-Based Critical Thinking Questions Case 4-1 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 wants the form layout to display the fields for only one record at a time.  Which form layout should Sergio select?

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

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.