Exam 5: Creating and Modifying Reports

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie realizes he needs to change the width of the report. When resizing a control in ____ view, Eddie uses the outline of the control and drags it with the pointer to see the actual width of the control.

(Multiple Choice)

4.8/5

(43)

Question 41

To create labels, select the record source in the ____, click the Create tab on the Ribbon, and then click the Labels button in the Reports group on the Create tab.

(Multiple Choice)

4.9/5

(35)

Question 42

The ____________________ creates a simple report that includes all the fields in the selected table or query, uses a simple columnar format, and includes a title with the same name as the record source.

(Short Answer)

4.8/5

(33)

Question 43

You can add new controls to a report by using the tools in the Query group.

(True/False)

4.7/5

(32)

Question 44

A(n) ____________________ organizes data based on one or more fields.

(Short Answer)

4.8/5

(35)

Question 45

When you close a report in Print Preview, Access displays the report in Design view.

(True/False)

4.9/5

(31)

Question 46

Showing 41 - 46 of 46

Exam 5: Creating and Modifying Reports

To create labels, select the record source in the ____, click the Create tab on the Ribbon, and then click the Labels button in the Reports group on the Create tab.

The ____________________ creates a simple report that includes all the fields in the selected table or query, uses a simple columnar format, and includes a title with the same name as the record source.

You can add new controls to a report by using the tools in the Query group.

A(n) ____________________ organizes data based on one or more fields.

When you close a report in Print Preview, Access displays the report in Design view.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters