Question 1

In the accompanying figure, ____________________ is the chosen manufacturer for this set of labels.

Accepted Answer

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

Question 2

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.

Accepted Answer

The answer of The ____________________ section in Design view appears...

Question 3

Match between columns
                        Premises: The type of report that displays summary information, such as grand totals and/or subtotals, using fields from a record source.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of The ____________________ option from the Size/Space button...

Question 6

In the accompanying figure, which numbered arrow indicates the Layout view button?

Accepted Answer

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

Question 7

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.

Accepted Answer

The answer of A sort field must also be designated...

Question 8

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 has completed the report Carlos requested, but she notices that the columns of the report are not spaced equally. Nina can fix this problem quickly by selecting the entire report in Design view and choosing the Equal Horizontal option from the Size/Space button on the ____ tab.

Accepted Answer

A)  DESIGN 
B)  PAGE SETUP 
C)  FORMAT 
D)  ARRANGE 
A)  DESIGN 
B)  PAGE SETUP 
C)  FORMAT 
D)  ARRANGE

Question 9

Which of the following is an advantage of using a query as a record source for a report?

Accepted Answer

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

Which option will allow you to increase the height of the Page Header using the mouse?

Accepted Answer

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

Options for modifying a report's grouping fields, sorting fields, and report calculations for the groups are available using the ____.

Accepted Answer

A)  Navigation pane 
B)  Group and Sort tab 
C)  Group, Sort, and Total pane 
D)  Group, Sort, and Total Wizard 
A)  Navigation pane 
B)  Group and Sort tab 
C)  Group, Sort, and Total pane 
D)  Group, Sort, and Total Wizard

Question 12

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.

Accepted Answer

A)  Format 
B)  Print 
C)  Arrange 
D)  Page Setup 
A)  Format 
B)  Print 
C)  Arrange 
D)  Page Setup

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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.
 
Carlos has asked Nina to create a report that will list all of his customers by last name with their email addresses.  To begin creating the custom report after opening the database, Nina will choose the ____ from the CREATE tab on the Ribbon.

Accepted Answer

A)  Report Design 
B)  Blank Report 
C)  Report 
D)  Report Wizard 
A)  Report Design 
B)  Blank Report 
C)  Report 
D)  Report Wizard

Question 15

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report. ____________________

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: The type of report that displays detailed information by displaying fields from the record source in the Detail section of the report.

Accepted Answer

The Answer of report and summary report and Group Header is...

Question 17

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

Accepted Answer

A)  visible 
B)  sorted 
C)  similar 
D)  formatted 
A)  visible 
B)  sorted 
C)  similar 
D)  formatted

Question 18

Which control format property adds comma separators and two decimal places in report Design view.

Accepted Answer

A)  Standard 
B)  Currency 
C)  Fixed 
D)  General Number 
A)  Standard 
B)  Currency 
C)  Fixed 
D)  General Number

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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.

Accepted Answer

A)  Solid 
B)  Transparent 
C)  None 
D)  All 
A)  Solid 
B)  Transparent 
C)  None 
D)  All

In the accompanying figure, ____________________ is the chosen manufacturer for this set of labels.

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.

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

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

In the accompanying figure, which numbered arrow indicates the Layout view button?

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.

Which of the following is an advantage of using a query as a record source for a report?

Which option will allow you to increase the height of the Page Header using the mouse?

Options for modifying a report's grouping fields, sorting fields, and report calculations for the groups are available using the ____.

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.

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

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report. ____________________

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

Which control format property adds comma separators and two decimal places in report Design view.

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

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.

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, ____________________ is the chosen manufacturer for this set of labels.

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.

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

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

In the accompanying figure, which numbered arrow indicates the Layout view button?

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.

Which of the following is an advantage of using a query as a record source for a report?

Which option will allow you to increase the height of the Page Header using the mouse?

Options for modifying a report's grouping fields, sorting fields, and report calculations for the groups are available using the ____.

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.

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

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report. ____________________

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

Which control format property adds comma separators and two decimal places in report Design view.

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

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.

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