Question 1

A report formatted where the page is taller than it is wide is formatted in ____.

Accepted Answer

A) landscape orientation 
B) primary datasheet orientation 
C) portrait orientation 
D) Wizard orientation 
A) landscape orientation 
B) primary datasheet orientation 
C) portrait orientation 
D) Wizard orientation C

Question 2

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

query

Question 3

Insert the letter of the choice that best matches the phrase or definition.
-The easiest way to move a picture on a form is to first remove the picture from the ____.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! D

Question 4

Insert the letter of the choice that best matches the phrase or definition.
-The button used to display the Find and Replace dialog box.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​!

Question 5

The Form Wizard limits fields to be used in a form to one table or one query.____________________

Accepted Answer

A) True 
 B)False

Question 6

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

Accepted Answer

The answer of Alignment of text in a field value...

Question 7

Insert the letter of the choice that best matches the phrase or definition.
-The button used to change the theme of a form from the default theme to another theme in Layout view.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​!

Question 8

In addition to standard colors,the font color gallery displays ____ colors.

Accepted Answer

A) Pantone 
B) graphic 
C) theme 
D) print 
A) Pantone 
B) graphic 
C) theme 
D) print

Question 9

The most detailed view of a form's structure is available the Layout view.____________________

Accepted Answer

A) True 
 B)False

Question 10

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

Accepted Answer

A) single table 
B) datasheet layout 
C) single record 
D) subform layout 
A) single table 
B) datasheet layout 
C) single record 
D) subform layout

Question 11

To resize an image without changing its proportions,simply drag  ____ of the image.

Accepted Answer

A) the left side 
B) the top 
C) any corner 
D) the bottom 
A) the left side 
B) the top 
C) any corner 
D) the bottom

Question 12

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Accepted Answer

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

Question 13

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

Accepted Answer

A) control 
B) design box 
C) replace character 
D) wildcard character 
A) control 
B) design box 
C) replace character 
D) wildcard character

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

Accepted Answer

Answers might include: (1)It is importan

Question 16

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

Accepted Answer

A) condition type 
B) rule type 
C) field format 
D) field value 
A) condition type 
B) rule type 
C) field format 
D) field value

Question 17

The less precise way to move objects in report Layout view is to ____.

Accepted Answer

A) use the Move command to move objects 
B) use the arrow keys on the keyboard to move objects 
C) drag objects 
D) use the insert key on the keyboard to move objects 
A) use the Move command to move objects 
B) use the arrow keys on the keyboard to move objects 
C) drag objects 
D) use the insert key on the keyboard to move objects

Question 18

Access allows all pages,a range of pages,or a currently selected record to be printed from Form view.____________________

Accepted Answer

A) True 
 B)False

Question 19

A report layout may be changed using options on the ____________________ tab.

Accepted Answer

The answer of A report layout may be changed using...

Question 20

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Accepted Answer

A) resize the object 
B) delete the object and recreate it 
C) move the object to another location 
D) change the caption 
A) resize the object 
B) delete the object and recreate it 
C) move the object to another location 
D) change the caption

A report formatted where the page is taller than it is wide is formatted in ____.

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.

Insert the letter of the choice that best matches the phrase or definition. -The easiest way to move a picture on a form is to first remove the picture from the ____.

Insert the letter of the choice that best matches the phrase or definition. -The button used to display the Find and Replace dialog box.

The Form Wizard limits fields to be used in a form to one table or one query.____________________

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

Insert the letter of the choice that best matches the phrase or definition. -The button used to change the theme of a form from the default theme to another theme in Layout view.

In addition to standard colors,the font color gallery displays ____ colors.

The most detailed view of a form's structure is available the Layout view.____________________

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

To resize an image without changing its proportions,simply drag ____ of the image.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

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

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

The less precise way to move objects in report Layout view is to ____.

Access allows all pages,a range of pages,or a currently selected record to be printed from Form view.____________________

A report layout may be changed using options on the ____________________ tab.

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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

A report formatted where the page is taller than it is wide is formatted in ____.

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.

Insert the letter of the choice that best matches the phrase or definition. -The easiest way to move a picture on a form is to first remove the picture from the ____.

Insert the letter of the choice that best matches the phrase or definition. -The button used to display the Find and Replace dialog box.

The Form Wizard limits fields to be used in a form to one table or one query.____________________

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

Insert the letter of the choice that best matches the phrase or definition. -The button used to change the theme of a form from the default theme to another theme in Layout view.

In addition to standard colors,the font color gallery displays ____ colors.

The most detailed view of a form's structure is available the Layout view.____________________

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

To resize an image without changing its proportions,simply drag ____ of the image.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

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

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

The less precise way to move objects in report Layout view is to ____.

Access allows all pages,a range of pages,or a currently selected record to be printed from Form view.____________________

A report layout may be changed using options on the ____________________ tab.

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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