Question 1

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

Accepted Answer

A)   field label
B)   caption 
C)   field value
D)   designE) C) and D)
F) None of the above

Question 2

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 3

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 orientationE) A) and C)
F) A) and D)

Question 4

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-manyE) B) and C)
F) All of the above

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

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 WizardF) Pencil symbolG) FindH) Layout viewI) shadingJ) #K) !L) None of the above
M) H) and K)

Question 10

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)   #E) B) and C)
F) C) and D)

Question 11

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 FormattingE) B) and C)
F) A) and C)

Question 12

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

Accepted Answer

A)   HOME
B)   PRINT PREVIEW 
C)   DESIGN
D)   FILEE) A) and C)
F) C) and D)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 WizardF) Pencil symbolG) FindH) Layout viewI) shadingJ) #K) !L) H) and I)
M) G) and J)

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 valueE) A) and B)
F) A) and C) B

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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)   ShiftE) B) and C)
F) All of the above

Question 19

____ 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 colorsE) B) and D)
F) B) and C) A

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 4: Creating Forms and Reports

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified