Exam 19: Creating Forms and Reports

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

Free

(Short Answer)

4.8/5

(38)

Question 1

Correct Answer:

Verified

Match Case

If you need to improve a form's appearance or to make the form easier to use, you need to switch to _________. A)Layout view B)Form view C)Tabular view D)Columnar view

Free

(Short Answer)

4.8/5

(31)

Question 2

Correct Answer:

Verified

Layout view

In Print Preview, each form record appears in its own form, and _____ distinguishes one record from the next.

Free

(Multiple Choice)

5.0/5

(34)

Question 3

Correct Answer:

Verified

The accompanying figure of Microsoft Access 2016 shows a ClientInfo form in Form view after clicking the New button in the _____ group on the Home tab.

(Multiple Choice)

4.7/5

(40)

Question 4

In the context of creating a form with a main form and a subform, y ou can _____ a field to move it between the box and the Selected Fields box.

(Multiple Choice)

4.9/5

(45)

Question 5

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

(Short Answer)

4.8/5

(36)

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. Cindy has to list all the article titles published in 2015. Which of the following wildcard searches should Cindy use to find the fields with values ending with"2015" in the report?

(Multiple Choice)

4.9/5

(47)

Question 7

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

(Short Answer)

4.8/5

(40)

Question 8

Podcasts can be used when one searches for text with the Find and Replace dialog box, instead of entering an exact value to find.

(True/False)

4.7/5

(31)

Question 9

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 forms in Microsoft Access 2016 to display data from two or more related tables at the same time. This offers a complete picture of the information in the patient database. If Linda has to create a form based on two tables labeled Patient Identity and Patient Illness, the two tables should have _____.

(Multiple Choice)

4.8/5

(32)

Question 10

The main form name appears on the status bar and as the form summary.

(True/False)

4.8/5

(39)

Question 11

A form with a main form and a subform includes two sets of navigation buttons. The navigation buttons at the bottom of the subform select records from the _____.

(Multiple Choice)

4.9/5

(33)

Question 12

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

(Short Answer)

4.8/5

(30)

Question 13

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 Microsoft Access 2016 to maintain the records of each patient. She wants to list the patients' names whose name start with "e" and end with "y" and contain four letters. Which of the following wildcard characters should Linda use for this search?

(Multiple Choice)

4.8/5

(38)

Question 14

In Microsoft Access 2016, when using a _____ to create a report, you can choose which fields to display from tables and queries as well as how to group and sort the records in the report, the page orientation, and the report's title.

(Multiple Choice)

4.9/5

(38)

Question 15

Using the Report Wizard in Microsoft Access 2016, Tara creates a sales report for the last financial year for her company. She wants to format certain fields, such as sales amounts greater than or equal to $50,000, in a bold, black font. Which of the following types of formatting should Tara use to accomplish this?

(Multiple Choice)

4.9/5

(35)

Question 16

Subforms display data from the primary table.

(True/False)

4.9/5

(42)

Question 17

In the accompanying figure of Microsoft Access 2016, if Box A points to the primary table and Box B points to the related table, then Box C points to the _____.

(Multiple Choice)

4.8/5

(44)

Question 18

Forms are originally formatted with the dataset theme.

(True/False)

4.8/5

(41)

Question 19

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 data from the Patient Identity table and the Patient Illness table to create an annual report using Microsoft Access 2016. The form includes data from the primary table and the related table. If Linda defines the Patient Identity table as the primary table, then the part of the form that displays data from this primary table in the defined relationship is referred to as the _____.

(Multiple Choice)

5.0/5

(43)

Question 20

Showing 1 - 20 of 74

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

If you need to improve a form's appearance or to make the form easier to use, you need to switch to _________. A)Layout view B)Form view C)Tabular view D)Columnar view

In Print Preview, each form record appears in its own form, and _____ distinguishes one record from the next.

The accompanying figure of Microsoft Access 2016 shows a ClientInfo form in Form view after clicking the New button in the _____ group on the Home tab.

In the context of creating a form with a main form and a subform, y ou can _____ a field to move it between the box and the Selected Fields box.

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

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

Podcasts can be used when one searches for text with the Find and Replace dialog box, instead of entering an exact value to find.

The main form name appears on the status bar and as the form summary.

A form with a main form and a subform includes two sets of navigation buttons. The navigation buttons at the bottom of the subform select records from the _____.

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

In Microsoft Access 2016, when using a _____ to create a report, you can choose which fields to display from tables and queries as well as how to group and sort the records in the report, the page orientation, and the report's title.

Subforms display data from the primary table.

In the accompanying figure of Microsoft Access 2016, if Box A points to the primary table and Box B points to the related table, then Box C points to the _____.

Forms are originally formatted with the dataset theme.

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

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

If you need to improve a form's appearance or to make the form easier to use, you need to switch to _________. A)Layout view B)Form view C)Tabular view D)Columnar view

In Print Preview, each form record appears in its own form, and _____ distinguishes one record from the next. ​

​ The accompanying figure of Microsoft Access 2016 shows a ClientInfo form in Form view after clicking the New button in the _____ group on the Home tab.

​ In the context of creating a form with a main form and a subform, y ou can _____ a field to move it between the box and the Selected Fields box.

​ 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

​ 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

Podcasts can be used when one searches for text with the Find and Replace dialog box, instead of entering an exact value to find. ​

​ The main form name appears on the status bar and as the form summary.

​ A form with a main form and a subform includes two sets of navigation buttons. The navigation buttons at the bottom of the subform select records from the _____.

​ 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

​ In Microsoft Access 2016, when using a _____ to create a report, you can choose which fields to display from tables and queries as well as how to group and sort the records in the report, the page orientation, and the report's title.

​ Subforms display data from the primary table.

In the accompanying figure of Microsoft Access 2016, if Box A points to the primary table and Box B points to the related table, then Box C points to the _____. ​ ​

Forms are originally formatted with the dataset theme.

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 Print Preview, each form record appears in its own form, and _____ distinguishes one record from the next.

The accompanying figure of Microsoft Access 2016 shows a ClientInfo form in Form view after clicking the New button in the _____ group on the Home tab.

In the context of creating a form with a main form and a subform, y ou can _____ a field to move it between the box and the Selected Fields box.

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

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

Podcasts can be used when one searches for text with the Find and Replace dialog box, instead of entering an exact value to find.

The main form name appears on the status bar and as the form summary.

A form with a main form and a subform includes two sets of navigation buttons. The navigation buttons at the bottom of the subform select records from the _____.

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

In Microsoft Access 2016, when using a _____ to create a report, you can choose which fields to display from tables and queries as well as how to group and sort the records in the report, the page orientation, and the report's title.

Subforms display data from the primary table.

In the accompanying figure of Microsoft Access 2016, if Box A points to the primary table and Box B points to the related table, then Box C points to the _____.