Question 1

____ 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 2

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 B

Question 3

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  False

Question 4

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 5

A form's object name appears on the tab for the form in the Access window. ____________________

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

The Report Wizard allows detail records to be u>sorted by up to four fields.____________________

Accepted Answer

A) True 
 B)False

Question 9

The default theme for a new form that is created is the ____________________ theme.

Accepted Answer

The answer of  The default theme for a new form...

Question 10

The Tabular and Justified form report layouts display the fields from multiple records at one time.____________________

Accepted Answer

A) True 
 B)False

Question 11

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 12

To select both a field label and field value to move in a report design,after selecting the field label press the ____ key to select the field value box.

Accepted Answer

A)  Ctrl 
B)  Alt 
C)  F2 
D)  Shift 
A)  Ctrl 
B)  Alt 
C)  F2 
D)  Shift

Question 13

Layout view shows both the form and its data while allowing the form to be modified. ____________________

Accepted Answer

A) True 
 B)False

Question 14

Before applying a conditional format in a report,the ____ box must be selected.

Accepted Answer

A)  field label 
B)  caption 
C)  field value 
D)  design 
A)  field label 
B)  caption 
C)  field value 
D)  design

Question 15

After a conditional formatting rule is created using the ____ dialog box,the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

Accepted Answer

A)  New Formatting Rule 
B)  Conditional Formatting Manager 
C)  Report Rules Manager 
D)  Field Conditions Formatting 
A)  New Formatting Rule 
B)  Conditional Formatting Manager 
C)  Report Rules Manager 
D)  Field Conditions Formatting

Question 16

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

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 19

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 20

Insert the letter of the choice that best matches the phrase or definition.
- A report must be in Design view or this view to apply conditional formatting.

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)!

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

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

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

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

A form's object name appears on the tab for the form in the Access window. ____________________

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

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

The Report Wizard allows detail records to be u>sorted by up to four fields.____________________

The default theme for a new form that is created is the ____________________ theme.

The Tabular and Justified form report layouts display the fields from multiple records at one time.____________________

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

To select both a field label and field value to move in a report design,after selecting the field label press the ____ key to select the field value box.

Layout view shows both the form and its data while allowing the form to be modified. ____________________

Before applying a conditional format in a report,the ____ box must be selected.

After a conditional formatting rule is created using the ____ dialog box,the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

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

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

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

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. - A report must be in Design view or this view to apply conditional formatting.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Filters

Exam 4: Creating Forms and Reports

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

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

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

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

A form's object name appears on the tab for the form in the Access window. ____________________

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

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

The Report Wizard allows detail records to be u>sorted by up to four fields.____________________

The default theme for a new form that is created is the ____________________ theme.

The Tabular and Justified form report layouts display the fields from multiple records at one time.____________________

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

To select both a field label and field value to move in a report design,after selecting the field label press the ____ key to select the field value box.

Layout view shows both the form and its data while allowing the form to be modified. ____________________

Before applying a conditional format in a report,the ____ box must be selected.

After a conditional formatting rule is created using the ____ dialog box,the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

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

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

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

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. - A report must be in Design view or this view to apply conditional formatting.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

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.