Question 1

-The data outlined in the accompanying figure is an example of _____________________ applied to field values meeting one or more conditions.

Accepted Answer

conditiona...

Question 2

-In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

Accepted Answer

A)   1
B)   2
C)   3
D)   4E) B) and D)
F) C) and D)

Question 3

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

Accepted Answer

A)   formatting
B)   design
C)   alignment
D)   contextualE) A) and C)
F) B) and D) D

Question 4

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 5

MATCHING
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) Show me more informationG) FindH) Layout viewI) shadingJ) #K) A) and B)
L) A) and F)

Question 6

-In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

Accepted Answer

A)   Reports
B)   Forms
C)   Queries
D)   TablesE) A) and C)
F) A) and B)

Question 7

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

Question 8

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

Accepted Answer

A) True 
 B)False

Question 9

When a form is created based on two or more tables, a relationship must be defined between queries. ____________________

Accepted Answer

A) True 
 B)False

Question 10

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

Accepted Answer

The answer of A button with the subform's name on...

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

Question 12

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

Question 13

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

Accepted Answer

The answer of Records printed in Form view are distinguished...

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

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 16

-In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

Accepted Answer

A)   Form
B)   Query
C)   Report
D)   TableE) B) and C)
F) A) and B)

Question 17

-In the accompanying figure, which record number is the current record?

Accepted Answer

A)   51
B)   22539
C)   33
D)   06117E) B) and D)
F) None of the above

Question 18

Print All, Pages, and Selected Record(s)  are options available from the ____ for printing forms.

Accepted Answer

A)   PRINT PREVIEW tab
B)   Print dialog box
C)   PRINT LAYOUT tab
D)   Print layout options dialog boxE) A) and B)
F) None of the above B

Question 19

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

The answer of To generate a report with exact results...

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

-The data outlined in the accompanying figure is an example of _____________________ applied to field values meeting one or more conditions.

Correct Answerverifiedconditiona...View AnswerShow Answer

-In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

Correct AnswerverifiedShow Answer

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

MATCHING 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

-In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

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

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

Correct AnswerverifiedShow Answer

When a form is created based on two or more tables, a relationship must be defined between queries. ____________________

Correct AnswerverifiedShow Answer

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

Correct AnswerverifiedShow Answer

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

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

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

Correct AnswerverifiedShow Answer

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

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

-In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

Correct AnswerverifiedShow Answer

-In the accompanying figure, which record number is the current record?

Correct AnswerverifiedShow Answer

Print All, Pages, and Selected Record(s) are options available from the ____ for printing forms.

Correct AnswerverifiedB

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.

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

Correct Answer
verified
conditiona...
View Answer

Correct Answer
verified

Correct Answer
verified
D

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
A

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