Question 1

Unbound controls are controls that are tied to specific fields.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

What are group headers and footers used for?

Accepted Answer

The group header appears once each time

Question 4

Subforms have to be created using the Form Wizard.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Which view gives a designer a higher level of control when creating forms and/or reports?

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 7

A(n) ________ in a form or report is connected to a specific field in a table or query.

Accepted Answer

The answer of A(n) ________ in a form or report...

Question 8

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

Accepted Answer

Not all fields need a tab stop

Question 9

A read-only form is a form that enables users to view but not change data.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Question 12

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

Accepted Answer

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

Question 13

Which of the following controls can you use to add emphasis to your form or report?

Accepted Answer

A)  Line control and rectangle control 
B)  Line control and unbound control 
C)  Rectangle control and calculated control 
D)  Line control and bound control 
A)  Line control and rectangle control 
B)  Line control and unbound control 
C)  Rectangle control and calculated control 
D)  Line control and bound control

Question 14

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

Question 15

Which two views make it easy to edit the design of a form?

Accepted Answer

A)  Layout view and Design view 
B)  Design view and Datasheet view 
C)  Datasheet view and Design view 
D)  Form view and Layout view 
A)  Layout view and Design view 
B)  Design view and Datasheet view 
C)  Datasheet view and Design view 
D)  Form view and Layout view

Question 16

The ________ section in a report repeats for each record in a record source.

Accepted Answer

The answer of The ________ section in a report repeats...

Question 17

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 18

Both forms and reports have a text box control, which displays the data found in the record source.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Unbound controls are controls that are tied to specific fields.

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

What are group headers and footers used for?

Subforms have to be created using the Form Wizard.

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

Which view gives a designer a higher level of control when creating forms and/or reports?

A(n) ________ in a form or report is connected to a specific field in a table or query.

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

A read-only form is a form that enables users to view but not change data.

When are subforms created?

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

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

Which of the following controls can you use to add emphasis to your form or report?

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

Which two views make it easy to edit the design of a form?

The ________ section in a report repeats for each record in a record source.

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

Both forms and reports have a text box control, which displays the data found in the record source.

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

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

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

Unbound controls are controls that are tied to specific fields.

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

What are group headers and footers used for?

Subforms have to be created using the Form Wizard.

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

Which view gives a designer a higher level of control when creating forms and/or reports?

A(n) ________ in a form or report is connected to a specific field in a table or query.

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

A read-only form is a form that enables users to view but not change data.

When are subforms created?

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

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

Which of the following controls can you use to add emphasis to your form or report?

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

Which two views make it easy to edit the design of a form?

The ________ section in a report repeats for each record in a record source.

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

Both forms and reports have a text box control, which displays the data found in the record source.

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

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

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