Question 1

An explanatory note added to a form or report is considered a label because it is not tied to a specific field.

Accepted Answer

A) True 
 B)False

Question 2

When choosing fields from two different tables using the Form Wizard,Access automatically assumes you want a form with a subform.

Accepted Answer

A) True 
 B)False

Question 3

What appears below the Page Footer section in a report or form?

Accepted Answer

A) Form Footer or Report Footer 
B) Form Footer or Grouping Group 
C) Report Footer or Grouping Group 
D) Form footer or Detail section 
A) Form Footer or Report Footer 
B) Form Footer or Grouping Group 
C) Report Footer or Grouping Group 
D) Form footer or Detail section

Question 4

A(n)________ control provides a drop down menu with a list of options a user may choose from.

Accepted Answer

The answer of A(n)________ control provides a drop down menu...

Question 5

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

Accepted Answer

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

Question 6

Page breaks can be added at specific locations in forms or reports.

Accepted Answer

A) True 
 B)False

Question 7

How do you switch on or off sections of a report or form?

Accepted Answer

A) Right-click a blank area 
B) Go to the property sheet 
C) Hide the detail section 
D) Grey out a section 
A) Right-click a blank area 
B) Go to the property sheet 
C) Hide the detail section 
D) Grey out a section

Question 8

When a relationship exists between two tables,the Form wizard automatically includes a(n)________.

Accepted Answer

The answer of When a relationship exists between two tables,the...

Question 9

To remove a tab stop,click the Other tab in the Property sheet and change the Tab Stop setting to No.

Accepted Answer

A) True 
 B)False

Question 10

A(n)________ is a control in a form or report is not attached to any specific field in a table or query.

Accepted Answer

The answer of A(n)________ is a control in a form...

Question 11

What should be done before converting a text box to a combo box?

Accepted Answer

A) Create a new table and enter the values for the option list 
B) Set a default value to appear on the form 
C) Check the tab order of the form 
D) Switch to Form view and attempt to change the data in the first record 
A) Create a new table and enter the values for the option list 
B) Set a default value to appear on the form 
C) Check the tab order of the form 
D) Switch to Form view and attempt to change the data in the first record

Question 12

What is the difference between a form header and a page header?

Accepted Answer

The form footer appears one ti

Question 13

A form or report header appears one time at the top of each form or report.

Accepted Answer

A) True 
 B)False

Question 14

How can you add emphasis to a form or report?

Accepted Answer

Emphasis can be adde

Question 15

Where is the Page Header located?

Accepted Answer

A) Top of each page 
B) Top of form/report 
C) At the end of each group 
D) Bottom of each page 
A) Top of each page 
B) Top of form/report 
C) At the end of each group 
D) Bottom of each page

Question 16

The ________ is part of a form that can be manipulated separately from other parts of the form.

Accepted Answer

The answer of The ________ is part of a form...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

What must you do once a text box has been converted to a combo box?

Accepted Answer

A) Set a source for the combo box 
B) Set a default value 
C) Create a validation rule 
D) Create an input mask 
A) Set a source for the combo box 
B) Set a default value 
C) Create a validation rule 
D) Create an input mask

Question 19

Which of the following displays one time at the bottom of a report?

Accepted Answer

A) Report footer 
B) Report header 
C) Form footer 
D) Form header 
A) Report footer 
B) Report header 
C) Form footer 
D) Form header

Question 20

What is the reason for making a form read-only?

Accepted Answer

A) Users can lookup information but not modify the data 
B) Users can lookup and edit forms as needed 
C) Users can use the form instead of the table to edit data 
D) Users can add and delete data from the form 
A) Users can lookup information but not modify the data 
B) Users can lookup and edit forms as needed 
C) Users can use the form instead of the table to edit data 
D) Users can add and delete data from the form

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

An explanatory note added to a form or report is considered a label because it is not tied to a specific field.

When choosing fields from two different tables using the Form Wizard,Access automatically assumes you want a form with a subform.

What appears below the Page Footer section in a report or form?

A(n)________ control provides a drop down menu with a list of options a user may choose from.

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

Page breaks can be added at specific locations in forms or reports.

How do you switch on or off sections of a report or form?

When a relationship exists between two tables,the Form wizard automatically includes a(n)________.

To remove a tab stop,click the Other tab in the Property sheet and change the Tab Stop setting to No.

A(n)________ is a control in a form or report is not attached to any specific field in a table or query.

What should be done before converting a text box to a combo box?

What is the difference between a form header and a page header?

A form or report header appears one time at the top of each form or report.

How can you add emphasis to a form or report?

Where is the Page Header located?

The ________ is part of a form that can be manipulated separately from other parts of the form.

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

What must you do once a text box has been converted to a combo box?

Which of the following displays one time at the bottom of a report?

What is the reason for making a form read-only?

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