Question 1

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 2

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 3

Insert the letter of the choice that best matches the phrase or definition.
- The Access feature that asks a series of questions and creates a report based on the answers to those questions.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The Report Wizard is the feature in Access that asks a series of questions and creates a report based on the answers.

Question 4

Insert the letter of the choice that best matches the phrase or definition.
- The wildcard character used to match any single alphabetic character.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The wildcard character used to match any single alphabetic character is the question mark symbol (?).

Question 5

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.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The answer of Insert the letter of the choice that...

Question 6

Insert the letter of the choice that best matches the phrase or definition.
- Indicates editing mode.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The pencil symbol is used to indicate editing mode in Microsoft Access.

Question 7

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

Accepted Answer

The answer of  Briefly explain options available for applying a...

Question 8

Insert the letter of the choice that best matches the phrase or definition.
- The easiest way to move a picture on a form is to first remove the picture from the ____.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

Control layout refers to the arrangement of controls or objects on a form. To move a picture on a form, it must be selected and then moved within the control layout.

Question 9

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.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The answer of Insert the letter of the choice that...

Question 10

Insert the letter of the choice that best matches the phrase or definition.
- The button used to change the theme of a form from the default theme to another theme in Layout view.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The letter B represents the option "Themes", which is a feature that allows users to change the appearance of a form or report in Access. In Layout view, there is a button specifically for changing the theme, which is indicated by the "Themes" option.

Question 11

Insert the letter of the choice that best matches the phrase or definition.
- The wildcard character that will match any single numeric character.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The pound sign (#) is the wildcard character that will match any single numeric character. This is commonly used in queries or filtering data.

Question 12

Insert the letter of the choice that best matches the phrase or definition.
- The button used to display the Find and Replace dialog box.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The Find button is used to display the Find and Replace dialog box.

Question 13

Insert the letter of the choice that best matches the phrase or definition.
- The view that gives the most detailed view of the structure of a form or report.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

Design view is the view that gives the most detailed view of the structure of a form or report. It allows for manipulation of individual elements and properties.

Question 14

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

Accepted Answer

The answer of  Discuss three considerations that are important to...

Question 15

Insert the letter of the choice that best matches the phrase or definition.
- ​The wildcard character that will match any character not within brackets.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Accepted Answer

The exclamation mark (!) is a wildcard character that will match any character not within brackets in Microsoft Access.

Quiz 4: Creating Forms and Reports

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.

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

Insert the letter of the choice that best matches the phrase or definition. - The Access feature that asks a series of questions and creates a report based on the answers to those questions.

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

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.

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

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

Insert the letter of the choice that best matches the phrase or definition. - The easiest way to move a picture on a form is to first remove the picture from the ____.

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.

Insert the letter of the choice that best matches the phrase or definition. - The button used to change the theme of a form from the default theme to another theme in Layout view.

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

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

Insert the letter of the choice that best matches the phrase or definition. - The view that gives the most detailed view of the structure of a form or report.

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

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

Quiz 4: Creating Forms and Reports

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.

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

Insert the letter of the choice that best matches the phrase or definition. - The Access feature that asks a series of questions and creates a report based on the answers to those questions.

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

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.

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

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

Insert the letter of the choice that best matches the phrase or definition. - The easiest way to move a picture on a form is to first remove the picture from the ____.

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.

Insert the letter of the choice that best matches the phrase or definition. - The button used to change the theme of a form from the default theme to another theme in Layout view.

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

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

Insert the letter of the choice that best matches the phrase or definition. - The view that gives the most detailed view of the structure of a form or report.

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

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 wildcard character that will match any character not within brackets.