Question 1

Form headers or report footers are examples of form or report ________.

Accepted Answer

A) subdivisions 
B) divisions 
C) segments 
D) sections 
A) subdivisions 
B) divisions 
C) segments 
D) sections D

Question 2

A locked form displays data but does not allow any changes to the data.

Accepted Answer

A) True 
 B)False  False

Question 3

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

Accepted Answer

A) True 
 B)False  True

Question 4

To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.

Accepted Answer

A) Changes dialog box 
B) Property Sheet 
C) Protection dialog box 
D) Attributes Sheet 
A) Changes dialog box 
B) Property Sheet 
C) Protection dialog box 
D) Attributes Sheet

Question 5

Advanced controls can be used in forms but not in reports.

Accepted Answer

A) True 
 B)False

Question 6

You can adjust the tab order to control the advancement from one field or control to the next.

Accepted Answer

A) True 
 B)False

Question 7

The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.

Accepted Answer

A) Closed when the ClosedDate field has no value and Open otherwise 
B) Open when the ClosedDate field has no value and Closed otherwise 
C) Closed when the ClosedDate field has no value and nothing otherwise 
D) Open when the ClosedDate field has no value and nothing otherwise 
A) Closed when the ClosedDate field has no value and Open otherwise 
B) Open when the ClosedDate field has no value and Closed otherwise 
C) Closed when the ClosedDate field has no value and nothing otherwise 
D) Open when the ClosedDate field has no value and nothing otherwise

Question 8

Sections can be used in reports but not in forms.

Accepted Answer

A) True 
 B)False

Question 9

By using a ________,you can create a form that displays records from two related tables.

Accepted Answer

A) linked form 
B) subordinate form 
C) subform 
D) mini-form 
A) linked form 
B) subordinate form 
C) subform 
D) mini-form

Question 10

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.

Accepted Answer

A) selection 
B) check 
C) list 
D) combo 
A) selection 
B) check 
C) list 
D) combo

Question 11

If you want users to view a form but not make any changes to its data,you would use a ________ form.

Accepted Answer

A) protected 
B) locked 
C) secure 
D) read-only 
A) protected 
B) locked 
C) secure 
D) read-only

Question 12

A text box can be converted into a combo box.

Accepted Answer

A) True 
 B)False

Exam 24: Advanced Forms and Reports: Hands On Exercise Videos

Form headers or report footers are examples of form or report ________.

A locked form displays data but does not allow any changes to the data.

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.

Advanced controls can be used in forms but not in reports.

You can adjust the tab order to control the advancement from one field or control to the next.

The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.

Sections can be used in reports but not in forms.

By using a ________,you can create a form that displays records from two related tables.

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.

If you want users to view a form but not make any changes to its data,you would use a ________ form.

A text box can be converted into a combo box.

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

Advanced Forms and Reports: Moving Beyond the Basics

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