Deck 7: Creating Custom Reports

Question 1

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

Answer 1

False

Question 2

Reports may only be viewed in Print Preview.

Answer 2

False

Question 3

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

Answer 3

B

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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 9

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 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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 21

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 22

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 23

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 24

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

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

Question 25

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 26

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

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

Question 27

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 28

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 29

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 30

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 31

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 32

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 33

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 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

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

Question 42

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 43

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

Question 44

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

Question 45

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 46

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 47

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

Question 48

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 49

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

Question 50

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 51

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

Question 52

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

Question 53

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 54

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 55

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 56

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 57

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 58

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 59

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 60

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

Question 61

List 3 reasons to create a custom report.

Question 62

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
Discuss four report design guidelines that should be followed when planning a report design.

Question 63

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
The type of report that displays summary information,such as grand totals and/or subtotals,using fields from a record source.

Question 64

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

Question 65

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
The control used to zoom in or out at variable increments in report view.

Question 66

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
The section of a report that usually displays subtotals or counts for records in a group.

Question 67

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
The section of a report that usually displays the group name and the sort field value for the group.

Question 68

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
The type of report that displays detailed information by displaying fields from the record source in the Detail section of the report.

Question 69

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
A field used to group the detail items in a report.

Question 70

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
The control on the status bar used in report view to zoom in or out in 10% increments.

Question 71

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

Question 72

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
A section that appears by itself at the top of a page and the detail lines for the section appear on the previous page.

Question 73

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
A formatted output (screen display or printout)of the contents of one or more tables in a database.

Question 74

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

Question 75

a.Zoom
b.Group Footer
c.summary report
d.report
e.group band field
f.orphaned footer section
g.detail report
h.orphaned header section
i.Zoom slider
j.Group Header
A section that appears by itself at the bottom of a page.