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

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 3

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 4

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 5

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 6

Reports may only be viewed in Print Preview.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Question 9

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 10

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 11

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

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 14

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 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

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

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 20

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

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

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

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.

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

Reports may only be viewed in Print Preview.

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

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

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

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

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.

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

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.

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

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.

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

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

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

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

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

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 3: Access: Creating Custom Reports

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

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

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.

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

Reports may only be viewed in Print Preview.

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

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

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

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

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.

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

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.

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

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.

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

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

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

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

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

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters