Question 1

Which of the following generally refers to decorative elements such as the title of a report?

Accepted Answer

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

Question 2

What is a subform?

Accepted Answer

A subform is created using For

Question 3

A page footer appears at the bottom of the last page of a form or report.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: read-only form
calculated control
bound control
tab order
unbound control

Accepted Answer

The Answer of a control that is connected to a is...

Question 5

To move a text box label,what action must you take?

Accepted Answer

A) Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected. 
B) Click the Tabular Layout in the Arrange group when the label is selected. 
C) Click the Tabular Layout in the Arrange group when the text box is selected. 
D) Click the Tabular Layout in the Arrange group of the Table group while the label and text box are selected. 
A) Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected. 
B) Click the Tabular Layout in the Arrange group when the label is selected. 
C) Click the Tabular Layout in the Arrange group when the text box is selected. 
D) Click the Tabular Layout in the Arrange group of the Table group while the label and text box are selected.

Question 6

The ________ section in a report repeats for each record in a record source.

Accepted Answer

The answer of The ________ section in a report repeats...

Question 7

If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.

Accepted Answer

The answer of If you would like to see subtotals...

Question 8

Both forms and reports have a text box control,which displays the data found in the record source.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following marks the top boundary of a section in a form or report?

Accepted Answer

A) Section bar 
B) Tab bar 
C) Bound control 
D) Unbound control 
A) Section bar 
B) Tab bar 
C) Bound control 
D) Unbound control

Question 10

In which section of a form or report is a company logo usually added?

Accepted Answer

Generally in the Form Header o

Question 11

Tab order cannot be changed in a form once it has been created.

Accepted Answer

A) True 
 B)False

Question 12

Subforms have to be created using the Form Wizard.

Accepted Answer

A) True 
 B)False

Question 13

Forms and reports based on a query can display calculated fields like any other field.

Accepted Answer

A) True 
 B)False

Question 14

Unbound controls are controls that are tied to specific fields.

Accepted Answer

A) True 
 B)False

Question 15

If you create a form based on a table with a lookup field,the lookup field becomes a combo box control on the new form.

Accepted Answer

A) True 
 B)False

Question 16

The ________ is the sequential advancing in a form from one field to the next.

Accepted Answer

A) tab order 
B) bound control 
C) unbound control 
D) calculated control 
A) tab order 
B) bound control 
C) unbound control 
D) calculated control

Question 17

Which of the following appears once at the bottom of each page in a form or report?

Accepted Answer

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

Question 18

If no caption has been set for a field,the label will default to the field name.

Accepted Answer

A) True 
 B)False

Question 19

When creating a form or report,you can insert an image file containing the company logo.

Accepted Answer

A) True 
 B)False

Question 20

A read-only form is a form that enables users to view but not change data.

Accepted Answer

A) True 
 B)False

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

Which of the following generally refers to decorative elements such as the title of a report?

What is a subform?

A page footer appears at the bottom of the last page of a form or report.

To move a text box label,what action must you take?

The ________ section in a report repeats for each record in a record source.

If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.

Both forms and reports have a text box control,which displays the data found in the record source.

Which of the following marks the top boundary of a section in a form or report?

In which section of a form or report is a company logo usually added?

Tab order cannot be changed in a form once it has been created.

Subforms have to be created using the Form Wizard.

Forms and reports based on a query can display calculated fields like any other field.

Unbound controls are controls that are tied to specific fields.

If you create a form based on a table with a lookup field,the lookup field becomes a combo box control on the new form.

The ________ is the sequential advancing in a form from one field to the next.

Which of the following appears once at the bottom of each page in a form or report?

If no caption has been set for a field,the label will default to the field name.

When creating a form or report,you can insert an image file containing the company logo.

A read-only form is a form that enables users to view but not change data.

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