Question 1

Most reports do not use the ________ layout because it makes the report longer than the alternative.

Accepted Answer

The answer of Most reports do not use the ________...

Question 2

If a form is designed properly it will not have to be changed once data entry has begun.

Accepted Answer

A) True 
 B)False

Question 3

Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not recommended as a professional way of styling a form?

Accepted Answer

A)  Use several fonts to indicate different types of data 
B)  Left-align the text boxes 
C)  Separate the primary key from the rest of the form 
D)  Right-align the labels 
A)  Use several fonts to indicate different types of data 
B)  Left-align the text boxes 
C)  Separate the primary key from the rest of the form 
D)  Right-align the labels

Question 5

Just as with forms, you can add, edit, or delete data in a report.

Accepted Answer

A) True 
 B)False

Question 6

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

Accepted Answer

A) True 
 B)False

Question 7

Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?

Accepted Answer

A)  Design view 
B)  Layout view 
C)  Form view 
D)  SQL view 
A)  Design view 
B)  Layout view 
C)  Form view 
D)  SQL view

Question 8

The first step in creating a form is to determine the record ________.

Accepted Answer

The answer of The first step in creating a form...

Question 9

How many navigation form layouts are available?

Accepted Answer

A)  Four 
B)  Five 
C)  Six 
D)  Seven 
A)  Four 
B)  Five 
C)  Six 
D)  Seven

Question 10

Which form tools creates a box asking for user input?

Accepted Answer

A)  Modal Dialog 
B)  Datasheet 
C)  Navigation 
D)  Form Wizard 
A)  Modal Dialog 
B)  Datasheet 
C)  Navigation 
D)  Form Wizard

Question 11

What can you not easily do using a form?

Accepted Answer

A)  Enter data 
B)  Edit data 
C)  Move data 
D)  Delete data 
A)  Enter data 
B)  Edit data 
C)  Move data 
D)  Delete data

Question 12

If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

Accepted Answer

The answer of If you want to sort a form...

Question 13

Which of the following is not considered one of the most common methods to create a form?

Accepted Answer

A)  Default Form 
B)  Form Wizard 
C)  Blank Form 
D)  Form Design 
A)  Default Form 
B)  Form Wizard 
C)  Blank Form 
D)  Form Design

Question 14

Match the following terms with their description:
I. Label Wizard
II. Form Wizard
III. Report Wizard
IV. SubForm Wizard
V. SubReport Wizard
A. Simplified way to create forms
B. Simplified way to create subforms
C. Simplified way to create reports
D. Used to create name tags
E. This does not exist in Access.

Accepted Answer

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

Question 15

What is not a group on the Report Layout Tools Format tab?

Accepted Answer

A)  Fields 
B)  Font 
C)  Number 
D)  Background 
A)  Fields 
B)  Font 
C)  Number 
D)  Background

Question 16

Which of the following cannot be included on a form?

Accepted Answer

A)  Check box 
B)  Sub report 
C)  Drop-down list 
D)  Button 
A)  Check box 
B)  Sub report 
C)  Drop-down list 
D)  Button

Question 17

What is not a common format for a number control?

Accepted Answer

A)  Currency 
B)  Accounting 
C)  Percent 
D)  Comma 
A)  Currency 
B)  Accounting 
C)  Percent 
D)  Comma

Question 18

Which of the following is not true?

Accepted Answer

A)  Adding a bright color draws attention to a field 
B)  Changing the color of a border adds contrast 
C)  Provide a visual separation between the primary key and the rest of the form 
D)  All text boxes should be the same length for consistency of look 
A)  Adding a bright color draws attention to a field 
B)  Changing the color of a border adds contrast 
C)  Provide a visual separation between the primary key and the rest of the form 
D)  All text boxes should be the same length for consistency of look

Question 19

When creating a form, Access might automatically add a(n) ________ if more than one table is related.

Accepted Answer

The answer of When creating a form, Access might automatically...

Question 20

The ________ Form tool enables you to create a form in Layout view.

Accepted Answer

The answer of The ________ Form tool enables you to...

Most reports do not use the ________ layout because it makes the report longer than the alternative.

If a form is designed properly it will not have to be changed once data entry has begun.

Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

Which of the following is not recommended as a professional way of styling a form?

Just as with forms, you can add, edit, or delete data in a report.

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?

The first step in creating a form is to determine the record ________.

How many navigation form layouts are available?

Which form tools creates a box asking for user input?

What can you not easily do using a form?

If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

Which of the following is not considered one of the most common methods to create a form?

What is not a group on the Report Layout Tools Format tab?

Which of the following cannot be included on a form?

What is not a common format for a number control?

Which of the following is not true?

When creating a form, Access might automatically add a(n) ________ if more than one table is related.

The ________ Form tool enables you to create a form in Layout view.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 4: Creating and Using Professional Forms and Reports

Most reports do not use the ________ layout because it makes the report longer than the alternative.

If a form is designed properly it will not have to be changed once data entry has begun.

Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

Which of the following is not recommended as a professional way of styling a form?

Just as with forms, you can add, edit, or delete data in a report.

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?

The first step in creating a form is to determine the record ________.

How many navigation form layouts are available?

Which form tools creates a box asking for user input?

What can you not easily do using a form?

If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

Which of the following is not considered one of the most common methods to create a form?

What is not a group on the Report Layout Tools Format tab?

Which of the following cannot be included on a form?

What is not a common format for a number control?

Which of the following is not true?

When creating a form, Access might automatically add a(n) ________ if more than one table is related.

The ________ Form tool enables you to create a form in Layout view.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters