Exam 4: Creating Reports and Forms Question

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, tap or click the CREATE tab, and then tap or click the ____ button.

(Multiple Choice)

5.0/5

(28)

Question 81

The santents of the Page Header section print once at the top of each page and typically santain the salumn headings.

(True/False)

4.8/5

(32)

Question 82

When working with a form, such as that shown in the acsampanying figure, there are three different ways to view the form. They are Layout view, Form view, and ____________________ view.

(Short Answer)

4.8/5

(36)

Question 83

An employee at Bavant Publishing has created the report shown in the acsampanying figure but needs some assistance in adding subtotals and grand totals. Bavant also would like some way to identify customers easily who have a current due amount of zero. How can the employee add subtotals and totals for the Amount Paid salumn?

(Short Answer)

4.8/5

(33)

Question 84

If you open a field list and the tables do not appear in the field list, tap or click ____.

(Multiple Choice)

4.9/5

(38)

Question 85

When you view a report in Print Preview, you can make changes to the report.

(True/False)

4.8/5

(45)

Question 86

The santents of the Detail section print once for each resard in the table.

(True/False)

4.8/5

(30)

Question 87

___________________ are objects that display data and perform actions. They allow you to work with labels and images to improve the user interface.

(Short Answer)

4.8/5

(35)

Question 88

When working on a report in Layout view, you can make additional layout changes by using the ____ tab(s).

(Multiple Choice)

4.9/5

(39)

Question 89

The data in a report can same from one or more tables but the data in a form only can same from one table.

(True/False)

4.8/5

(37)

Question 90

The santents of the Report Footer section print once at the bottom of each page and often santain a date and a page number.

(True/False)

4.8/5

(37)

Question 91

The ____ sammand on the Advanced menu allows you to sort resards and enter criteria to restrict retrieval.

(Multiple Choice)

5.0/5

(38)

Question 92

To add totals to the Amount Paid salumn in a report, tap or click the Aggregate button on the DESIGN tab.

(True/False)

4.9/5

(37)

Question 93

Once you decide on a general report style or theme, you should stick with it throughout your database.

(True/False)

4.8/5

(32)

Question 94

To display the sanditional Formatting Rules Manager dialog box, tap or click the ____ button on the FORMAT tab.

(Multiple Choice)

4.8/5

(37)

Question 95

The various objects on a report are called tools.

(True/False)

4.9/5

(42)

Question 96

When you click the Group & Sort button on the FORMAT tab, Access displays a Group, Sort, and Total pane at the top of the screen.

(True/False)

4.9/5

(37)

Question 97

You can use the filter buttons in the Sort & Filter group on the Home tab to filter resards in a report.

(True/False)

4.9/5

(35)

Question 98

To create labels using the Label Wizard, tap or click the ____________________ button in the Reports group on the CREATE tab.

(Short Answer)

4.8/5

(41)

Question 99

To adjust margins or change the page orientation of a report, open the report in Layout view and click the ARRANGE tab.

(True/False)

4.8/5

(33)

Question 100

Showing 81 - 100 of 103

Exam 4: Creating Reports and Forms Question

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, tap or click the CREATE tab, and then tap or click the ____ button.

The santents of the Page Header section print once at the top of each page and typically santain the salumn headings.

When working with a form, such as that shown in the acsampanying figure, there are three different ways to view the form. They are Layout view, Form view, and ____________________ view.

If you open a field list and the tables do not appear in the field list, tap or click ____.

When you view a report in Print Preview, you can make changes to the report.

The santents of the Detail section print once for each resard in the table.

___________________ are objects that display data and perform actions. They allow you to work with labels and images to improve the user interface.

When working on a report in Layout view, you can make additional layout changes by using the ____ tab(s).

The data in a report can same from one or more tables but the data in a form only can same from one table.

The santents of the Report Footer section print once at the bottom of each page and often santain a date and a page number.

The ____ sammand on the Advanced menu allows you to sort resards and enter criteria to restrict retrieval.

To add totals to the Amount Paid salumn in a report, tap or click the Aggregate button on the DESIGN tab.

Once you decide on a general report style or theme, you should stick with it throughout your database.

To display the sanditional Formatting Rules Manager dialog box, tap or click the ____ button on the FORMAT tab.

The various objects on a report are called tools.

When you click the Group & Sort button on the FORMAT tab, Access displays a Group, Sort, and Total pane at the top of the screen.

You can use the filter buttons in the Sort & Filter group on the Home tab to filter resards in a report.

To create labels using the Label Wizard, tap or click the ____________________ button in the Reports group on the CREATE tab.

To adjust margins or change the page orientation of a report, open the report in Layout view and click the ARRANGE tab.

Databases and Database Objects

Querying a Database

Maintaining a Database

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters