Question 1

All of the following are form creation tools EXCEPT:

Accepted Answer

A)  Form Design. 
B)  Form Wizard. 
C)  Form Layout. 
D)  Blank Form. 
A)  Form Design. 
B)  Form Wizard. 
C)  Form Layout. 
D)  Blank Form.

Question 2

To apply a theme,you click Themes in the:

Accepted Answer

A)  Themes group on the FORMAT tab. 
B)  Arrange group on the FORMAT tab. 
C)  Themes group on the DESIGN tab. 
D)  Arrange group on the DESIGN tab. 
A)  Themes group on the FORMAT tab. 
B)  Arrange group on the FORMAT tab. 
C)  Themes group on the DESIGN tab. 
D)  Arrange group on the DESIGN tab.

Question 3

When in Layout or Design view,which of the follow is NOT a form layout tab?

Accepted Answer

A)  Design 
B)  Edit 
C)  Layout 
D)  Format 
A)  Design 
B)  Edit 
C)  Layout 
D)  Format

Question 4

A ________ is a defined set of colors,fonts,and graphics that can be applied to a form or report.

Accepted Answer

A)  prototype 
B)  style 
C)  theme 
D)  template 
A)  prototype 
B)  style 
C)  theme 
D)  template

Question 5

Text boxes,buttons,and boxes are examples of form ________.

Accepted Answer

The answer of Text boxes,buttons,and boxes are examples of form...

Question 6

The width of a field in a report can be changed in either Report or Design views.

Accepted Answer

A) True 
 B)False

Question 7

When working with forms,the Remove Layout option only appears in ________ view.

Accepted Answer

A)  Design 
B)  Layout 
C)  Form 
D)  Control 
A)  Design 
B)  Layout 
C)  Form 
D)  Control

Question 8

Explain the differences between a form with a subform and a split form.

Accepted Answer

A form with a subform consists of two ta

Question 9

To sort the order of records in a form,you need to open the form in:

Accepted Answer

A)  Tabular View. 
B)  Form View. 
C)  Design View. 
D)  Print Preview. 
A)  Tabular View. 
B)  Form View. 
C)  Design View. 
D)  Print Preview.

Question 10

The Format tab contains commands to change the font,display,and alignment of the controls on a report.

Accepted Answer

A) True 
 B)False

Question 11

A ________ is a document that displays database information in a meaningful format.

Accepted Answer

A)  form 
B)  report 
C)  table 
D)  query 
A)  form 
B)  report 
C)  table 
D)  query

Question 12

When viewing a form in Form view,you see that the records are displayed in order based on the primary key field.You prefer to temporarily view the records in alphabetical order by last names.Explain how to change the form to display records using the last name field,and how to return the form to display records in primary key order.

Accepted Answer

To sort by last names,click in the last

Question 13

ACCDB is a file type used to exchange documents independent of software applications and operating systems.

Accepted Answer

A) True 
 B)False

Question 14

Report view allows a report to be viewed onscreen in a continuous page layout.

Accepted Answer

A) True 
 B)False

Question 15

All of the following are report creation tools EXCEPT:

Accepted Answer

A)  Report Design. 
B)  Report Wizard. 
C)  Report Layout. 
D)  Blank Report. 
A)  Report Design. 
B)  Report Wizard. 
C)  Report Layout. 
D)  Blank Report.

Question 16

A(n)________ form displays all fields from a record source in a tabular layout similar to a table's Datasheet view.

Accepted Answer

The answer of A(n)________ form displays all fields from a...

Question 17

Design view can be used to alter the report design while still viewing the data.

Accepted Answer

A) True 
 B)False

Question 18

Form tool is the most common tool for creating forms.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is NOT a view when working with forms?

Accepted Answer

A)  Form 
B)  Layout 
C)  Design 
D)  Tabular 
A)  Form 
B)  Layout 
C)  Design 
D)  Tabular

Question 20

What type of form displays records in a tabular layout similar to a table's Datasheet view but has more editing options,such as adding graphics and buttons,than a datasheet?

Accepted Answer

A)  split Form 
B)  multiple Items Form 
C)  subform 
D)  compound form 
A)  split Form 
B)  multiple Items Form 
C)  subform 
D)  compound form

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

All of the following are form creation tools EXCEPT:

To apply a theme,you click Themes in the:

When in Layout or Design view,which of the follow is NOT a form layout tab?

A ________ is a defined set of colors,fonts,and graphics that can be applied to a form or report.

Text boxes,buttons,and boxes are examples of form ________.

The width of a field in a report can be changed in either Report or Design views.

When working with forms,the Remove Layout option only appears in ________ view.

Explain the differences between a form with a subform and a split form.

To sort the order of records in a form,you need to open the form in:

The Format tab contains commands to change the font,display,and alignment of the controls on a report.

A ________ is a document that displays database information in a meaningful format.

ACCDB is a file type used to exchange documents independent of software applications and operating systems.

Report view allows a report to be viewed onscreen in a continuous page layout.

All of the following are report creation tools EXCEPT:

A(n)________ form displays all fields from a record source in a tabular layout similar to a table's Datasheet view.

Design view can be used to alter the report design while still viewing the data.

Form tool is the most common tool for creating forms.

Which of the following is NOT a view when working with forms?

What type of form displays records in a tabular layout similar to a table's Datasheet view but has more editing options,such as adding graphics and buttons,than a datasheet?

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

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

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

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