Deck 3: Access 3: Creating Custom Reports

Question 1

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

Answer 1

False

Question 2

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. ____________________

Answer 2

False

Question 3

A report sort field that includes a Group Header section and a Group Footer section is a grouping field. ____________________

Answer 3

True

Question 4

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

Question 5

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

A)Wizard
B)custom
C)grid
D)auto

Question 6

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

Question 7

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

Question 8

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

Question 9

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 . ____________________

Question 10

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

Question 11

Yes/no and true/false fields are represented with check boxes in a report.

Question 12

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

Question 13

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

Question 14

Reports may only be viewed in Print Preview.

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

A)visible
B)sorted
C)similar
D)formatted

Question 22

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

A)5
B)10
C)12
D)unlimited

Question 23

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

A)select each control separately and change the properties
B)select adjacent controls only using the Ctrl key and the mouse; then change the properties for adjacent controls one at a time
C)select adjacent and nonadjacent controls using the Ctrl key and the mouse; then change the properties for all controls at once
D)change the properties to apply to all controls then select the controls by clicking on the controls with the mouse

Question 24

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

A)Report view
B)Print Preview
C)Layout view
D)Design view

Question 25

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

A)Layout
B)Design
C)Print Preview
D)Report

Question 26

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.

A)height
B)position
C)width
D)format

Question 27

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

A)Header/Footer
B)Themes
C)Tools
D)Controls

Question 28

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.

A)Group Footer
B)Page Footer
C)Report Footer
D)Detail

Question 29

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

A)padding
B)keep whole group together on one page
C)keep header and first record together on one page
D)do not keep group together on one page

Question 30

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

A)Design
B)Arrange
C)Format
D)Page Setup

Question 31

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

A)control
B)filter
C)preview
D)properties

Question 32

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

A)Print Preview
B)Layout view
C)Design view
D)Report view

Question 33

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

A)a count or subtotal for records in that group
B)the date and time the report was generated
C)the report page number
D)detail fields for all records included in the group

Question 34

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.

A)Page Header section
B)Group Header section
C)Report Header Section
D)Detail section

Question 35

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

A)Page Footer
B)Report Footer
C)Group Footer
D)Page Header

Question 36

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

A)a query contains only simple data fields
B)a query includes only one table
C)fields can easily be added to a query as report requirements change, including calculated fields
D)fields from a query record source do not require additional property changes

Question 37

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

A)Can Grow
B)Width
C)Can Shrink
D)Bottom Margin

Question 38

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

A)Group Header
B)Report Header
C)Page Header
D)Document Header

Question 39

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.

A)Format
B)Print
C)Arrange
D)Page Setup

Question 40

Which control format property adds comma separators and two decimal places in report Design view.

A)Standard
B)Currency
C)Fixed
D)General Number

Question 41

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

A)Font style
B)Font size
C)Font color
D)Font weight

Question 42

A ____________________ report prints the same collection of field values in two or more sets across a page.

Question 43

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

A)Label fields
B)Prototype label
C)Table fields
D)Source label

Question 44

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

A)Header/Footer
B)Arrange
C)Tools
D)Theme

Question 45

Placing the report title, date, and page number on the same line in the ____ is a common report standard.

A)Report Header
B)Page Header
C)Report Footer
D)Page Footer

Question 46

The ____________________ option from the Size/Space button on the ARRANGE tab creates equal spacing between horizontal controls.

Question 47

A sort field must also be designated as a____________________field in order to include a Group Header and a Group Footer section in the report for a group.

Question 48

The expression =Date(), inserted in a text box in a report design, will return the ____________________ value.

Question 49

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

A)Label Wizard
B)Repot Wizard
C)Form Wizard
D)Custom Label Wizard

Question 50

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

A)=
B)Date()
C)Date
D)=Date

Question 51

The ____________________ section in Design view appears at the top of each page of a report and usually contains page numbers, column headings, report titles, and report dates.

Question 52

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

Question 53

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

A)change the Height property of the Page header section
B)set the Can Grow property to Yes
C)drag the Page Header border down to the desired height
D)click on the ruler at the desired height setting

Question 54

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

Question 55

The combination of the keys ____________________on the keyboard will select all items in a report when viewing a report in Report view.

Question 56

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.

A)Solid
B)Transparent
C)None
D)All

Question 57

When the Title button on the Design tab is used to insert a title on a report, the title is added to the ___________________ section by default.

Question 58

To zoom in or out when viewing a report, use ____________________ to view the report.

Question 59

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

Question 60

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..

A)Report Header
B)Top and Bottom margins
C)Left and Right margins
D)Report Header and Footer

Question 62

List 3 reasons to create a custom report.

Question 63

Properties of a multiple-column report may be changed using the ____________________ section of the Page Setup dialog box.

Question 64

Discuss four report design guidelines that should be followed when planning a report design.

Question 65

When you copy information contained  in an Access object such as a report, it is placed on the __________.

Question 66

Describe five common enhancements and corrections that may be needed when modifying a report.