Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

An item on a form or report object that can be manipulated to modify an object's appearance is a(n)____.

Accepted Answer

A) element 
B) property 
C) control 
D) layout 
A) element 
B) property 
C) control 
D) layout C

Question 3

Report fields and field value boxes may be repositioned while viewing the report in Layout view.____________________

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

Viewing and printing options for forms and records are available on the ____ tab.

Accepted Answer

A) HOME 
B) PRINT PREVIEW 
C) DESIGN 
D) FILE 
A) HOME 
B) PRINT PREVIEW 
C) DESIGN 
D) FILE

Question 6

____ 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

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Insert the letter of the choice that best matches the phrase or definition.
-​The wildcard character that will match any character not within brackets.

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 10

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 11

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 12

Field values editedin Form view are also changed in the form's underlying table.____________________

Accepted Answer

A) True 
 B)False

Question 13

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 14

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

Accepted Answer

A) primary record 
B) detail record 
C) secondary table 
D) record values 
A) primary record 
B) detail record 
C) secondary table 
D) record values

Question 15

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

Question 16

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.
____________________

Accepted Answer

A) True 
 B)False

Question 17

The first,last,next,or previous page in a report may be displayed using the ____________________ buttons.

Accepted Answer

The answer of The first,last,next,or previous page in a report...

Question 18

When using a wildcard character in the Find and Replace dialog box,it is necessary to select the Any Part of Field Match option.____________________

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

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

An item on a form or report object that can be manipulated to modify an object's appearance is a(n)____.

Report fields and field value boxes may be repositioned while viewing the report in Layout view.____________________

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

Viewing and printing options for forms and records are available on the ____ tab.

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

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

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

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any character not within brackets.

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

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

Field values editedin Form view are also changed in the form's underlying table.____________________

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

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

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

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. ____________________

The first,last,next,or previous page in a report may be displayed using the ____________________ buttons.

When using a wildcard character in the Find and Replace dialog box,it is necessary to select the Any Part of Field Match option.____________________

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 4: Creating Forms and Reports

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

An item on a form or report object that can be manipulated to modify an object's appearance is a(n)____.

Report fields and field value boxes may be repositioned while viewing the report in Layout view.____________________

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

Viewing and printing options for forms and records are available on the ____ tab.

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

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

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

Insert the letter of the choice that best matches the phrase or definition. -​The wildcard character that will match any character not within brackets.

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

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

Field values editedin Form view are also changed in the form's underlying table.____________________

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

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

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

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. ____________________

The first,last,next,or previous page in a report may be displayed using the ____________________ buttons.

When using a wildcard character in the Find and Replace dialog box,it is necessary to select the Any Part of Field Match option.____________________

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any character not within brackets.