Question 1

The skill used to create a form can be used to create a report as well.

Accepted Answer

A) True 
 B)False  True

Question 2

When would a calculated field need to be added to a form or report?

Accepted Answer

A) When a formula is needed in the form or report 
B) When you want to add some explanatory text to the form or report 
C) When using an unbound control in the form or report 
D) When using a bound control in the form or report 
A) When a formula is needed in the form or report 
B) When you want to add some explanatory text to the form or report 
C) When using an unbound control in the form or report 
D) When using a bound control in the form or report A

Question 3

What type of break is used to cause each group to print on a separate page?

Accepted Answer

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

Question 4

In a form or report,a(n)________ is a control that is not tied to a specific field.

Accepted Answer

The answer of In a form or report,a(n)________ is a...

Question 5

Which of the following appears at the top of each form or report?

Accepted Answer

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

Question 6

Simple forms created with a Form tool will handle most basic database solution needs.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following controls can you use to add emphasis to your form or report?

Accepted Answer

A) Line control and rectangle control 
B) Line control and unbound control 
C) Rectangle control and calculated control 
D) Line control and bound control 
A) Line control and rectangle control 
B) Line control and unbound control 
C) Rectangle control and calculated control 
D) Line control and bound control

Question 8

After adding grouping,a ________ appears just above the Detail section in Design view,along with the name of the field by which you are grouping.

Accepted Answer

A) Group header 
B) Group footer 
C) Page header 
D) Form header 
A) Group header 
B) Group footer 
C) Page header 
D) Form header

Question 9

Which of the following displays when you insert a text box?

Accepted Answer

A) Label control 
B) Text box control 
C) Design view control 
D) Section control 
A) Label control 
B) Text box control 
C) Design view control 
D) Section control

Question 10

Which of the following is NOT used when laying out forms and reports?

Accepted Answer

A) Changing the Allow Edits property to No 
B) Controls not bound to specific fields 
C) Controls that change each time a new record is displayed 
D) Lines,pictures,and other non-data-related elements 
A) Changing the Allow Edits property to No 
B) Controls not bound to specific fields 
C) Controls that change each time a new record is displayed 
D) Lines,pictures,and other non-data-related elements

Question 11

What is the group footer used for?

Accepted Answer

A) Totaling the data at the end of each group 
B) Totaling the data at the end of each page 
C) Totaling the data at the end of each section 
D) Totaling the data at the end of the form 
A) Totaling the data at the end of each group 
B) Totaling the data at the end of each page 
C) Totaling the data at the end of each section 
D) Totaling the data at the end of the form

Question 12

When a form has been created as read-only,it should be renamed to indicate it is read-only.

Accepted Answer

A) True 
 B)False

Question 13

What is the purpose of changing the tab order of a form?

Accepted Answer

Not all fields need a tab stop

Question 14

Which of the following is NOT a correct way to Add a calculated control to a form or report?

Accepted Answer

A) Use the Expression Builder 
B) Create a formula in an unbound control 
C) Create a formula beginning with the equal sign (=)in a text box 
D) Create a formula in a bound control 
A) Use the Expression Builder 
B) Create a formula in an unbound control 
C) Create a formula beginning with the equal sign (=)in a text box 
D) Create a formula in a bound control

Question 15

A ________ is a form that enables users to view but not change data.

Accepted Answer

A) read-only form 
B) data entry form 
C) sub form 
D) split form 
A) read-only form 
B) data entry form 
C) sub form 
D) split form

Question 16

A(n)________ is text not tied to a specific field.

Accepted Answer

A) label 
B) text box 
C) calculated control 
D) control box 
A) label 
B) text box 
C) calculated control 
D) control box

Question 17

Which type of control does a lookup field become in a form?

Accepted Answer

A) Combo box control 
B) Bound control 
C) Calculated control 
D) Unbound control 
A) Combo box control 
B) Bound control 
C) Calculated control 
D) Unbound control

Question 18

Which view gives a designer a higher level of control when creating forms and/or reports?

Accepted Answer

A) Design view 
B) Layout view 
C) Datasheet view 
D) Form or Report view 
A) Design view 
B) Layout view 
C) Datasheet view 
D) Form or Report view

Question 19

After inserting a line into a form or report,you can modify the color,thickness and line type.

Accepted Answer

A) True 
 B)False

Question 20

What is the difference between a bound control and an unbound control?

Accepted Answer

A bound control is connected t

Exam 22: Advanced Forms and Reports: Moving Beyond the Basics

The skill used to create a form can be used to create a report as well.

When would a calculated field need to be added to a form or report?

What type of break is used to cause each group to print on a separate page?

In a form or report,a(n)________ is a control that is not tied to a specific field.

Which of the following appears at the top of each form or report?

Simple forms created with a Form tool will handle most basic database solution needs.

Which of the following controls can you use to add emphasis to your form or report?

After adding grouping,a ________ appears just above the Detail section in Design view,along with the name of the field by which you are grouping.

Which of the following displays when you insert a text box?

Which of the following is NOT used when laying out forms and reports?

What is the group footer used for?

When a form has been created as read-only,it should be renamed to indicate it is read-only.

What is the purpose of changing the tab order of a form?

Which of the following is NOT a correct way to Add a calculated control to a form or report?

A ________ is a form that enables users to view but not change data.

A(n)________ is text not tied to a specific field.

Which type of control does a lookup field become in a form?

Which view gives a designer a higher level of control when creating forms and/or reports?

After inserting a line into a form or report,you can modify the color,thickness and line type.

What is the difference between a bound control and an unbound control?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters