Question 1

The Tab order of a form cannot be changed.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Match between columns
                        Premises: subform
combo box control
detail section
section
section bar

Accepted Answer

The Answer of marks the top boundary of a section is...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

To change the order in which a user would enter data into a form,you would change the ________.

Accepted Answer

The answer of To change the order in which a...

Question 9

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 10

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 11

What are group headers and footers used for?

Accepted Answer

The group header appears once each time

Question 12

The ________ appears after adding a grouping to a form or report.

Accepted Answer

A)  Group Header 
B)  Group Footer 
C)  Page Header 
D)  Page Footer 
A)  Group Header 
B)  Group Footer 
C)  Page Header 
D)  Page Footer

Question 13

If you would like to include a mathematical equation in a report,you would include a(n)________.

Accepted Answer

The answer of If you would like to include a...

Question 14

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

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 17

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 18

Which sections display on forms and reports by default?

Accepted Answer

A)  Detail and form/report header and footer 
B)  Detail and form/report page header and footer 
C)  Form/report page header and footer 
D)  Form/report header and footer 
A)  Detail and form/report header and footer 
B)  Detail and form/report page header and footer 
C)  Form/report page header and footer 
D)  Form/report header and footer

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

The Tab order of a form cannot be changed.

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

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

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

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 three views in Access are Form or Report view,Layout view,and Design view.

To change the order in which a user would enter data into a form,you would change the ________.

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

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

What are group headers and footers used for?

The ________ appears after adding a grouping to a form or report.

If you would like to include a mathematical equation in a report,you would include a(n)________.

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

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

How often does a Form/Report Header appear?

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

Which sections display on forms and reports by default?

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

Where is the Page Header located?

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Action and Specialized Queries: Moving Beyond the Select Query

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters