Question 1

The skill used to create a form can be used to create a report as well.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The Answer of a control containing an expression that generates is...

Question 3

If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.

Accepted Answer

The answer of If you would like to see subtotals...

Question 4

In which section of a form or report is a company logo usually added?

Accepted Answer

Generally in the Form Header o

Question 5

A(n)________ is a control that is connected to a field in a table or query.

Accepted Answer

A)  bound control 
B)  unbound control 
C)  calculated control 
D)  combo box control 
A)  bound control 
B)  unbound control 
C)  calculated control 
D)  combo box control

Question 6

Which of the following is NOT used when laying out forms and reports?

Accepted Answer

A)  Changing the Allow Edits property to No 
B)  Controls not bound to specific fields 
C)  Controls that change each time a new record is displayed 
D)  Lines, pictures, and other non-data-related elements 
A)  Changing the Allow Edits property to No 
B)  Controls not bound to specific fields 
C)  Controls that change each time a new record is displayed 
D)  Lines, pictures, and other non-data-related elements

Question 7

What is the difference between a bound control and an unbound control?

Accepted Answer

A bound control is connected t

Question 8

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 9

A(n)________ contains an expression that generates a calculated result.

Accepted Answer

A)  calculated control 
B)  rectangle control 
C)  bound control 
D)  unbound control 
A)  calculated control 
B)  rectangle control 
C)  bound control 
D)  unbound control

Question 10

Sum,Min,Max,and Average are examples of which kind of functions?

Accepted Answer

A)  Aggregate functions 
B)  Constant functions 
C)  Control functions 
D)  Bound functions 
A)  Aggregate functions 
B)  Constant functions 
C)  Control functions 
D)  Bound functions

Question 11

To add emphasis to a form or report,use the Line control or the Rectangle control.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

Which of the following controls contains to decorative elements,such as the title of the report?

Accepted Answer

A)  Unbound 
B)  Bound 
C)  Calculated 
D)  Rectangle and line 
A)  Unbound 
B)  Bound 
C)  Calculated 
D)  Rectangle and line

Question 15

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 16

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 17

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

Question 18

Where is a Group Header located?

Accepted Answer

A)  At the start of each new group 
B)  Top of the form/report 
C)  Middle of form/report 
D)  At the end of each group 
A)  At the start of each new group 
B)  Top of the form/report 
C)  Middle of form/report 
D)  At the end of each group

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Where would you go to change tab order in a form?

Accepted Answer

A)  Design view - Tab order in Tools group 
B)  Property sheet 
C)  Datasheet view - Tab order in Tools group 
D)  Detail section 
A)  Design view - Tab order in Tools group 
B)  Property sheet 
C)  Datasheet view - Tab order in Tools group 
D)  Detail section

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

The skill used to create a form can be used to create a report as well.

If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.

In which section of a form or report is a company logo usually added?

A(n)________ is a control that is connected to a field in a table or query.

Which of the following is NOT used when laying out forms and reports?

What is the difference between a bound control and an unbound control?

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

A(n)________ contains an expression that generates a calculated result.

Sum,Min,Max,and Average are examples of which kind of functions?

To add emphasis to a form or report,use the Line control or the Rectangle control.

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

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

Which of the following controls contains to decorative elements,such as the title of the report?

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

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

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

Where is a Group Header located?

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

Where would you go to change tab order in a form?

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