Question 1

A(n)________ is text not tied to a specific field.

Accepted Answer

A)  label 
B)  text box 
C)  calculated control 
D)  control box 
A)  label 
B)  text box 
C)  calculated control 
D)  control box

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

What type of break is used to cause each group to print on a separate page?

Accepted Answer

A)  Page 
B)  Section 
C)  Footer 
D)  Report 
A)  Page 
B)  Section 
C)  Footer 
D)  Report

Question 4

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 5

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 6

What is a subform?

Accepted Answer

A subform is created using For

Question 7

After adding grouping,a ________ appears just above the Detail section in Design view,along with the name of the field by which you are grouping.

Accepted Answer

A)  Group header 
B)  Group footer 
C)  Page header 
D)  Form header 
A)  Group header 
B)  Group footer 
C)  Page header 
D)  Form header

Question 8

Unbound controls are controls that are tied to specific fields.

Accepted Answer

A) True 
 B)False

Question 9

What is the purpose of changing the tab order of a form?

Accepted Answer

Not all fields need a tab stop

Question 10

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 11

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 12

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

Accepted Answer

The form footer appears one ti

Question 13

When creating a subform,Access automatically names the subform for you or you can create your own name.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Which view do you use to modify lines or rectangles?

Accepted Answer

A)  Design view 
B)  Layout view 
C)  Datasheet view 
D)  Form or Report view 
A)  Design view 
B)  Layout view 
C)  Datasheet view 
D)  Form or Report view

Question 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

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

A(n)________ is text not tied to a specific field.

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

What type of break is used to cause each group to print on a separate page?

When are subforms created?

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

What is a subform?

After adding grouping,a ________ appears just above the Detail section in Design view,along with the name of the field by which you are grouping.

Unbound controls are controls that are tied to specific fields.

What is the purpose of changing the tab order of a form?

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

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

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

When creating a subform,Access automatically names the subform for you or you can create your own name.

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

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

A ________ describes the data associated with a text box.

Which view do you use to modify lines or rectangles?

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

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

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

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