Question 1

​ In the Report Wizard of Microsoft Access 2016, the second dialog box lets you _____.

Accepted Answer

A) choose grouping levels to add to the report 
B) add fields from only one table in each report 
C) pin the reports to the taskbar 
D) access and retrieve Web pages from reports 
A) choose grouping levels to add to the report 
B) add fields from only one table in each report 
C) pin the reports to the taskbar 
D) access and retrieve Web pages from reports

Question 2

​ You can modify a report's design in Layout view.

Accepted Answer

A) True 
 B)False

Question 3

​ The field value boxes are made up of _____lines, which, depending on the theme, might overshadow the field values and make them difficult to read.

Accepted Answer

A) broken 
B) dashed 
C) dotted 
D) solid 
A) broken 
B) dashed 
C) dotted 
D) solid

Question 4

In a(n) _____, only the main form fields are displayed, and a button with the subform's name on it appears on the main form. ​

Accepted Answer

A) pinned form 
B) endnote form 
C) primary form 
D) linked form 
A) pinned form 
B) endnote form 
C) primary form 
D) linked form

Question 5

​ In Microsoft Access 2016, when you click the Themes button in the Themes group on the Form Layout Tools Design tab, the Themes gallery appears, _____.

Accepted Answer

A) showing the available themes for the form 
B) showing the recently used themes for other forms 
C) asking you to create a new theme 
D) asking you to modify the default theme 
A) showing the available themes for the form 
B) showing the recently used themes for other forms 
C) asking you to create a new theme 
D) asking you to modify the default theme

Question 6

Case 19-2 Cindy, an intern at a publishing house, has to use Microsoft Access 2016 to prepare forms and database reports for all the outgoing articles in that particular month. Since the records are huge, Cindy uses wildcard characters to perform searches in the report.
Which of the following wildcard searches will enable Cindy to find the term "Filler" in the report?

Accepted Answer

A) F_ller 
B) F[aeiu]ller 
C) F#ller 
D) F?a?e?i?ller 
A) F_ller 
B) F[aeiu]ller 
C) F#ller 
D) F?a?e?i?ller

Question 7

In the accompanying figure of a Microsoft Access 2016 Form Wizard dialog box, Box A points to the _____. ​
  ​

Accepted Answer

A) selected tables 
B) available fields 
C) selected fields 
D) available tables 
A) selected tables 
B) available fields 
C) selected fields 
D) available tables

Question 8

While finding data using a form, performing a(n) _____ search is often easier than matching the entire field value.

Accepted Answer

A) partial 
B) full-text 
C) enhanced 
D) query 
A) partial 
B) full-text 
C) enhanced 
D) query

Question 9

​ Case 19-1 Harry is creating a form using Microsoft Access 2016. He wants to use different colors and fonts to modify the look of the form.
In the accompany figure of Harry's form, Box A points to _____.
​

Accepted Answer

A) form header 
B) form title 
C) form caption 
D) form label 
A) form header 
B) form title 
C) form caption 
D) form label

Question 10

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

Accepted Answer

Answers will vary. When you create a rep

Question 11

Danny wants to print a form from a set of records in Microsoft Access 2016. He selects the records and clicks the Print button in the Print group on the Print Preview tab, which opens the Print Dialog box. Here, Danny notices that the option to _____ does not exist. ​

Accepted Answer

A) print only selected records 
B) print all records 
C) print specified page numbers 
D) print selected number of copies 
A) print only selected records 
B) print all records 
C) print specified page numbers 
D) print selected number of copies

Question 12

​ Zain, an administrator at PerfDot Inc., creates a form using Microsoft Access 2016Form Wizard. He wants to make to change the font type, font size, and font color of the labels in the form. Which of the following views should Zain use for this purpose?

Accepted Answer

A) Layout view 
B) Form view 
C) Modify view 
D) Data view 
A) Layout view 
B) Form view 
C) Modify view 
D) Data view

Question 13

​ 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 14

​ A form's current title can be edited or replaced to make the form's purpose clearer.

Accepted Answer

A) True 
 B)False

Question 15

Case 19-3 Linda has recently started her job as a nursing supervisor at Hankons Cancer Treatment Centre. As part of the job, she has to look into the database of all the currently admitted patients and their ongoing treatment status.
Linda uses the data obtained to create a form, in Microsoft Access 2016, with a main form titled "Identity" and a subform titled "Illness." She notices that this form includes two sets of navigation buttons. If Linda enters data in the main form "Identity," the _____ table is updated.

Accepted Answer

A) allied 
B) primary 
C) related 
D) foreign 
A) allied 
B) primary 
C) related 
D) foreign

Question 16

​ 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 17

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

Accepted Answer

Answers will vary. You modify a report's

Question 18

In the accompanying figure of Microsoft Access 2016, the dotted line that Box A points to indicates that the _____. ​ ​

Accepted Answer

A) control layout is removed 
B) control layout is selected 
C) control panel is divided into two regions 
D) control panel is shared with other forms 
A) control layout is removed 
B) control layout is selected 
C) control panel is divided into two regions 
D) control panel is shared with other forms

Question 19

​ The Record Module Creator guides you through the process of creating a report and lets you choose which fields to display from tables and queries.

Accepted Answer

A) True 
 B)False

Question 20

​ The controls you add and modify in Layout view are available on the Form Layout Tools Design tab in the Controls group and the _____ group.

Accepted Answer

A) Show/Hide 
B) Header/Footer 
C) Dependency 
D) Relationship 
A) Show/Hide 
B) Header/Footer 
C) Dependency 
D) Relationship

In the Report Wizard of Microsoft Access 2016, the second dialog box lets you _____.

You can modify a report's design in Layout view.

The field value boxes are made up of _____lines, which, depending on the theme, might overshadow the field values and make them difficult to read.

In a(n) _____, only the main form fields are displayed, and a button with the subform's name on it appears on the main form.

In Microsoft Access 2016, when you click the Themes button in the Themes group on the Form Layout Tools Design tab, the Themes gallery appears, _____.

In the accompanying figure of a Microsoft Access 2016 Form Wizard dialog box, Box A points to the _____.

While finding data using a form, performing a(n) _____ search is often easier than matching the entire field value.

Case 19-1 Harry is creating a form using Microsoft Access 2016. He wants to use different colors and fonts to modify the look of the form. In the accompany figure of Harry's form, Box A points to _____.

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

Danny wants to print a form from a set of records in Microsoft Access 2016. He selects the records and clicks the Print button in the Print group on the Print Preview tab, which opens the Print Dialog box. Here, Danny notices that the option to _____ does not exist.

Zain, an administrator at PerfDot Inc., creates a form using Microsoft Access 2016Form Wizard. He wants to make to change the font type, font size, and font color of the labels in the form. Which of the following views should Zain use for this purpose?

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

A form's current title can be edited or replaced to make the form's purpose clearer.

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

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

In the accompanying figure of Microsoft Access 2016, the dotted line that Box A points to indicates that the _____.

The Record Module Creator guides you through the process of creating a report and lets you choose which fields to display from tables and queries.

The controls you add and modify in Layout view are available on the Form Layout Tools Design tab in the Controls group and the _____ group.

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Creating a Workbook

Working With Formulas and Functions

Creating an Advanced Workbook

Inserting and Formatting Charts

Creating a Database

Maintaining and Querying a Database

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

Exam 19: Creating Forms and Reports

​ In the Report Wizard of Microsoft Access 2016, the second dialog box lets you _____.

​ You can modify a report's design in Layout view.

​ The field value boxes are made up of _____lines, which, depending on the theme, might overshadow the field values and make them difficult to read.

In a(n) _____, only the main form fields are displayed, and a button with the subform's name on it appears on the main form. ​

​ In Microsoft Access 2016, when you click the Themes button in the Themes group on the Form Layout Tools Design tab, the Themes gallery appears, _____.

In the accompanying figure of a Microsoft Access 2016 Form Wizard dialog box, Box A points to the _____. ​ ​

While finding data using a form, performing a(n) _____ search is often easier than matching the entire field value.

​ Case 19-1 Harry is creating a form using Microsoft Access 2016. He wants to use different colors and fonts to modify the look of the form. In the accompany figure of Harry's form, Box A points to _____. ​

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

Danny wants to print a form from a set of records in Microsoft Access 2016. He selects the records and clicks the Print button in the Print group on the Print Preview tab, which opens the Print Dialog box. Here, Danny notices that the option to _____ does not exist. ​

​ Zain, an administrator at PerfDot Inc., creates a form using Microsoft Access 2016Form Wizard. He wants to make to change the font type, font size, and font color of the labels in the form. Which of the following views should Zain use for this purpose?

​ 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

​ A form's current title can be edited or replaced to make the form's purpose clearer.

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

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

In the accompanying figure of Microsoft Access 2016, the dotted line that Box A points to indicates that the _____. ​ ​

​ The Record Module Creator guides you through the process of creating a report and lets you choose which fields to display from tables and queries.

​ The controls you add and modify in Layout view are available on the Form Layout Tools Design tab in the Controls group and the _____ group.

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Creating a Workbook

Working With Formulas and Functions

Creating an Advanced Workbook

Inserting and Formatting Charts

Creating a Database

Maintaining and Querying a Database

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

In the Report Wizard of Microsoft Access 2016, the second dialog box lets you _____.

You can modify a report's design in Layout view.

The field value boxes are made up of _____lines, which, depending on the theme, might overshadow the field values and make them difficult to read.

In a(n) _____, only the main form fields are displayed, and a button with the subform's name on it appears on the main form.

In Microsoft Access 2016, when you click the Themes button in the Themes group on the Form Layout Tools Design tab, the Themes gallery appears, _____.

In the accompanying figure of a Microsoft Access 2016 Form Wizard dialog box, Box A points to the _____.

Case 19-1 Harry is creating a form using Microsoft Access 2016. He wants to use different colors and fonts to modify the look of the form. In the accompany figure of Harry's form, Box A points to _____.

Danny wants to print a form from a set of records in Microsoft Access 2016. He selects the records and clicks the Print button in the Print group on the Print Preview tab, which opens the Print Dialog box. Here, Danny notices that the option to _____ does not exist.

Zain, an administrator at PerfDot Inc., creates a form using Microsoft Access 2016Form Wizard. He wants to make to change the font type, font size, and font color of the labels in the form. Which of the following views should Zain use for this purpose?

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

A form's current title can be edited or replaced to make the form's purpose clearer.

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

In the accompanying figure of Microsoft Access 2016, the dotted line that Box A points to indicates that the _____.

The Record Module Creator guides you through the process of creating a report and lets you choose which fields to display from tables and queries.

The controls you add and modify in Layout view are available on the Form Layout Tools Design tab in the Controls group and the _____ group.