Question 1

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

Question 2

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Accepted Answer

The answer of A set of controls grouped together in...

Question 3

To print two records from a form,select the ____ option in the Print dialog box.

Accepted Answer

A)  Selected Page(s) 
B)  Current Page
C)  Range
D)  Selected Record(s) E) B) and D)
F) B) and C)

Question 4

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

Question 5

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 6

Insert the letter of the choice that best matches the phrase or definition.
-The wildcard character used to match any single alphabetic character.

Accepted Answer

A)  (?) 
B)  Themes
C)  Design view
D)  control layout
E)  Report WizardF) Pencil symbolG) FindH) Layout viewI) shadingJ) #K) ​!L) B) and F)
M) A) and B)

Question 7

Insert the letter of the choice that best matches the phrase or definition.
-The feature used to distinguish one record from another in a form.

Accepted Answer

A)  (?) 
B)  Themes
C)  Design view
D)  control layout
E)  Report WizardF) Pencil symbolG) FindH) Layout viewI) shadingJ) #K) ​!L) All of the above
M) B) and K)

Question 8

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) F) and J)
M) G) and I)

Question 9

Briefly explain options available for applying a theme to a form or report and other database objects.

Accepted Answer

Themes may be applied to all m...

Question 10

A form must be displayed in ____________________ view to navigate,view,and edit data.

Accepted Answer

The answer of A form must be displayed in ____________________...

Question 11

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

Question 12

Insert the letter of the choice that best matches the phrase or definition.
-Indicates editing mode.

Accepted Answer

A)  (?) 
B)  Themes
C)  Design view
D)  control layout
E)  Report WizardF) Pencil symbolG) FindH) Layout viewI) shadingJ) #K) ​!L) G) and J)
M) C) and H)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Data in Date/Time fields are automatically ____-aligned.

Accepted Answer

A)  left
B)  right
C)  center
D)  topE) C) and D)
F) B) and D)

Question 15

A form created from more than one table uses the primary table for the main form.____________________

Accepted Answer

A) True 
 B)False

Question 16

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

Question 17

When using the Report Wizard,the report title entered in the Wizard is also the name of the report ____________________.

Accepted Answer

The answer of When using the Report Wizard,the report title...

Question 18

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

Question 19

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

Question 20

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

Exam 4: Creating Forms and Reports

Insert the letter of the choice that best matches the phrase or definition. -The feature used to distinguish one record from another in a form.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A form must be displayed in ____________________ view to navigate,view,and edit data.

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

Data in Date/Time fields are automatically ____-aligned.

Correct AnswerverifiedShow Answer

A form created from more than one table uses the primary table for the main form.____________________

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

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

Insert the letter of the choice that best matches the phrase or definition. -Indicates editing mode.

Correct AnswerverifiedShow Answer

When using the Report Wizard,the report title entered in the Wizard is also the name of the report ____________________.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Briefly explain options available for applying a theme to a form or report and other database objects.

Correct AnswerverifiedThemes may be applied to all m...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character used to match any single alphabetic character.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To print two records from a form,select the ____ option in the Print dialog box.

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

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Themes may be applied to all m...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified