Exam 3: Access: Creating Custom Reports

Labels can only be printed in an Access report using the across, then down sequence.

In the accompanying figure, which numbered arrow indicates the report results are filtered?

A filter may be applied to data when a report is viewed using the Layout view .

The Keep Together property, which determines how group data will be printed, is set using the ____________________.

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report.

Use the Visible property in a report to hide a control when the control's value is the same as the value of the preceding record in the group.

Values in a selected column may be summarized using any of eight ____________________ functions on the Totals menu from the DESIGN tab.

Use the ____________________ to quickly create labels based on uniquely identified label templates.

By default, the Report tool and the Report Wizard include the page number control in the ____ section.

Layout view must be used to select all controls in a report and to remove an individual control from the selection.

Design view should be used to modify a report when the user wants to add lines, rectangles, and other controls only available in Design view .

The text box property that allows the box to expand vertically to fit the field value is the ____ property.

The Detail Section of a report usually contains most of the report contents.

The ____ section appears at the bottom of each page of a report and is used for page numbers and brief explanations of symbols or abbreviations, among other elements.

Case Based Critical Thinking Questions Case 7-1 Carlos is not familiar with creating Access reports and has asked his friend Nina to help him create some useful reports from his organic produce farm data. The organic farm currently has three tables, as illustrated below. Using the information provided, determine the best answers for the questions below. Nina does not see any fields available to add to the report after making the correct selection from the DESIGN tab on the Report Layout Tools Ribbon. What is most likely the problem?

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

Live data is not visible in controls when making changes to a report in Design view.

In the accompanying figure, if the Format is changed to Page N of M, how will the page number be displayed for a 3 page report?

In the expression =Date(), used to return the current date, which portion of the expression is the name of the function?

In the accompanying figure, which numbered arrow indicates the Report view button.