Question 1

To add a subreport to a report, use the Text Box tool on the Design tab.

Accepted Answer

A) True 
 B)False

Question 2

To display the Expression Builder dialog box and enter an expression in a text box, click the Build button in the ____________________ property box on the property sheet.

Accepted Answer

The answer of To display the Expression Builder dialog box...

Question 3

Match between columns
                        Premises: Tab on Ribbon that contains buttons to allow you to align data.

Accepted Answer

The Answer of text box and error indicator and Arrange is...

Question 4

Modified Multiple Choice You can create a report using _____.

Accepted Answer

A)  Design view 
B)  Report view 
C)  Report Wizard 
D)  Layout view 
A)  Design view 
B)  Report view 
C)  Report Wizard 
D)  Layout view

Question 5

Critical Thinking Questions Case 6-1 An employee at Camashaly Design needs to make some changes to the report shown in the accompanying figure. 
   
 The total amount should display as currency with two decimal places. How can the employee make this change?

Accepted Answer

To display total amount as currency, cli

Question 6

Match between columns
                        Premises: A control that is initially unbound and has an attached label.

Accepted Answer

The Answer of error indicator and binding and Database Tools is...

Question 7

To create a new query, click the Query Design button on the Create tab.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Used to maintain a connection between a worksheet and an Access table.

Accepted Answer

The Answer of Database Tools and binding and text box is...

Question 9

To cause each new group section to begin at the top of a page, change the value of the _____ property.

Accepted Answer

A)  Top of Page 
B)  Force New Page 
C)  Begin New Page 
D)  Start New Page 
A)  Top of Page 
B)  Force New Page 
C)  Begin New Page 
D)  Start New Page

Question 10

The contents of the Group Header section are printed before the records in a particular group.

Accepted Answer

A) True 
 B)False

Question 11

When you use the Title button to add a title to a report, the title is the same as the name of the report object.

Accepted Answer

A) True 
 B)False

Question 12

In the accompanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, click the _____ button to display the property sheet.

Accepted Answer

A)  Properties 
B)  Field Properties 
C)  Query Properties 
D)  Property Sheet 
A)  Properties 
B)  Field Properties 
C)  Query Properties 
D)  Property Sheet

Question 13

A report contains three types of controls: bound controls, unbound controls, and formatted controls.

Accepted Answer

A) True 
 B)False

Question 14

To add fields to a report, click the _____ button on the Design tab to add a field list.

Accepted Answer

A)  Field List 
B)  Report Fields 
C)  Add Existing Fields 
D)  Show Tables/Queries 
A)  Field List 
B)  Report Fields 
C)  Add Existing Fields 
D)  Show Tables/Queries

Question 15

The SubReport Wizard displays in the accompanying figure. To open a subreport in Design view, right-click the subreport in the Navigation Pane and click _____ on the shortcut menu.

Accepted Answer

A)  SubReport View 
B)  Design View 
C)  Modify SubReport 
D)  SubReport Design 
A)  SubReport View 
B)  Design View 
C)  Modify SubReport 
D)  SubReport Design

Question 16

When working on a report in Design view, you can make changes to the alignment of the controls in your report by using the Align tab.

Accepted Answer

A) True 
 B)False

Question 17

The contents of the _____ section are printed after the records in a particular group.

Accepted Answer

A)  After Group 
B)  After Section 
C)  Subtotal Footer 
D)  Group Footer 
A)  After Group 
B)  After Section 
C)  Subtotal Footer 
D)  Group Footer

Question 18

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

Accepted Answer

A)  Page Numbers 
B)  Title 
C)  Tools 
D)  Date and Time 
A)  Page Numbers 
B)  Title 
C)  Tools 
D)  Date and Time

Question 19

Modified Multiple Choice The aggregate functions available in Access are _____.

Accepted Answer

A)  COUNT 
B)  SUM 
C)  TOTAL 
D)  AVG 
A)  COUNT 
B)  SUM 
C)  TOTAL 
D)  AVG

Question 20

To remove the field list when working on a report in Design view, click the _____ button on the Design tab.

Accepted Answer

A)  Add Existing Fields 
B)  Remove Fields 
C)  Show Fields 
D)  Show Tables/Queries 
A)  Add Existing Fields 
B)  Remove Fields 
C)  Show Fields 
D)  Show Tables/Queries

To add a subreport to a report, use the Text Box tool on the Design tab.

To display the Expression Builder dialog box and enter an expression in a text box, click the Build button in the ____________________ property box on the property sheet.

Modified Multiple Choice You can create a report using _____.

Critical Thinking Questions Case 6-1 An employee at Camashaly Design needs to make some changes to the report shown in the accompanying figure. The total amount should display as currency with two decimal places. How can the employee make this change?

To create a new query, click the Query Design button on the Create tab.

To cause each new group section to begin at the top of a page, change the value of the _____ property.

The contents of the Group Header section are printed before the records in a particular group.

When you use the Title button to add a title to a report, the title is the same as the name of the report object.

In the accompanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, click the _____ button to display the property sheet.

A report contains three types of controls: bound controls, unbound controls, and formatted controls.

To add fields to a report, click the _____ button on the Design tab to add a field list.

The SubReport Wizard displays in the accompanying figure. To open a subreport in Design view, right-click the subreport in the Navigation Pane and click _____ on the shortcut menu.

When working on a report in Design view, you can make changes to the alignment of the controls in your report by using the Align tab.

The contents of the _____ section are printed after the records in a particular group.

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

Modified Multiple Choice The aggregate functions available in Access are _____.

To remove the field list when working on a report in Design view, click the _____ button on the Design tab.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters

Exam 7: Advanced Report Techniques

To add a subreport to a report, use the Text Box tool on the Design tab.

To display the Expression Builder dialog box and enter an expression in a text box, click the Build button in the ____________________ property box on the property sheet.

Modified Multiple Choice You can create a report using _____.

Critical Thinking Questions Case 6-1 An employee at Camashaly Design needs to make some changes to the report shown in the accompanying figure. The total amount should display as currency with two decimal places. How can the employee make this change?

To create a new query, click the Query Design button on the Create tab.

To cause each new group section to begin at the top of a page, change the value of the _____ property.

The contents of the Group Header section are printed before the records in a particular group.

When you use the Title button to add a title to a report, the title is the same as the name of the report object.

In the accompanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, click the _____ button to display the property sheet.

A report contains three types of controls: bound controls, unbound controls, and formatted controls.

To add fields to a report, click the _____ button on the Design tab to add a field list.

The SubReport Wizard displays in the accompanying figure. To open a subreport in Design view, right-click the subreport in the Navigation Pane and click _____ on the shortcut menu.

When working on a report in Design view, you can make changes to the alignment of the controls in your report by using the Align tab.

The contents of the _____ section are printed after the records in a particular group.

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

Modified Multiple Choice The aggregate functions available in Access are _____.

To remove the field list when working on a report in Design view, click the _____ button on the Design tab.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters