Question 1

Sum,Min,Max,and Average are examples of which kind of functions?

Accepted Answer

A) Aggregate functions 
B) Constant functions 
C) Control functions 
D) Bound functions 
A) Aggregate functions 
B) Constant functions 
C) Control functions 
D) Bound functions

Question 2

Unbound controls do not require data entry so a tab stop can be removed.

Accepted Answer

A) True 
 B)False

Question 3

A ________ describes the data associated with a text box.

Accepted Answer

A) Label control 
B) Text control 
C) Design control 
D) Form control 
A) Label control 
B) Text control 
C) Design control 
D) Form control

Question 4

How do you hide details in a report?

Accepted Answer

A) Click Hide details in the Grouping & Totals group on the Design tab 
B) Close the detail section in Design view 
C) Click Hide details in the Header/Footer Options 
D) Click Hide details in Page Options 
A) Click Hide details in the Grouping & Totals group on the Design tab 
B) Close the detail section in Design view 
C) Click Hide details in the Header/Footer Options 
D) Click Hide details in Page Options

Question 5

Bound,unbound,and calculated controls are not found on the Controls group on the Design tab.

Accepted Answer

A) True 
 B)False

Question 6

To add emphasis to a form or report,use the Line control or the Rectangle control.

Accepted Answer

A) True 
 B)False

Question 7

A calculated control contains an expression that generates a calculated result.

Accepted Answer

A) True 
 B)False

Question 8

When are subforms created?

Accepted Answer

A) When the main form displays records from a related table 
B) When two fields are next to each other in a table 
C) When you have an autonumber field as the primary key 
D) It can only be created when the form is created 
A) When the main form displays records from a related table 
B) When two fields are next to each other in a table 
C) When you have an autonumber field as the primary key 
D) It can only be created when the form is created

Question 9

How would you add grouping to a report?

Accepted Answer

A) Group & Sort button 
B) Form footer 
C) Page footer 
D) Form header 
A) Group & Sort button 
B) Form footer 
C) Page footer 
D) Form header

Question 10

On a form,what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Accepted Answer

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

Question 11

Where is a Group Header located?

Accepted Answer

A) At the start of each new group 
B) Top of the form/report 
C) Middle of form/report 
D) At the end of each group 
A) At the start of each new group 
B) Top of the form/report 
C) Middle of form/report 
D) At the end of each group

Question 12

Which of the following controls contains to decorative elements,such as the title of the report?

Accepted Answer

A) Unbound 
B) Bound 
C) Calculated 
D) Rectangle and line 
A) Unbound 
B) Bound 
C) Calculated 
D) Rectangle and line

Question 13

How often does a Form/Report Header appear?

Accepted Answer

A) Once 
B) Once per page 
C) At the start of each group 
D) Once per record in the record source 
A) Once 
B) Once per page 
C) At the start of each group 
D) Once per record in the record source

Question 14

What are group headers and footers used for?

Accepted Answer

The group header appears once each time

Question 15

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

Accepted Answer

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

Question 16

Which of the following is an alternative to a combo box?

Accepted Answer

A) Add a data validation rule 
B) Key in the field 
C) Set a tab order 
D) Make it a required field 
A) Add a data validation rule 
B) Key in the field 
C) Set a tab order 
D) Make it a required field

Question 17

The detail section of a form or report displays in between the headers and footers sections.

Accepted Answer

A) True 
 B)False

Question 18

The three views in Access are Form or Report view,Layout view,and Design view.

Accepted Answer

A) True 
 B)False

Question 19

Changes to a subform are easier to make in Layout view.

Accepted Answer

A) True 
 B)False

Question 20

A(n)________ is a control that is connected to a field in a table or query.

Accepted Answer

A) bound control 
B) unbound control 
C) calculated control 
D) combo box control 
A) bound control 
B) unbound control 
C) calculated control 
D) combo box control

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

Sum,Min,Max,and Average are examples of which kind of functions?

Unbound controls do not require data entry so a tab stop can be removed.

A ________ describes the data associated with a text box.

How do you hide details in a report?

Bound,unbound,and calculated controls are not found on the Controls group on the Design tab.

To add emphasis to a form or report,use the Line control or the Rectangle control.

A calculated control contains an expression that generates a calculated result.

When are subforms created?

How would you add grouping to a report?

On a form,what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Where is a Group Header located?

Which of the following controls contains to decorative elements,such as the title of the report?

How often does a Form/Report Header appear?

What are group headers and footers used for?

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

Which of the following is an alternative to a combo box?

The detail section of a form or report displays in between the headers and footers sections.

The three views in Access are Form or Report view,Layout view,and Design view.

Changes to a subform are easier to make in Layout view.

A(n)________ is a control that is connected to a field in a table or query.

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