Access Tutorial 7

A custom report may be created using Layout view or Design view.

Spacing and punctuation for mailing labels is determined by spacing and punctuation inserted in the ____ box.

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

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

Which section contains content that will appear at the top of every page of a report?

The Line tool is accessed using the More button in the ____ group on the DESIGN tab.

In the accompanying figure, which section of the report has a Height property set to zero?

Janise often has requests for specific pet sitters when clients request services. She has created a report that shows the sitter preferred by each client as well as the pet names, pet type, and special requests by the clients. Janise will keep the report handy in digital and printed form for reference when clients call so that she can offer personalized service to her clients. To make the report more user-friendly, Janise needs to make some adjustments. To further personalize her pet sitting service, Janise has decided to mail each client a postcard with a 10% discount for the month of each pet's birthday. She will be creating mailing labels from her Clients table. Janise will set the formatting for the mailing labels in the ____ of the Label Wizard.

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 successfully added the required fields to the report. Now she wants to sort the report alphabetically by the customer's last name. To Add a Sort Field, Nina must first be in ____ view.

Janise often has requests for specific pet sitters when clients request services. She has created a report that shows the sitter preferred by each client as well as the pet names, pet type, and special requests by the clients. Janise will keep the report handy in digital and printed form for reference when clients call so that she can offer personalized service to her clients. To make the report more user-friendly, Janise needs to make some adjustments. After printing the report, Janise notices that there is no page number on her report. She would like to add the page number at the bottom of the report. She may add the page number to the bottom of her report in the ____ section of the report.

To begin the process of removing the default alternate row color in a report, select the ____ Border Style after selecting all sections of the report from the FORMAT tab.

Selected portions of a report may be copied to the Clipboard and pasted into a Word document when viewing a report in Report view.

A typical Group Footer section will include which type of data?

What is the maximum number of sort fields that can be included in a report?

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. Carlos has asked Nina to create a report that will list all of his customers by last name with their email addresses. To begin creating the custom report after opening the database, Nina will choose the ____ from the CREATE tab on the Ribbon.

A text box that is too narrow to display the full field value will display the pound sign (#), which means the ____ of the text box must be adjusted.

The format for a label is displayed in the Prototype label box when using the ____.

Janise often has requests for specific pet sitters when clients request services. She has created a report that shows the sitter preferred by each client as well as the pet names, pet type, and special requests by the clients. Janise will keep the report handy in digital and printed form for reference when clients call so that she can offer personalized service to her clients. To make the report more user-friendly, Janise needs to make some adjustments. Options for Janise to choose when adding the page number to the bottom of her report pages may be selected from the ____, available from the Page Numbers button in the Header/Footer group on the DESIGN tab.

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

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

Common properties for multiple controls may be set by performing which of the following tasks?

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

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view.

Which report view is the best to use to see what a report will look like when it is printed?

It is best to wait until all objects of a database have been created before choosing a theme other than the default theme for a database.

To set a report's margins to Wide with 1" top and bottom margins and 0.75 left and right margins, click on the Margins button on the ____ tab in Report Design Tools.

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. Next, Nina needs to add the fields FirstName, LastName, and EmailAddress to the report. She must select ____ from the DESIGN tab while in the Report Layout Tools section of the Ribbon.

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

Access allows the creation of mailing labels based on manufacturer templates or custom formatted labels.

Which option will allow you to increase the height of the Page Header using the mouse?

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 has completed the report Carlos requested, but she notices that the columns of the report are not spaced equally. Nina can fix this problem quickly by selecting the entire report in Design view and choosing the Equal Horizontal option from the Size/Space button on the ____ tab.

Page numbers must be added to a report in Design view.

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

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

To modify a report while viewing actual report data, use the ____ view.

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

The Page Numbers button, used to add a page number expression to a report, is found in the ____ group on the DESIGN tab.

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

A field's data type and the selected value determine the ____ options that appear on the shortcut menu in Report view.

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.

The Currency control format adds comma separators and a maximum of two decimal places.

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?

Which of the following is an advantage of using a query as a record source for a report?

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

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

Options for modifying a report's grouping fields, sorting fields, and report calculations for the groups are available using the ____.

The Group, Sort, and Total pane is used to select sort fields and grouping fields for a report. Select one:

A label control must be used when a report requires a specific date that is not the current date.

Janise often has requests for specific pet sitters when clients request services. She has created a report that shows the sitter preferred by each client as well as the pet names, pet type, and special requests by the clients. Janise will keep the report handy in digital and printed form for reference when clients call so that she can offer personalized service to her clients. To make the report more user-friendly, Janise needs to make some adjustments. Janise notices, after viewing the report in Report view, that the Special Requests field does not show all of the data she needs to view. Which property should she change for the text box containing the Special Requests field information?

A field's data type and the selected value determine the ____ options that appear on the shortcut menu in Report view.

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?

Records in a report may be sorted using only one sort field.

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.

To obtain maximum report width, calculate the report width by subtracting the size of the ____ from the width of the page which will be used to view or print the report..

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. Next, Nina needs to add the fields FirstName, LastName, and EmailAddress to the report. She must select ____ from the DESIGN tab while in the Report Layout Tools section of the Ribbon.

Options for modifying a report's grouping fields, sorting fields, and report calculations for the groups are available using the ____.