Question 1

Common properties for multiple controls may be set by performing which of the following tasks?

Accepted Answer

A)  select each control separately and change the properties 
B)  select adjacent controls only using the Ctrl key and the mouse; then change the properties for adjacent controls one at a time 
C)  select adjacent and nonadjacent controls using the Ctrl key and the mouse; then change the properties for all controls at once 
D)  change the properties to apply to all controls then select the controls by clicking on the controls with the mouse 
A)  select each control separately and change the properties 
B)  select adjacent controls only using the Ctrl key and the mouse; then change the properties for adjacent controls one at a time 
C)  select adjacent and nonadjacent controls using the Ctrl key and the mouse; then change the properties for all controls at once 
D)  change the properties to apply to all controls then select the controls by clicking on the controls with the mouse

Question 2

The Keep Together property, which determines how group data will be printed, is set using the  ____________________.

Accepted Answer

The answer of The Keep Together property, which determines how...

Question 3

Match between columns
                        Premises: The control on the status bar used in report view to zoom in or out in 10% increments.

Accepted Answer

The Answer of Zoom control and Group Footer and detail is...

Question 4

Match between columns
                        Premises: The section of a report that usually displays the group name and the sort field value for the group.

Accepted Answer

The Answer of detail report and Zoom control and report is...

Question 5

Layout view must be used to select all controls in a report and to remove an individual control from the selection. ____________________

Accepted Answer

A) True 
 B)False

Question 6

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

Accepted Answer

A)  padding 
B)  keep whole group together on one page 
C)  keep header and first record together on one page 
D)  do not keep group together on one page 
A)  padding 
B)  keep whole group together on one page 
C)  keep header and first record together on one page 
D)  do not keep group together on one page

Question 7

What is the maximum number of sort fields that can be included in a report?

Accepted Answer

A)  5 
B)  10 
C)  12 
D)  unlimited 
A)  5 
B)  10 
C)  12 
D)  unlimited

Question 8

In the accompanying figure, which section of the report has a Height property set to zero?

Accepted Answer

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

Question 9

Yes/no and true/false fields are represented with check boxes in a report.

Accepted Answer

A) True 
 B)False

Question 10

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

Accepted Answer

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

Question 11

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.
 
Next, Nina needs to add the fields FirstName, LastName, and EmailAddress to the report.  She must select ____ from the DESIGN tab while in the Report Layout Tools section of the Ribbon.

Accepted Answer

A)  Property Sheet 
B)  Themes 
C)  Add Existing Fields 
D)  Controls 
A)  Property Sheet 
B)  Themes 
C)  Add Existing Fields 
D)  Controls

Question 12

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

Accepted Answer

A)  Font style 
B)  Font size 
C)  Font color 
D)  Font weight 
A)  Font style 
B)  Font size 
C)  Font color 
D)  Font weight

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.
To further personalize her pet sitting service, Janise has decided to mail each client a postcard with a 10% discount for the month of each pet's birthday. She will be creating mailing labels from her Clients table. Janise will set the formatting for the mailing labels in the ____ of the Label Wizard.

Accepted Answer

A)  Available fields box 
B)  Number across box 
C)  Prototype label box 
D)  Label type box 
A)  Available fields box 
B)  Number across box 
C)  Prototype label box 
D)  Label type box

Question 14

Describe five common enhancements and corrections that may be needed when modifying a report.

Accepted Answer

Students may choose any 5 of the 7. 
1.

Question 15

In the accompanying figure, if the Format is changed to Page N of M, how will the page number be displayed for a 3 page report?

Accepted Answer

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

Question 16

A typical Group Footer section will include which type of data?

Accepted Answer

A)  a count or subtotal for records in that group 
B)  the date and time the report was generated 
C)  the report page number 
D)  detail fields for all records included in the group 
A)  a count or subtotal for records in that group 
B)  the date and time the report was generated 
C)  the report page number 
D)  detail fields for all records included in the group

Question 17

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

Accepted Answer

A)  Wizard 
B)  custom 
C)  grid 
D)  auto 
A)  Wizard 
B)  custom 
C)  grid 
D)  auto

Question 18

A filter may be applied to data when a report is viewed using the Layout view . ____________________

Accepted Answer

A) True 
 B)False

Question 19

The combination of the keys ____________________on the keyboard will select all items in a report when viewing a report in Report view.

Accepted Answer

The answer of The combination of the keys ____________________on the...

Question 20

Selected portions of a report may be copied to the Clipboard and pasted into a Word document when viewing a report in Report view.

Accepted Answer

A) True 
 B)False

Common properties for multiple controls may be set by performing which of the following tasks?

The Keep Together property, which determines how group data will be printed, is set using the ____________________.

Layout view must be used to select all controls in a report and to remove an individual control from the selection. ____________________

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

What is the maximum number of sort fields that can be included in a report?

In the accompanying figure, which section of the report has a Height property set to zero?

Yes/no and true/false fields are represented with check boxes in a report.

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

Describe five common enhancements and corrections that may be needed when modifying a report.

In the accompanying figure, if the Format is changed to Page N of M, how will the page number be displayed for a 3 page report?

A typical Group Footer section will include which type of data?

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

A filter may be applied to data when a report is viewed using the Layout view . ____________________

The combination of the keys ____________________on the keyboard will select all items in a report when viewing a report in Report view.

Selected portions of a report may be copied to the Clipboard and pasted into a Word document when viewing a report in Report view.

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

Common properties for multiple controls may be set by performing which of the following tasks?

The Keep Together property, which determines how group data will be printed, is set using the ____________________.

Layout view must be used to select all controls in a report and to remove an individual control from the selection. ____________________

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

What is the maximum number of sort fields that can be included in a report?

In the accompanying figure, which section of the report has a Height property set to zero?

Yes/no and true/false fields are represented with check boxes in a report.

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

Describe five common enhancements and corrections that may be needed when modifying a report.

In the accompanying figure, if the Format is changed to Page N of M, how will the page number be displayed for a 3 page report?

A typical Group Footer section will include which type of data?

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

A filter may be applied to data when a report is viewed using the Layout view . ____________________

The combination of the keys ____________________on the keyboard will select all items in a report when viewing a report in Report view.

Selected portions of a report may be copied to the Clipboard and pasted into a Word document when viewing a report in Report view.

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