Exam 18: Access: Powerpoint Rich Media Tools

A form that displays records horizontally, with label controls across the top and the data values in rows under the labels is in a ________ layout.

Ryan is preparing a report based on a table containing outstanding invoices. His boss has asked him to make sure the report includes a grand total. Ryan should include this information in the ________ section.

-Referencing the image above, what number represents the section that a page number would appear in the report?

Which of the following statements is TRUE when comparing forms and reports?

When you use the form tool to create a form, Access analyzes relationships between tables, and automatically adds a(n) ________, which displays records with foreign key values that match the primary key value in the main form.

Phil is designing a report in Access. He needs to change the design of some elements of the report, but also needs to use a filter to exclude some records in the report. He can use the ________ view to accomplish his tasks.

________ controls in a form are created from a text box control and contain an expression that generates a computed result when displayed.

Access provides built-in, colored ________ which can be applied to a report in order to enhance the appearance of the report and give the report a uniform appearance.

Mailing labels are preformatted reports that can be used with commercial label products.

The ________ control enables users to keep controls aligned horizontally and vertically, and give their forms a uniform appearance.

A form that displays fields in a vertical column, and displays one record at a time is in a ________ layout.

A Label control displays the data found in a form's record source.

-Referencing the image above, this Access report is shown in ________ view.

The form header section displays

You can remove the Detail section of a report by right-clicking any section bar and then clicking on the Detail section to remove it.

You can add Visual Basic for Applications (VBA) code to a form in ________ view.

Multiple items forms display multiple tables in a tabular layout.

All of the following are sections in an Access report EXCEPT:

It is helpful to sketch a form or report before creating these objects in Access.

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?