Question 1

In the accompanying figure, which numbered arrow indicates the Report view button.

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Case Based Critical Thinking Questions Case 7-1 Carlos is not familiar with creating Access reports and has asked his friend Nina to help him create some useful reports from his organic produce farm data.  The organic farm currently has three tables, as illustrated below.  Using the information provided, determine the best answers for the questions below.
 
Nina successfully added the required fields to the report.  Now she wants to sort the report alphabetically by the customer's last name.  To Add a Sort Field, Nina must first be in ____ view.

Accepted Answer

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

Question 4

It is best to wait until all objects of a database have been created before choosing a theme other than the default theme for a database.

Accepted Answer

A) True 
 B)False

Question 5

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.
Janise notices, after viewing the report in Report view, that the Special Requests field does not show all of the data she needs to view.  Which property should she change for the text box containing the Special Requests field information?

Accepted Answer

A)  Height 
B)  Width 
C)  Can Grow 
D)  Display When 
A)  Height 
B)  Width 
C)  Can Grow 
D)  Display When

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Reports may only be viewed in Print Preview.

Accepted Answer

A) True 
 B)False

Question 8

In the accompanying figure, which numbered arrow indicates a number formatted in the Standard format?

Accepted Answer

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

Question 9

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

Accepted Answer

The answer of Values in a selected column may be...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: A formatted output (screen display or printout) of the contents of one or more tables in a database.

Accepted Answer

The Answer of Zoom slider and Group Footer and summary is...

Question 12

Case Based Critical Thinking Questions Case 7-1 Carlos is not familiar with creating Access reports and has asked his friend Nina to help him create some useful reports from his organic produce farm data.  The organic farm currently has three tables, as illustrated below.  Using the information provided, determine the best answers for the questions below.
 
Nina does not see any fields available to add to the report after making the correct selection from the DESIGN tab on the Report Layout Tools Ribbon. What is most likely the problem?

Accepted Answer

A)  no table was selected before beginning the report 
B)  there are no tables in the database 
C)  the tables are not visible in the Field List pane of the report design window and must be made visible 
D)  there are no fields created for the table selected 
A)  no table was selected before beginning the report 
B)  there are no tables in the database 
C)  the tables are not visible in the Field List pane of the report design window and must be made visible 
D)  there are no fields created for the table selected

Question 13

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

Accepted Answer

The answer of To zoom in or out when viewing...

Question 14

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.
Some of Janise's clients have more than one pet.  The current version of the report shows the client's information for each pet the client has listed with Janise's pet sitting service.  Janise would like for the client information to appear only once on the report but still see each pet and the pet's information listed. The report is sorted on the Client's last name. Which property should Janise set to YES for the client information fields to obtain the results she wants?

Accepted Answer

A)  Hide Duplicate Values 
B)  Special Effect 
C)  Display When 
D)  Sort 
A)  Hide Duplicate Values 
B)  Special Effect 
C)  Display When 
D)  Sort

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

In the accompanying figure, this set of labels will be printed with _____________________ columns per page.

Accepted Answer

The answer of   
In the accompanying figure, this...

Question 18

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

Accepted Answer

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

Question 19

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.

Accepted Answer

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

Question 20

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.

Accepted Answer

The answer of When the Title button on the DESIGN...

In the accompanying figure, which numbered arrow indicates the Report view button.

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

It is best to wait until all objects of a database have been created before choosing a theme other than the default theme for a database.

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

Reports may only be viewed in Print Preview.

In the accompanying figure, which numbered arrow indicates a number formatted in the Standard format?

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

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

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

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

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

In the accompanying figure, this set of labels will be printed with _____________________ columns per page.

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

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.

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.

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 numbered arrow indicates the Report view button.

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

It is best to wait until all objects of a database have been created before choosing a theme other than the default theme for a database.

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

Reports may only be viewed in Print Preview.

In the accompanying figure, which numbered arrow indicates a number formatted in the Standard format?

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

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

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

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

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

In the accompanying figure, this set of labels will be printed with _____________________ columns per page.

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

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.

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.

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