Question 1

In the accompanying figure, which report section contains the data for the column "Affiliation?"

Accepted Answer

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

Question 2

Match between columns
                        Premises: A section that appears by itself at the top of a page and the detail lines for the section appear on the previous page.

Accepted Answer

The Answer of report and summary report and group band is...

Question 3

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

Accepted Answer

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

Question 4

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.

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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.

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

List 3 reasons to create a custom report.

Accepted Answer

1. The Report tool or Report Wizard will

Question 10

In the accompanying figure, which view is being used to view the report?

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

In the accompanying figure, which numbered arrow indicates the right margin guide.

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

In the accompanying figure, the page number control is set to display the page number in which manner?

Accepted Answer

A)  left aligned 
B)  right aligned 
C)  center aligned 
D)  outside alignment 
A)  left aligned 
B)  right aligned 
C)  center aligned 
D)  outside alignment

Question 15

Match between columns
                        Premises: The control used to zoom in or out at variable increments in report view.

Accepted Answer

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

Question 16

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

Accepted Answer

1. Determine the purpose of the report a

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

The answer of Use the ____________________ to quickly create labels...

In the accompanying figure, which report section contains the data for the column "Affiliation?"

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

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.

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

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.

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

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

List 3 reasons to create a custom report.

In the accompanying figure, which view is being used to view the report?

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

In the accompanying figure, which numbered arrow indicates the right margin guide.

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

In the accompanying figure, the page number control is set to display the page number in which manner?

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

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

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

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

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

In the accompanying figure, which report section contains the data for the column "Affiliation?"

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

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.

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

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.

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

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

List 3 reasons to create a custom report.

In the accompanying figure, which view is being used to view the report?

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

In the accompanying figure, which numbered arrow indicates the right margin guide.

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

In the accompanying figure, the page number control is set to display the page number in which manner?

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

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

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

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

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