Question 1

​ When you create a report with the _________, you first choose the table or query on which to base the report and then select the fields you want to include in the report. 
A)Report Wizard 
B)Report Creator 
C)Report Generator 
D)Report Architect

Accepted Answer

The answer of ​ When you create a report with...

Question 2

​ A _________ is a set of controls grouped together in a form or report so that you can manipulate the set as a single control. 
A)control layout 
B)control group 
C)control pane 
D)control form

Accepted Answer

The answer of ​ A _________ is a set of...

Question 3

​ In the _________ , the second dialog box lets you choose whether to show the data in the report grouped by table or ungrouped. 
A)Report Wizard 
B)Report Creator 
C)Report Generator 
D)Report Architect

Accepted Answer

The answer of ​ In the _________ , the second...

Question 4

Briefly discuss the steps involved in modifying a report's design in Layout view.

Accepted Answer

The answer of Briefly discuss the steps involved in modifying...

Question 5

​ In Microsoft Access 2016, while previewing a form, the Print screen in _________ has three options: Quick Print, Print, and Print Preview. 
A)Backstage view 
B)Master view 
C)Layout view 
D)Design view

Accepted Answer

The answer of ​ In Microsoft Access 2016, while previewing...

Question 6

​ The _________ wildcard character is used to match any character not within brackets. 
A)! 
B)# 
C)$ 
D)-

Accepted Answer

The answer of ​ The _________ wildcard character is used...

Question 7

​ A(n) _________ is a placeholder you use when you know only part of a value or when you want to start or end with a specific character or match a certain pattern. 
A)wildcard character 
B)keyword 
C)wild character keyset 
D)key character

Accepted Answer

The answer of ​ A(n) _________ is a placeholder you...

Question 8

​ You get a more detailed view of a form's structure in _________ than in Layout view. 
A)Design view 
B)Form view 
C)Tabular view 
D)Columnar view

Accepted Answer

The answer of ​ You get a more detailed view...

Question 9

​ Discuss the process of creating a form with a main form and a subform.

Accepted Answer

The answer of ​ Discuss the process of creating a...

Question 10

Explain the process of creating a report using the Report Wizard.

Accepted Answer

The answer of Explain the process of creating a report...

Question 11

​ When you point to a theme in the Themes gallery, a(n)_________ displays the names of the database objects that use the theme. 
A)ScreenTip 
B)Hint screen 
C)Information pane 
D)Suggestion Bar

Accepted Answer

The answer of ​ When you point to a theme...

Question 12

Unless the _________ check box is selected, Access will find any record containing the search text with any combination of uppercase and lowercase letters. 
A)Match Case 
B)Uppercase 
C)Lowercase 
D)Mirror Case

Accepted Answer

The answer of Unless the _________ check box is selected,...

Question 13

​ The _________ wildcard character is used to match any one of a range of characters. 
A)- 
B)# 
C)? 
D)$

Accepted Answer

The answer of ​ The _________ wildcard character is used...

Question 14

To create a form and a subform in Microsoft Access 2016, you use the _________. 
A)Form Wizard 
B)Form Creator 
C)Form Architect 
D)Form Generator

Accepted Answer

The answer of To create a form and a subform...

Quiz 19: Creating Forms and Reports

​ When you create a report with the _________, you first choose the table or query on which to base the report and then select the fields you want to include in the report. A)Report Wizard B)Report Creator C)Report Generator D)Report Architect

​ A _________ is a set of controls grouped together in a form or report so that you can manipulate the set as a single control. A)control layout B)control group C)control pane D)control form

​ In the _________ , the second dialog box lets you choose whether to show the data in the report grouped by table or ungrouped. A)Report Wizard B)Report Creator C)Report Generator D)Report Architect

Briefly discuss the steps involved in modifying a report's design in Layout view.

​ In Microsoft Access 2016, while previewing a form, the Print screen in _________ has three options: Quick Print, Print, and Print Preview. A)Backstage view B)Master view C)Layout view D)Design view

​ The _________ wildcard character is used to match any character not within brackets. A)! B)# C)$ D)-

​ A(n) _________ is a placeholder you use when you know only part of a value or when you want to start or end with a specific character or match a certain pattern. A)wildcard character B)keyword C)wild character keyset D)key character

​ You get a more detailed view of a form's structure in _________ than in Layout view. A)Design view B)Form view C)Tabular view D)Columnar view

​ Discuss the process of creating a form with a main form and a subform.

Explain the process of creating a report using the Report Wizard.

​ When you point to a theme in the Themes gallery, a(n)_________ displays the names of the database objects that use the theme. A)ScreenTip B)Hint screen C)Information pane D)Suggestion Bar

Unless the _________ check box is selected, Access will find any record containing the search text with any combination of uppercase and lowercase letters. A)Match Case B)Uppercase C)Lowercase D)Mirror Case

​ The _________ wildcard character is used to match any one of a range of characters. A)- B)# C)? D)$

To create a form and a subform in Microsoft Access 2016, you use the _________. A)Form Wizard B)Form Creator C)Form Architect D)Form Generator

When you create a report with the _________, you first choose the table or query on which to base the report and then select the fields you want to include in the report. A)Report Wizard B)Report Creator C)Report Generator D)Report Architect

A _________ is a set of controls grouped together in a form or report so that you can manipulate the set as a single control. A)control layout B)control group C)control pane D)control form

In the _________ , the second dialog box lets you choose whether to show the data in the report grouped by table or ungrouped. A)Report Wizard B)Report Creator C)Report Generator D)Report Architect

In Microsoft Access 2016, while previewing a form, the Print screen in _________ has three options: Quick Print, Print, and Print Preview. A)Backstage view B)Master view C)Layout view D)Design view

The _________ wildcard character is used to match any character not within brackets. A)! B)# C)$ D)-

A(n) _________ is a placeholder you use when you know only part of a value or when you want to start or end with a specific character or match a certain pattern. A)wildcard character B)keyword C)wild character keyset D)key character

You get a more detailed view of a form's structure in _________ than in Layout view. A)Design view B)Form view C)Tabular view D)Columnar view

Discuss the process of creating a form with a main form and a subform.

When you point to a theme in the Themes gallery, a(n)_________ displays the names of the database objects that use the theme. A)ScreenTip B)Hint screen C)Information pane D)Suggestion Bar

The _________ wildcard character is used to match any one of a range of characters. A)- B)# C)? D)$