Question 1

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 2

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

Question 3

The ________ source is also referred to as the data source.

Accepted Answer

The answer of The ________ source is also referred to...

Question 4

The form Layout view can be used for all of the following EXCEPT:

Accepted Answer

A)  adding or removing a field. 
B)  changing the order of fields. 
C)  adding a calculated field. 
D)  changing the width of a field. 
A)  adding or removing a field. 
B)  changing the order of fields. 
C)  adding a calculated field. 
D)  changing the width of a field.

Question 5

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

Accepted Answer

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

Question 6

To apply a background image to a file, click Background in the:

Accepted Answer

A)  Background group on the FORMAT tab. 
B)  Picture group on the FORMAT tab. 
C)  Background group on the DESIGN tab. 
D)  Picture group on the DESIGN tab. 
A)  Background group on the FORMAT tab. 
B)  Picture group on the FORMAT tab. 
C)  Background group on the DESIGN tab. 
D)  Picture group on the DESIGN tab.

Question 7

Form tool is the most common tool for creating forms.

Accepted Answer

A) True 
 B)False

Question 8

Access can be used to create forms that match paper forms.

Accepted Answer

A) True 
 B)False

Question 9

The ________ view is used to add, edit, and delete data in a form, but it cannot be used to change the layout and design of the form.

Accepted Answer

A)  Insert 
B)  Edit 
C)  Modify 
D)  Form 
A)  Insert 
B)  Edit 
C)  Modify 
D)  Form

Question 10

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 11

The ________ displays form fields in vertical column, and displays one record at a time.

Accepted Answer

A)  Stacked Layout 
B)  Layout View 
C)  Tabular Layout 
D)  Print Preview 
A)  Stacked Layout 
B)  Layout View 
C)  Tabular Layout 
D)  Print Preview

Question 12

A field can be deleted from a report in either Layout or Design views.

Accepted Answer

A) True 
 B)False

Question 13

Match each view to its definition:
I. Report
II. Layout
III. Form
IV. Design
V. Print Preview
A. Primarily used for data entry
B. Allows advanced features to be applied
C. Displays a report onscreen in a continuous page layout
D. Used to view a report prior to printing
E. Allows form or report design to be altered while still viewing the data

Accepted Answer

The answer of Match each view to its definition:
I. Report
II....

Question 14

The Arrange tab displays in both Layout and ________ views.

Accepted Answer

The answer of The Arrange tab displays in both Layout...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

A theme can be applied to a report in either Layout or Report views.

Accepted Answer

A) True 
 B)False

Question 17

The Report Wizard tool is used by advanced users who want to create a blank report with no help from Access.

Accepted Answer

A) True 
 B)False

Question 18

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3) will appear in a column with the heading ________.

Accepted Answer

A)  PricePerRoom 
B)  ListPrice 
C)  Beds 
D)  Baths 
A)  PricePerRoom 
B)  ListPrice 
C)  Beds 
D)  Baths

Question 19

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

Accepted Answer

The answer of ________ view is useful for testing the...

Question 20

Layout view allows alterations to the form design while still viewing the data.

Accepted Answer

A) True 
 B)False

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

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?

The ________ source is also referred to as the data source.

The form Layout view can be used for all of the following EXCEPT:

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

To apply a background image to a file, click Background in the:

Form tool is the most common tool for creating forms.

Access can be used to create forms that match paper forms.

The ________ view is used to add, edit, and delete data in a form, but it cannot be used to change the layout and design of the form.

All of the following are report creation tools EXCEPT:

The ________ displays form fields in vertical column, and displays one record at a time.

A field can be deleted from a report in either Layout or Design views.

The Arrange tab displays in both Layout and ________ views.

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

A theme can be applied to a report in either Layout or Report views.

The Report Wizard tool is used by advanced users who want to create a blank report with no help from Access.

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3) will appear in a column with the heading ________.

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

Layout view allows alterations to the form design while still viewing the data.

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

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

Office Fundamentals and File Management

Filters

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

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

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?

The ________ source is also referred to as the data source.

The form Layout view can be used for all of the following EXCEPT:

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

To apply a background image to a file, click Background in the:

Form tool is the most common tool for creating forms.

Access can be used to create forms that match paper forms.

The ________ view is used to add, edit, and delete data in a form, but it cannot be used to change the layout and design of the form.

All of the following are report creation tools EXCEPT:

The ________ displays form fields in vertical column, and displays one record at a time.

A field can be deleted from a report in either Layout or Design views.

The Arrange tab displays in both Layout and ________ views.

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

A theme can be applied to a report in either Layout or Report views.

The Report Wizard tool is used by advanced users who want to create a blank report with no help from Access.

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3) will appear in a column with the heading ________.

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

Layout view allows alterations to the form design while still viewing the data.

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

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

Office Fundamentals and File Management

Filters