Question 1

Match between columns
                        Premises: The section of a report that usually displays subtotals or counts for records in a group.

Accepted Answer

The Answer of Group Header and report and Zoom slider is...

Question 2

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

Accepted Answer

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

Question 3

The default theme for Access database objects uses the ____________________ font.

Accepted Answer

Calibri

Question 4

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

Accepted Answer

The answer of The expression =Date(), inserted in a text...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of Properties of a multiple-column report may be...

Question 7

Match between columns
                        Premises: A section that appears by itself at the bottom of a page.

Accepted Answer

The Answer of orphaned footer section and detail report and is...

Question 8

Match between columns
                        Premises: A field used to group the detail items in a report.

Accepted Answer

The Answer of orphaned header section and Zoom slider and is...

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

The answer of A ____________________ report prints the same collection...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Case Based Critical Thinking Questions Case 7- 2
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.

Accepted Answer

A)  Page Number button 
B)  Footer dialog box 
C)  Report Footer button 
D)  Page Numbers dialog box 
A)  Page Number button 
B)  Footer dialog box 
C)  Report Footer button 
D)  Page Numbers dialog box

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

In the accompanying figure, how will the page number for the first page display on the report based on the Format chosen?

Accepted Answer

A)  Page 1 of  3 
B)  1 
C)  Page 1 
D)  Page 1 of 3 Pages 
A)  Page 1 of  3 
B)  1 
C)  Page 1 
D)  Page 1 of 3 Pages

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  5 
A)  1 
B)  2 
C)  3 
D)  5

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

The default theme for Access database objects uses the ____________________ font.

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

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

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

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

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

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

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

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

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

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

In the accompanying figure, how will the page number for the first page display on the report based on the Format chosen?

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

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

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 8: Creating Custom Reports

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

The default theme for Access database objects uses the ____________________ font.

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

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

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

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

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

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

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

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

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

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

In the accompanying figure, how will the page number for the first page display on the report based on the Format chosen?

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

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

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters