Deck 3: Access: Creating Custom Reports

Question 1

If your report has a Group Footer section it precedes the Page Footer section on the last page of the report.

Answer 1

False

Question 2

Access uses the Page Footer section for the page number.

Answer 2

True

Question 3

In a mailing label if the Company field value is null in the second line you must manually move up the third and fourth lines to eliminate the blank line on the label.

Answer 3

False

Question 4

When you design your report you determine which sections to include and what information to place in each section.

Question 5

Which view you choose depends on what kind of data is in your report.

Question 6

Each report can have up to 17 sort fields and any of its sort fields can also be grouping fields.

Question 7

You use the Group Sort and Total pane to select sort fields and grouping fields for a report.

Question 8

You can click the Insert Page Number button in the Controls group in Layout or Design view to add a page number expression to a report.

Question 9

Although you can format and print using queries forms and reports datasheets offer you greater flexibility and provide a more professional custom appearance.

Question 10

To select a portion of a report instead of the entire report click to the left of the top of the selection and drag down to the bottom of the selection.

Question 11

The Page Header section appears once at the beginning of a report.

Question 12

You usually determine page setup properties when you design a report or after you have placed the controls in the Detail section.

Question 13

When you use the Report tool Access places the report title in the Page Header section.

Question 14

Before you create a custom report you should first plan the report's contents and appearance.

Question 15

Access lets you organize records in a report by sorting them using one or more grouping fields.

Question 16

If your report has a Page Header section it precedes the first Report Header section.

Question 17

If your label manufacturer or its labels do not appear in the Label Wizard list box you cannot use the wizard to create labels.

Question 18

The source data for a report cannot come from more than one table or query.

Question 19

You do not have to include all seven sections in a report.

Question 20

A report can have up to 22 grouping levels.

Question 21

You can use the Drawing tool to add lines to a report.

Question 22

You put the values that exceed $25 000 in the ContractAmt field into a red font; this is an example of ____ formatting.

A)value-based
B)conditional
C)value-contingent
D)contingent

Question 23

You can switch views by double-clicking the object tab and then clicking the view option on the shortcut menu.

Question 24

When you design or create your own report from scratch you produce a(n)____ report.

A)index
B)wizard
C)unbound
D)custom

Question 25

You place the Total function in a Group Footer section to print each group's total.

Question 26

Placing the report title in the Report Header section allows users to identify the report title on any page without having to turn to the first page.

Question 27

Which of the following offers you the more flexibility in formatting and printing data with a professional custom appearance?

A)datasheets
B)queries
C)forms
D)reports

Question 28

Each sort field can also be designated a(n)search field.

Question 29

Calculated formatting lets you change the format of a report or form control based on the control's value.

Question 30

For reports and forms that use data from multiple tables and\or queries you should create a query to serve as the record source.

Question 31

A Group Footer section typically includes a count or subtotal for records in that group.

Question 32

A ____ is the formatted printout (or screen display)of the contents of one or more tables from a database.

A)datasheet
B)report
C)query
D)section

Question 33

A(n)section field is a report sort field that includes a Group Header section before a group of records that has the same sort field value and that includes a Group Footer section after the group of records.

Question 34

You can view reports on screen in all of the following EXCEPT ____.

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

Question 35

In the accompanying figure Now()is a function for the current time .

Question 36

In the accompanying figure the figure $174 250 appears in the Page Footer section.

Question 37

Eight aggregate functions including the Sum function are available on the Totals menu for summarizing values in the selected column.

Question 38

Use Layout view when you want to see what a report will look like when it is printed.

Question 39

A Report Header section typically includes the name of the group.

Question 40

You usually should position fields vertically in a report.

Question 41

The accompanying figure shows the ____ Footer section with zero height.

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

Question 42

All of the following are Totals menu options EXCEPT ____.

A)Record Values
B)Variance
C)Min
D)Standard Deviation

Question 43

You can use Report view to apply a(n)____ to the data in a report.

A)key
B)index
C)filter
D)gauge

Question 44

Use ____ when you want to modify a report while seeing actual report data.

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

Question 45

The ____ Header section appears once at the beginning of a report.

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

Question 46

____ is the only view in which you can navigate the pages of a report.

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

Question 47

When you use an aggregate function in ____ Access adds the results of the function to the end of the report and adds subtotals for each grouping field.

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

Question 48

Use ____ when you want to add lines to a report.

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

Question 49

If your report has a(n)____ Header section it precedes the first Page Header section.

A)Group
B)Report
C)Detail
D)Access

Question 50

Use the ____ Header section to print the group name and field value that all records in the group have in common.

A)Page
B)Report
C)Group
D)Field

Question 51

The ____ Header section is used for report titles company logos report introductions and cover pages.

A)Page
B)Access
C)Report
D)Group

Question 52

The view shown in the accompanying figure is ____.

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

Question 53

Design view for forms and reports includes horizontal and vertical rulers grids in each section and similar buttons in groups on the ____ tab.

A)Layout
B)Design
C)Format
D)Options

Question 54

All of the following are Text Filters submenu options EXCEPT ____.

A)Sounds like…
B)Equals…
C)Begins With…
D)Contains…

Question 55

The ____ Header section is used for column headings page numbers and report dates.

A)Page
B)Column
C)Report
D)Group

Question 56

Use ____ when you want to copy a selected portion of a report.

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

Question 57

Use ____ when you want to filter report data before printing a report.

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

Question 58

A(n)____ field is a report sort field that includes a Group Header section before a group of records that has the same sort field value and that includes a Group Footer section after the group of records.

A)section
B)aggregate
C)grouping
D)consolidated

Question 59

Double-clicking a report name in the Navigation Pane opens the report in ____.

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

Question 60

In ____ you can view the live version of a report prior to printing it and apply filters to it.

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

Question 61

If your report has a(n)____ Footer section it precedes the Page Footer section on the last page of the report.

A)Access
B)Group
C)Report
D)Detail

Question 62

The item marked 2 in the accompanying figure is the ____ section.

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

Question 63

Use the ____ section to print selected fields from the table or query.

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

Question 64

The item marked 3 in the accompanying figure is the ____ section.

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

Question 65

If you want to make sure you draw a straight horizontal or vertical line press the ____ key before you start drawing the line.

A)Ctrl
B)Alt
C)Shift
D)Esc

Question 66

The ____ section is used for report totals.

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

Question 67

The ____ section is usually used to print totals for the group.

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

Question 68

A report can have up to ____ grouping levels.

A)3
B)5
C)6
D)10

Question 69

A listing of all contracts in a database would be an example of a(n)____ report.

A)summary
B)detail
C)grouping
D)executive

Question 70

The item marked 4 in the accompanying figure is the ____ section.

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

Question 71

The item marked 7 in the accompanying figure is the ____ section.

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

Question 72

Use the ____ section of a report to print calculated values.

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

Question 73

The item marked 6 in the accompanying figure is the ____ section.

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

Question 74

The ____ Footer section is used for page numbers and brief explanations of symbols or abbreviations.

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

Question 75

The item marked 5 in the accompanying figure is the ____ section.

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

Question 76

Total contracts by city would be an example of a ____ report.

A)summary
B)detail
C)grouping
D)chart

Question 77

A(n)____ control displays field values for each record in the record source.

A)unbound
B)bound
C)object
D)master

Question 78

In addition to being used for report totals the ____ section is also used for other summary information.

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

Question 79

A(n)____ layout is a control layout arranged in a datasheet format.

A)lateral
B)tabular
C)indexed
D)datasheet

Question 80

The item marked 1 in the accompanying figure is the ____ section.

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