Question 1

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

Question 2

A(n) ________ is a defined set of colors, fonts, and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.

Accepted Answer

theme

Question 3

A report can be saved as a PDF file so users without Access can view it.

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following is NOT a form view?

Accepted Answer

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

Question 5

Match between columns
                        Premises: Report
Layout
Form
Design
Print Preview

Accepted Answer

The Answer of Primarily used for data entry and Allows is...

Question 6

When creating a report, ________ asks a series of questions and uses the answers to generate a customized report.

Accepted Answer

A)  the Report Wizard 
B)  a Blank Report 
C)  Report Design 
D)  Report 
A)  the Report Wizard 
B)  a Blank Report 
C)  Report Design 
D)  Report

Question 7

The table or query that supplies underlying data to a form or report is called the:

Accepted Answer

A)  information source. 
B)  record source. 
C)  data source. 
D)  object source. 
A)  information source. 
B)  record source. 
C)  data source. 
D)  object source.

Question 8

Match between columns
                        Premises: Report
Report Design
Blank Report
Report Wizard
Labels

Accepted Answer

The Answer of Uses preformatted label templates and Creates a is...

Question 9

Form view is used to change a form's data and layout.

Accepted Answer

A) True 
 B)False

Question 10

Text boxes, buttons, and boxes are examples of ________, which can be used to add, edit, and display data in a form or report.

Accepted Answer

A)  placeholders 
B)  controls 
C)  containers 
D)  records 
A)  placeholders 
B)  controls 
C)  containers 
D)  records

Question 11

Referencing the image above, this form contains a:

Accepted Answer

A)  split Form. 
B)  multiple Items Form. 
C)  macro Form. 
D)  subform. 
A)  split Form. 
B)  multiple Items Form. 
C)  macro Form. 
D)  subform.

Question 12

Match each term to its meaning:
I. Theme
II. Form
III. Record Source
IV. Report
V. Wizard
A. Asks a series of questions and designs a custom form or report
B. Underlying table or query that provides the fields for a form
C. Document displaying database information in a format meaningful to its readers
D. Used to add data into or edit data in a table
E. Defined set of colors, fonts, and graphics

Accepted Answer

The answer of Match each term to its meaning:
I. Theme
II....

Question 13

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

Accepted Answer

A)  Format view 
B)  Print Preview 
C)  Design view 
D)  Report view 
A)  Format view 
B)  Print Preview 
C)  Design view 
D)  Report view

Question 14

If you need to sort the records contained in a report, you can do so from either the Design view or the ________ of the report.

Accepted Answer

A)  Sort View 
B)  Layout View 
C)  Print preview 
D)  Report view 
A)  Sort View 
B)  Layout View 
C)  Print preview 
D)  Report view

Question 15

The Tag Wizard is used create name tags and other specialized tags.

Accepted Answer

A) True 
 B)False

Question 16

When in Layout view, the Group, Sort, and Total pane is used to change the sorting in a report.

Accepted Answer

A) True 
 B)False

Question 17

The Report Wizard can be used to group fields in a report.

Accepted Answer

A) True 
 B)False

Question 18

A ________report is a specialized report that comes preformatted to coordinate with products such as those manufactured by Avery.

Accepted Answer

A)  rapid distribution 
B)  mass distribution 
C)  value added 
D)  mailing label 
A)  rapid distribution 
B)  mass distribution 
C)  value added 
D)  mailing label

Question 19

PDF stands for ________.

Accepted Answer

Portable D

Question 20

Which of the following is NOT a report view?

Accepted Answer

A)  Report 
B)  Design 
C)  Layout 
D)  Print 
A)  Report 
B)  Design 
C)  Layout 
D)  Print

To apply a theme, you click Themes in the:

A(n) ________ is a defined set of colors, fonts, and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.

A report can be saved as a PDF file so users without Access can view it.

Which of the following is NOT a form view?

When creating a report, ________ asks a series of questions and uses the answers to generate a customized report.

The table or query that supplies underlying data to a form or report is called the:

Form view is used to change a form's data and layout.

Text boxes, buttons, and boxes are examples of ________, which can be used to add, edit, and display data in a form or report.

Referencing the image above, this form contains a:

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

If you need to sort the records contained in a report, you can do so from either the Design view or the ________ of the report.

The Tag Wizard is used create name tags and other specialized tags.

When in Layout view, the Group, Sort, and Total pane is used to change the sorting in a report.

The Report Wizard can be used to group fields in a report.

A ________report is a specialized report that comes preformatted to coordinate with products such as those manufactured by Avery.

PDF stands for ________.

Which of the following is NOT a report view?

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

To apply a theme, you click Themes in the:

A(n) ________ is a defined set of colors, fonts, and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.

A report can be saved as a PDF file so users without Access can view it.

Which of the following is NOT a form view?

When creating a report, ________ asks a series of questions and uses the answers to generate a customized report.

The table or query that supplies underlying data to a form or report is called the:

Form view is used to change a form's data and layout.

Text boxes, buttons, and boxes are examples of ________, which can be used to add, edit, and display data in a form or report.

Referencing the image above, this form contains a:

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

If you need to sort the records contained in a report, you can do so from either the Design view or the ________ of the report.

The Tag Wizard is used create name tags and other specialized tags.

When in Layout view, the Group, Sort, and Total pane is used to change the sorting in a report.

The Report Wizard can be used to group fields in a report.

A ________report is a specialized report that comes preformatted to coordinate with products such as those manufactured by Avery.

PDF stands for ________.

Which of the following is NOT a report view?

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