Question 1

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

Accepted Answer

A)  formatting 
B)  design 
C)  alignment 
D)  contextual 
A)  formatting 
B)  design 
C)  alignment 
D)  contextual D

Question 2

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Accepted Answer

A)  Changing page orientation 
B)  Changing the report name 
C)  Adding conditional formatting 
D)  Changing font colors 
A)  Changing page orientation 
B)  Changing the report name 
C)  Adding conditional formatting 
D)  Changing font colors A

Question 3

Print All, Pages, and Selected Record(s) are options available from the ____ for printing forms.

Accepted Answer

A)  PRINT PREVIEW tab 
B)  Print dialog box 
C)  PRINT LAYOUT tab 
D)  Print layout options dialog box 
A)  PRINT PREVIEW tab 
B)  Print dialog box 
C)  PRINT LAYOUT tab 
D)  Print layout options dialog box B

Question 4

-In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 5

To generate a report with exact results based on specific criteria it is best to base the report on a(n) ____________________ created in the database.

Accepted Answer

The answer of To generate a report with exact results...

Question 6

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Accepted Answer

The answer of A placeholder used in a value search...

Question 7

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

Accepted Answer

The answer of Precise control for moving selected objects on...

Question 8

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Accepted Answer

A) True 
 B)False

Question 9

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.

Accepted Answer

A) True 
 B)False

Question 10

-In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

Accepted Answer

A)  Form 
B)  Query 
C)  Report 
D)  Table 
A)  Form 
B)  Query 
C)  Report 
D)  Table

Question 11

When a form is created based on two or more tables, a relationship must be defined between queries. ____________________

Accepted Answer

A) True 
 B)False

Question 12

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

Accepted Answer

The answer of Records printed in Form view are distinguished...

Question 13

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

Accepted Answer

A) True 
 B)False

Question 14

-The data outlined in the accompanying figure is an example of _____________________ applied to field values meeting one or more conditions.

Accepted Answer

conditiona

Question 15

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

Accepted Answer

The answer of A button with the subform's name on...

Question 16

A form created from two tables that have a ____ relationship creates a main form and a subform.

Accepted Answer

A)  one-to-one 
B)  one-to-all 
C)  many-to-many 
D)  one-to-many 
A)  one-to-one 
B)  one-to-all 
C)  many-to-many 
D)  one-to-many

Question 17

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

Accepted Answer

A)  (?) 
B)  (*) 
C)  (-) 
D)  (#) 
A)  (?) 
B)  (*) 
C)  (-) 
D)  (#)

Question 18

MATCHING
Insert the letter of the choice that best matches the phrase or definition.
-The wildcard character that will match any single numeric character.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)# 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)#

Question 19

-In the accompanying figure, which record number is the current record?

Accepted Answer

A)  51 
B)  22539 
C)  33 
D)  06117 
A)  51 
B)  22539 
C)  33 
D)  06117

Question 20

-In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

Accepted Answer

A)  Reports 
B)  Forms 
C)  Queries 
D)  Tables 
A)  Reports 
B)  Forms 
C)  Queries 
D)  Tables

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Print All, Pages, and Selected Record(s) are options available from the ____ for printing forms.

-In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

To generate a report with exact results based on specific criteria it is best to base the report on a(n) ____________________ created in the database.

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.

-In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

When a form is created based on two or more tables, a relationship must be defined between queries. ____________________

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

-The data outlined in the accompanying figure is an example of _____________________ applied to field values meeting one or more conditions.

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

A form created from two tables that have a ____ relationship creates a main form and a subform.

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any single numeric character.

-In the accompanying figure, which record number is the current record?

-In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 4: Creating Forms and Reports

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Print All, Pages, and Selected Record(s) are options available from the ____ for printing forms.

-In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

To generate a report with exact results based on specific criteria it is best to base the report on a(n) ____________________ created in the database.

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.

-In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

When a form is created based on two or more tables, a relationship must be defined between queries. ____________________

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

-The data outlined in the accompanying figure is an example of _____________________ applied to field values meeting one or more conditions.

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

A form created from two tables that have a ____ relationship creates a main form and a subform.

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any single numeric character.

-In the accompanying figure, which record number is the current record?

-In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters