Question 1

Which type of control does a lookup field become in a form?

Accepted Answer

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

Question 2

Match the following terms with their meanings:
I. combo box control
II. subform
III. detail section
IV. section bar
V. section
A. part of a form or report that can be manipulated separately from other parts of the form or report
B. displays the records in the record source
C. provides a drop-down menu displaying a list of options from which the user can chose a single value
D. displays records that are related to records in a main form
E. marks the top boundary of a section in a form or report

Accepted Answer

The answer of Match the following terms with their meanings:
I....

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 text box can be converted into a combo box.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

How can you add emphasis to a form or report?

Accepted Answer

Emphasis can be adde

Question 8

After inserting a line into a form or report, you can modify the color, thickness and line type.

Accepted Answer

A) True 
 B)False

Question 9

Simple forms created with a Form tool will handle most basic database solution needs.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

What is a subform?

Accepted Answer

A subform is created using For

Question 12

List the five default sections of a report.

Accepted Answer

Report Header section, Page He

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

What are two options for adding emphasis to your form or report?

Accepted Answer

A)  Line or rectangle control 
B)  Rectangle or calculated control 
C)  Unbound or rectangle control 
D)  Bound or unbound control 
A)  Line or rectangle control 
B)  Rectangle or calculated control 
C)  Unbound or rectangle control 
D)  Bound or unbound control

Question 16

When a form has been created as read-only, it should be renamed to indicate it is read-only.

Accepted Answer

A) True 
 B)False

Question 17

Match the following terms with their meanings:
I. calculated control
II. tab order
III. bound control
IV. read-only form
V. unbound control
A. the sequential advancing in a form from one field or control to the next
B. a control not tied to a specific field
C. a control containing an expression that generates a calculated result
D. a control that is connected to a field in a table or query
E. a form that enables users to view but not change data

Accepted Answer

The answer of Match the following terms with their meanings:
I....

Question 18

If no caption has been set for a field, the label will default to the field name.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: calculated control
tab order
bound control
read-only form
unbound control

Accepted Answer

The Answer of the sequential advancing in a form from is...

Question 20

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

Which type of control does a lookup field become in a form?

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

A text box can be converted into a combo box.

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.

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

How can you add emphasis to a form or report?

After inserting a line into a form or report, you can modify the color, thickness and line type.

Simple forms created with a Form tool will handle most basic database solution needs.

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

What is a subform?

List the five default sections of a report.

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

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

What are two options for adding emphasis to your form or report?

When a form has been created as read-only, it should be renamed to indicate it is read-only.

If no caption has been set for a field, the label will default to the field name.

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

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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

Which type of control does a lookup field become in a form?

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

A text box can be converted into a combo box.

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.

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

How can you add emphasis to a form or report?

After inserting a line into a form or report, you can modify the color, thickness and line type.

Simple forms created with a Form tool will handle most basic database solution needs.

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

What is a subform?

List the five default sections of a report.

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

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

What are two options for adding emphasis to your form or report?

When a form has been created as read-only, it should be renamed to indicate it is read-only.

If no caption has been set for a field, the label will default to the field name.

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

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters