Question 1

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

Accepted Answer

Answers will vary. When creating a form

Question 2

​ The _________ creates a form automatically, using all the fields in the selected table or query. 
A)Form tool 
B)Form Layout 
C)Form Workbook 
D)Form Table

Accepted Answer

The answer of ​ The _________ creates a form automatically,...

Question 3

​ The navigation buttons at the bottom of a subform select records from the primary table in a main form.

Accepted Answer

A) True 
 B)False

Question 4

​ In the accompanying figure of Microsoft Access 2014, Box A points to the _____.

Accepted Answer

A) subform record navigation bar 
B) linked form record in the taskbar 
C) unpinned form record in the taskbar 
D) main form record navigation bar 
A) subform record navigation bar 
B) linked form record in the taskbar 
C) unpinned form record in the taskbar 
D) main form record navigation bar

Question 5

​ 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 should Cindy use to find the term "Masters" in the report?

Accepted Answer

A) Mast* 
B) M? 
C) [M_____S] 
D) %Masters% 
A) Mast* 
B) M? 
C) [M_____S] 
D) %Masters%

Question 6

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

Accepted Answer

A) query 
B) table 
C) field 
D) layout 
A) query 
B) table 
C) field 
D) layout

Question 7

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

Accepted Answer

A)  layout of data in linked form 
B) order in which data will be displayed 
C) data extracted from a main form 
D)  title for the subform 
A)  layout of data in linked form 
B) order in which data will be displayed 
C) data extracted from a main form 
D)  title for the subform

Question 8

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

​ The accompanying figure of a Report Wizard in Microsoft Access 2016 shows two tables, Clients and Agreements. Here, the data in the report is _____.

Accepted Answer

A) grouped by table 
B) left-oriented in the tables 
C) ungrouped by table 
D) right-oriented in the tables 
A) grouped by table 
B) left-oriented in the tables 
C) ungrouped by table 
D) right-oriented in the tables

Question 10

While finding data using a Microsoft Access 2016 form, an entire field matches a search text by default unless you change the option in the Match box of the Find and Replace box to _____. ​

Accepted Answer

A) Any Part of Field 
B) Current Field 
C) Last Part of Field 
D) Partial Field 
A) Any Part of Field 
B) Current Field 
C) Last Part of Field 
D) Partial Field

Question 11

​ A wildcard is an item in a form, report, or other database object that you can manipulate to modify an object's appearance.

Accepted Answer

A) True 
 B)False

Question 12

​ In Microsoft Access 2016, you must select a field _____ , and not the field label , before applying a conditional format in a report.

Accepted Answer

A) value box 
B) title box 
C) theme 
D) address 
A) value box 
B) title box 
C) theme 
D) address

Question 13

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

Question 14

​ Previewing a form using Print Preview before printing it lets you _____.

Accepted Answer

A) see how it will look when printed 
B) delete overlapping data when printed 
C) merge duplicate form records during the print process 
D) change the font and theme of the records during the print process 
A) see how it will look when printed 
B) delete overlapping data when printed 
C) merge duplicate form records during the print process 
D) change the font and theme of the records during the print process

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

The _________ creates a form automatically, using all the fields in the selected table or query. A)Form tool B)Form Layout C)Form Workbook D)Form Table

The navigation buttons at the bottom of a subform select records from the primary table in a main form.

In the accompanying figure of Microsoft Access 2014, Box A points to the _____.

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

In the accompanying figure of Microsoft Access 2016, Box A points to the _____.

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

The accompanying figure of a Report Wizard in Microsoft Access 2016 shows two tables, Clients and Agreements. Here, the data in the report is _____.

While finding data using a Microsoft Access 2016 form, an entire field matches a search text by default unless you change the option in the Match box of the Find and Replace box to _____.

A wildcard is an item in a form, report, or other database object that you can manipulate to modify an object's appearance.

In Microsoft Access 2016, you must select a field _____ , and not the field label , before applying a conditional format in a report.

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

Previewing a form using Print Preview before printing it lets you _____.

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