Exam 19: Creating Forms and Reports

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. Harry wants to apply a theme to the form. However, he observes that the form is already in _____ theme by default.

(Multiple Choice)

4.9/5

(32)

Question 21

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

(Short Answer)

4.9/5

(39)

Question 22

You can check the overall layout of a report, as well as zoom in to read the text, in the Navigation Wizard when previewing a report.

(True/False)

4.9/5

(33)

Question 23

Which of the following is the first step while creating a form based on two tables?

(Multiple Choice)

4.8/5

(35)

Question 24

The ^ wildcard character matches any character not within brackets.

(True/False)

4.9/5

(48)

Question 25

Microsoft Access 2016 displays only the table name for a subform, but uses the complete object name in the _____.

(Multiple Choice)

4.9/5

(35)

Question 26

The accompanying figure of Microsoft Access 2016 consists of the Clients table as the primary table and the Agreements table as the related table. Here, Box A points to the _____.

(Multiple Choice)

4.9/5

(30)

Question 27

Yolinda wants to print a sales report she has created using the Report Wizard. Before printing, she wants to check the overall layout of the report, as well as zoom in to read the text. Yolinda should use the _____ option for this purpose.

(Multiple Choice)

5.0/5

(28)

Question 28

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

(Short Answer)

4.8/5

(36)

Question 29

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

(Short Answer)

4.9/5

(34)

Question 30

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

(Multiple Choice)

4.8/5

(36)

Question 31

The * wildcard character will match only alphabetic characters.

(True/False)

4.9/5

(27)

Question 32

The dialog box shown in the accompanying figureof the Report Wizard of Microsoft Access 2016 lets you _____ .

(Multiple Choice)

4.9/5

(38)

Question 33

In the accompanying figure of a Conditional Formatting Rules Manager dialog box in Microsoft Access 2016, Box A points to the _____.

(Multiple Choice)

4.8/5

(39)

Question 34

In Microsoft Access 2016, while modifying a report's design in Layout view, you can resize and reposition labels and fields to _____.

(Multiple Choice)

4.9/5

(35)

Question 35

To select and resize multiple fields in a report, you press the Tab key as you select the different fields.

(True/False)

4.8/5

(39)

Question 36

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. Harry clicks the Themes button in the Themes group on the Form Layout Tools Design tab. After Harry right-clicks the Facet theme in the Themes gallery, he notices that a shortcut menu appears with options for _____.

(Multiple Choice)

4.9/5

(43)

Question 37

Identify a true statement about creating reports using the Report Wizard of Microsoft Access 2016.

(Multiple Choice)

4.8/5

(38)

Question 38

Tony uses the Report Wizard to create a Biology research project report. He needs to select fields from two tables labeled "Organisms," which is the primary table, and "Mortality," which is the related table. Which of the following is true is this scenario?

(Multiple Choice)

4.8/5

(32)

Question 39

In the Form Wizard, the _____ layouts display the fields from multiple records at one time.

(Multiple Choice)

4.8/5

(44)

Question 40

Showing 21 - 40 of 74

Exam 19: Creating Forms and Reports

​ 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. Harry wants to apply a theme to the form. However, he observes that the form is already in _____ theme by default.

​ 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

​ You can check the overall layout of a report, as well as zoom in to read the text, in the Navigation Wizard when previewing a report.

​ Which of the following is the first step while creating a form based on two tables?

​ The ^ wildcard character matches any character not within brackets.

Microsoft Access 2016 displays only the table name for a subform, but uses the complete object name in the _____. ​

​ The accompanying figure of Microsoft Access 2016 consists of the Clients table as the primary table and the Agreements table as the related table. Here, Box A points to the _____.

​ Yolinda wants to print a sales report she has created using the Report Wizard. Before printing, she wants to check the overall layout of the report, as well as zoom in to read the text. Yolinda should use the _____ option for this purpose.

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

​ 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 the accompanying figure of Microsoft Access 2016, Box A points to the _____.

The * wildcard character will match only alphabetic characters.

​ The dialog box shown in the accompanying figureof the Report Wizard of Microsoft Access 2016 lets you _____ .

​ In the accompanying figure of a Conditional Formatting Rules Manager dialog box in Microsoft Access 2016, Box A points to the _____.

​ In Microsoft Access 2016, while modifying a report's design in Layout view, you can resize and reposition labels and fields to _____.

​ To select and resize multiple fields in a report, you press the Tab key as you select the different fields.

​ Identify a true statement about creating reports using the Report Wizard of Microsoft Access 2016.

Tony uses the Report Wizard to create a Biology research project report. He needs to select fields from two tables labeled "Organisms," which is the primary table, and "Mortality," which is the related table. Which of the following is true is this scenario? ​

In the Form Wizard, the _____ layouts display the fields from multiple records at one time. ​

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

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. Harry wants to apply a theme to the form. However, he observes that the form is already in _____ theme by default.

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

You can check the overall layout of a report, as well as zoom in to read the text, in the Navigation Wizard when previewing a report.

Which of the following is the first step while creating a form based on two tables?

The ^ wildcard character matches any character not within brackets.

Microsoft Access 2016 displays only the table name for a subform, but uses the complete object name in the _____.

The accompanying figure of Microsoft Access 2016 consists of the Clients table as the primary table and the Agreements table as the related table. Here, Box A points to the _____.

Yolinda wants to print a sales report she has created using the Report Wizard. Before printing, she wants to check the overall layout of the report, as well as zoom in to read the text. Yolinda should use the _____ option for this purpose.

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

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 the accompanying figure of Microsoft Access 2016, Box A points to the _____.

The dialog box shown in the accompanying figureof the Report Wizard of Microsoft Access 2016 lets you _____ .

In the accompanying figure of a Conditional Formatting Rules Manager dialog box in Microsoft Access 2016, Box A points to the _____.

In Microsoft Access 2016, while modifying a report's design in Layout view, you can resize and reposition labels and fields to _____.

To select and resize multiple fields in a report, you press the Tab key as you select the different fields.

Identify a true statement about creating reports using the Report Wizard of Microsoft Access 2016.

Tony uses the Report Wizard to create a Biology research project report. He needs to select fields from two tables labeled "Organisms," which is the primary table, and "Mortality," which is the related table. Which of the following is true is this scenario?

In the Form Wizard, the _____ layouts display the fields from multiple records at one time.