9780789546494

Microsoft Word 2000

PROJECT 4

Creating A Document with A Table, Chart, and Watermark

Objectives

(3)

Introduction

(1)

Project Four - Sales Proposal

(3)

Starting Word

(1)

Resetting Menus and Toolbars

(1)

Zooming Text Width

(1)

Displaying Formatting Marks

(1)

Creating A Title Page

(12)

Formatting and Entering Characters

(1)

Adding an Outside Border in Color with Shading

(4)

Inserting Clip Art from the Web into a Word Document

(4)

Entering and Formatting the Company Slogan

(2)

Centering the Title Page Text Vertically on the Page

(1)

Saving the Title Page

(1)

Inserting an Existing Document into an Open Document

(9)

Inserting a Section Break

(3)

Inserting a Word Document into an Open Document

(2)

Saving the Active Document with a New File Name

(1)

Printing Certain Pages in a Document

(3)

Creating a Header Different from the Previous Header

(3)

Changing the Starting Page Number in a Section

(2)

Charting a Table

(10)

Changing Line Spacing

(2)

Creating a Chart from a Word Table

(2)

Changing the Chart in Graph

(3)

Formatting the Chart in Word

(2)

Customizing Bullets in a List

(1)

Creating a Table Using the Draw Table Feature

(13)

Drawing a Table

(7)

Entering Data into the Table

(1)

Formatting the Table

(3)

Working with Tables

(1)

Creating a Watermark

(4)

Checking Spelling, Saving Again, and Printing the Sales Proposal

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(7)

Cases and Places

PROJECT 5

Generating Form Letters, Mailing Labels, and Envelopes

Objectives

(3)

Introduction

(1)

Project Five - Form Letters, Mailing Labels, and Envelopes

(2)

Using a Template to Create a Letter

(7)

Resetting Menus and Toolbars

(1)

Zooming Text Width

(1)

Displaying Formatting Marks

(1)

Selecting and Replacing Template Placeholder Text

(4)

Identifying the Main Document and Creating the Data Source

(13)

Identifying the Main Document

(2)

Creating a Data Source

(7)

Editing Records in the Data Source

(1)

Printing a Document in Landscape Orientation

(1)

Switching from the Data Source to the Main Document

(1)

Entering the Main Document for the Form Letter

(15)

Inserting Merge Fields into the Main Document

(2)

Unlinking a Field

(1)

Entering the Body of a Letter Template

(1)

Creating an Outline Numbered List

(3)

Using an IF Field to Conditionally Print Text in a Form Letter

(3)

Inserting a Fill-in Field

(2)

Saving the Document Again

(1)

Displaying Field Codes

(1)

Printing Field Codes

(2)

Merging the Documents and Printing the Letters

(6)

Selecting Data Records to Merge and Print

(3)

Sorting Data Records to Merge and Print

(1)

Viewing Merged Data

(1)

Addressing Mailing Labels

(7)

Saving the Mailing Labels

(1)

Addressing Envelopes

(4)

Saving the Envelopes

(1)

Closing All Open Files and Quitting Word

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(7)

Cases and Places

PROJECT 6

Creating a Professional Newsletter

Objectives

(3)

Introduction

(1)

Project Six - Newsletter

(4)

Desktop Publishing Terminology

(1)

Starting Word

(1)

Resetting Menus and Toolbars

(1)

Displaying Formatting Marks

(1)

Changing All Margin Settings

(1)

Zooming Text Width

(1)

Creating the Nameplate

(15)

Creating a WordArt Drawing Object

(2)

Formatting a Word Art Drawing Object

(2)

Changing the WordArt Shape

(2)

Adding Ruling Lines

(1)

Inserting the Current Date into a Document

(3)

Inserting a Floating Graphic

(4)

Formatting the First Page of the Body of the Newsletter

(16)

Formatting a Document into Multiple Columns

(2)

Justifying a Paragraph

(1)

Saving the Newsletter

(1)

Inserting the Remainder of the Feature Article

(1)

Formatting a Letter as a Dropped Capital

(1)

Inserting a Column Break

(4)

Applying a Style

(1)

Linking an Object into a Word Document

(3)

Adding a Vertical Rule Between Columns

(2)

Creating a Pull-Quote

(8)

Inserting a Text Box

(8)

Formatting the Second Page of the Newsletter

(9)

Creating the Nameplate on the Second Page

(3)

Balancing Columns

(1)

Positioning Graphics on the Page

(4)

Enhancing the Newsletter with Color and a Page Border

(6)

Using the Format Painter Button

(2)

Adding a Page Border

(1)

Highlighting Text

(2)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(3)

Cases and Places

INTERRATION FEATURE

Merging Form Letters to E-Mail Addresses Using an Access Table

Introduction

(2)

Unlinking a Field

(1)

Changing the Data Source in a Form Letter

(4)

Merging to E-Mail Addresses

(2)

Integration Feature Summary

(1)

In the Lab

Microsoft Excel 2000

PROJECT 4

Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks

Objectives

(3)

Introduction

(2)

Project Four - WeSavU National Bank Loan Analysis

(3)

Starting Excel and Resetting the Toolbars and Menus

(1)

Changing the Font Style of the Entire Worksheet

(1)

Entering the Section Title, Row Titles, and System Data

(2)

Outlining and Adding Borders

(3)

Formatting Cells Before Entering Values

(1)

Entering the Loan Data

(1)

Creating Cell Names Based on Row Titles

(7)

Determining the Loan Amount

(1)

Determining the Monthly Payment

(2)

Determining the Total Interest and Total Cost

(1)

Entering New Loan Data

(1)

Using a Data Table to Analyze Worksheet Data

(8)

Creating a Percent Series Using the Fill Handle

(2)

Entering the Formulas in the Data Table

(1)

Defining the Data Table

(2)

Formatting the Data Table

(1)

Adding an Input Value Pointer to the Data Table Using Conditional Formatting

(3)

Creating an Amortization Schedule

(12)

Changing Column Widths and Entering the Titles

(1)

Creating a Series of Integers Using the Fill Handle

(1)

Entering the Formulas in the Amortization Schedule

(5)

Entering the Total Formulas in the Amortization Schedule

(2)

Formatting New Loan Data

(2)

Entering New Loan Data

(1)

Adding a Hyperlink to the Worksheet

(7)

Assigning a Hyperlink to an Embedded Graphic

(3)

Displaying a Hyperlinked File

(2)

Protecting the Worksheet

(3)

Goal Seeking to Determine the Down Payment for a Specific Monthly Payment

(2)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(7)

Cases and Places

PROJECT 5

Creating, Sorting, and Querying A Worksheet Database

Objectives

(3)

Introduction

(1)

Project Five - SkateJam Sales Representative Database

(2)

Starting Excel and Resetting the Toolbars and Menus

(1)

Creating a Database

(6)

Setting Up a Database

(2)

Naming a Database

(1)

Entering Records into the Database Using a Data Form

(4)

Moving from Field to Field in a Data Form

(1)

Adding Computational Fields to the Database

(8)

Adding New Field Names and Determining the % of Quota

(2)

Using Excel's VLOOKUP Function to Determine Letter Grades

(3)

Redefining the Name Database

(3)

Guidelines to Follow When Creating a Database

(1)

Using a Data Form to View Records and Change Data

(1)

Printing a Database

(1)

Sorting a Database

(5)

Sorting the Database in Ascending Sequence by Last Name

(1)

Sorting a Database in Descending Sequence by Last Name

(1)

Returning a Database to Its Original Order

(1)

Sorting a Database on Multiple Fields

(2)

Sorting a Database on More than Three Fields

(1)

Displaying Automatic Subtotals in a Database

(5)

Zooming Out on a Worksheet and Hiding and Showing Detail Data in a Subtotaled Database

(1)

Removing Subtotals from the Database

(1)

Finding Records Using a Data Form

(3)

Using Wildcard Characters in Comparison Criteria

(1)

Using Computed Criteria

(1)

Filtering a Database Using AutoFilter

(5)

Removing AutoFilter

(1)

Entering Custom Criteria with AutoFilter

(2)

Using a Criteria Range on the Worksheet

(3)

Creating a Criteria Range on the Worksheet

(1)

Filtering a Database Using the Advanced Filter Command

(2)

Extracting Records

(2)

Creating an Extract Range and Extracting Records

(2)

More About Comparison Criteria

(2)

A Blank Row in the Criteria Range

(1)

Using Multiple Comparison Criteria with the Same Field

(1)

Comparison Criteria in Different Rows and Under Different Fields

(1)

Using Database Functions

(2)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(9)

Cases and Places

PROJECT 6

Creating Templates and Working with Multiple Worksheets and Workbooks

Objectives

(3)

Introduction

(2)

Project Six - Home Entertainment Systems Profit Potential

(1)

Starting Excel

(1)

Creating the Template

(9)

Bolding the Font and Changing the Column Widths of the Template

(1)

Entering the Template Title and Row Titles

(1)

Entering Column Titles and the System Date

(1)

Entering Dummy Data in the Template

(2)

The ROUND Function and Entering the Formulas in the Template

(4)

Saving the Template

(1)

Formatting the Template

(10)

Formatting the Template Title

(1)

Formatting the Column Titles and Total Line

(1)

Applying Number Formats Using the Format Dialog Box

(2)

Creating a Customized Format Code

(2)

Creating and Applying a Style

(3)

Applying a Style

(1)

Spell Checking, Saving, and Printing the Template

(1)

Alternative Uses of Templates

(1)

Creating a Workbook from a Template

(12)

Drilling an Entry Down Through Worksheets

(2)

Modifying the Pittsburgh Sheet

(1)

Modifying the Indianapolis Sheet

(1)

Modifying the Phoenix Sheet

(1)

Referencing Cells in Other Sheets in a Workbook

(1)

Entering a Sheet Reference

(1)

Modifying the Company Sheet

(4)

Drawing the 3-D Cone Chart

(3)

Adding a Chart Title Using the WordArt Tool

(6)

Adding a Text Box and Arrow to the Chart

(2)

Adding Comments to a Workbook

(2)

Adding a Header and Changing the Margins

(4)

Printing the Workbook and Print Options

(5)

Changing Sheet Setting

(1)

Page Breaks

(2)

The Find and Replace Commands

(3)

The Find Command

(1)

The Replace Command

(2)

Closing the Workbook

(1)

Consolidating Data by Linking Workbooks

(3)

Updating Links

(1)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

INTEGRATION FEATURE

Linking an Excel Worksheet to a Word Document

Introduction

(2)

Opening a Word Document and an Excel Workbook

(1)

Linking an Excel Worksheet to a Word Document

(3)

Printing and Saving the Word Document with the Linked Worksheet

(1)

Editing the Linked Worksheet

(1)

Integration Feature Summary

(1)

In the Lab

Microsoft Access 2000

PROJECT 4

Reports, Forms and Combo Boxes

Objectives

(3)

Introduction

(3)

Opening the Database

(1)

Report Creation

(11)

Creating a Query

(1)

Creating a Report

(4)

Moving to Design View and Docking the Toolbox

(1)

Reports Sections

(1)

Changing Properties

(2)

Closing and Saving a Report

(1)

Printing a Report

(1)

Grouping in a Report

(5)

Creating a Second Report

(5)

Reviewing the Report Design

(7)

Removing Unwanted Controls

(2)

Enlarging the Page Header Section

(1)

Changing Column Headings

(1)

Moving and Resizing Controls

(3)

Previewing a Report

(1)

Closing and Saving a Report

(1)

Printing a Report

(1)

Report Design Considerations

(1)

Creating and Using Custom Forms

(20)

Beginning the Form Creation

(2)

Modifying the Form Design

(2)

Adding a New Field

(1)

Changing the Format of a Field

(1)

Combo Boxes

(6)

Adding a Title

(2)

Enhancing a Title

(3)

Changing Tab Stops

(1)

Closing and Saving a Form

(1)

Opening a Form

(1)

Using a Form

(1)

Closing a Form

(1)

Form Design Considerations

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(4)

Cases and Places

PROJECT 5

Enhancing Forms with OLE Fields, Hyperlinks, and Subforms

Objectives

(3)

Introduction

(1)

Project Five - Enhancing the Bavant Marine Services Forms

(1)

Opening the Database

(1)

Date, Memo, OLE. and Hyperlink Fiedls

(1)

Adding Fields to a Table

(3)

Updating the New Fields

(11)

Updating Data Fields

(2)

Updating Memo Fields

(1)

Changing the Row and Column Size

(2)

Updating OLE Fields

(3)

Updating Hyperlink Fields

(2)

Saving the Table Properties

(1)

Advanced Form Techniques

(25)

Creating a Form with a Subform Using the Form Wizard

(5)

Modifying the Subform Design

(1)

Modifying the Form Design

(2)

Moving and Resizing Fields

(1)

Moving Labels

(1)

Resizing a Label

(1)

Moving Remaining Fields

(1)

Changing Label Alignment

(2)

Resizing the Labels

(1)

Changing the Size Mode of A Picture

(1)

Changing the Special Effects and Colors of Labels

(4)

Adding a Form Title

(2)

Viewing Data and Web Pages Using the Form

(3)

Using Data and Memo Fields in a Query

(3)

Closing the Database

(1)

Compacting a Database

(2)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

PROJECT 6

Creating an Application System Using Macros, Wizards, and the Switchboard Manager

Introduction

(3)

Project Six - Creating an Application System for Bavant Marine Services

(1)

Opening the Database

(1)

Lookup and Input Mask Wizards

(3)

Using the Lookup Wizard

(3)

Using the Input Mask Wizard

(4)

Entering Data Using an Input Mask

(1)

Using the Lookup Wizard Field

(1)

Modifying a Report

(9)

Resizing and Moving Controls in a Report

(2)

Adding Controls to a Report

(5)

Previewing a Report

(1)

Modifying the Form

(4)

Adding Controls to a Form

(2)

Changing the Tab Order

(1)

Creating and Using Macros

(10)

The Macro Window

(1)

Adding Actions to and Saving a Macro

(2)

Running a Macro

(1)

Modifying a Macro

(2)

Errors in Macros

(1)

Additional Macros

(1)

Copying a Macros

(3)

Modifying the Copied Macro

(3)

Macro Arguments

(1)

Creating Additional Macros

(1)

Running the Macros

(1)

Creating and Using a Switchboard

(10)

Creating a Switchboard

(2)

Creating Switchboard Pages

(1)

Modifying Switchboard pages

(3)

Modifying the Other Switchboard Pages

(2)

Using a Switchboard

(2)

Closing the Switchboard and Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

INTEGRATION FEATURE

Integrating Excel Worksheet Data into an Access Database

Introduction

(2)

Creating an Access Database

(1)

Importing an Excel Worksheet to an Access Database

(4)

Using the Access Table

(1)

Linking Versus Importing

(1)

Integration Feature Summary

(1)

In the Lab

Microsoft PowerPoint 2000

PROJECT 3

Using Embedded Visuals to Enhance a Slide Show

Objectives

(3)

Creating Exciting Presentations Using Embedded Visuals

(1)

Project Three - Fun in the Sun Spring Break

(2)

Importing Text Created in Another Application

(6)

Opening an Outline Created in Another Application

(2)

Changing Presentation Design Templates

(1)

Changing the Font

(3)

Saving the Presentation

(1)

Creating a Custom Background

(10)

Changing the Slide layout to Tiles Slide

(1)

Changing the Font Size

(1)

Inserting a Picture to Create a Custom Background

(4)

Adding Graphical Bullets

(4)

Creating and Embedding an Organization Chart

(28)

Changing Slide Layouts

(1)

Opening the Microsoft Organization Chart Application

(2)

Maximizing the Microsoft Organization Chart Window

(1)

Creating the Title for the Root Manager Box

(1)

Titling the Subordinate Boxes

(1)

Adding Subordinate Boxes

(1)

Adding Names to the Subordinate Boxes

(1)

Changing Organization Chart Styles

(2)

Copying a Branch of an Organization Chart

(1)

Pasting a Branch of an Organization Chart

(1)

Editing an Organization Chart

(2)

Formatting an Organization Chart

(2)

Adding Shadow Effects to Boxes in an Organization Chart

(1)

Changing Border Styles in an Organization Chart

(2)

Quitting Microsoft Organization Chart and Returning to the PowerPoint Window

(1)

Scaling an Organization Chart Object

(1)

Moving the Organization Chart

(1)

Inserting a Table into a Slide

(3)

Entering Data in a Table

(1)

Formatting a Table Cell

(2)

Formatting a Table

(4)

Creating a PowerPoint Clip Art Object

(8)

Increasing the Object Area Placeholder Width

(2)

Inserting a Clip Art Picture

(1)

Scaling and Moving Clip Art

(1)

Ungrouping a Clip Art Picture

(2)

Deselecting Clip Art Objects

(1)

Deleting a PowerPoint Object

(1)

Grouping PowerPoint Objects

(2)

Adding Slide Transition and Text Preset Animation Effects

(3)

Printing Slides as Handouts

(2)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

PROJECT 4

Creating a Presentation Containing Interactive OLE Documents

Objectives

(3)

Introduction

(2)

Project Four - Customizing an Existing Presentation

(3)

Opening a Presentation and Saving It with a New File Name

(1)

Editing the Title Slide

(1)

Changing the Background

(2)

Creating a WordArt Object

(4)

Deleting the Slide Text

(1)

Displaying the Rulers

(1)

Displaying the Guides

(1)

Positioning the Guides

(2)

Increasing the Zoom Percentage

(1)

Adding Special Text Effects

(7)

Selecting a WordArt Style

(2)

Entering the WordArt Text

(1)

Changing the WordArt Height and Width

(2)

Changing the WordArt Fill Color

(2)

Scaling a WordArt Object

(3)

Hiding the Rulers and Guides

(1)

Resetting the Zoom Percentage

(1)

Creating an Interactive Document

(15)

Editing Existing Text

(1)

Moving a Slide Bullet within Outline View

(2)

Adding Action Buttons and Action Settings

(4)

Displaying Guides and Positioning Action Buttons

(3)

Scaling Objects

(1)

Adding Fill Color to the Action Buttons

(1)

Adding Shadow Effects to the Action Buttons

(1)

Adding Capations to the Action Buttons

(1)

Formatting Text

(2)

Modifying an Organization Chart

(5)

Changing the Box Color in An Organization Chart

(1)

Deleting a Branch of an Organization Chart

(1)

Editing Texts in an Organization Chart

(1)

Adding Co-Worker Boxes

(2)

Editing a PowerPoint Table

(3)

Editing the Table Text

(1)

Deleting a Table Row

(1)

Changing the Table Fill Color

(1)

Hiding Slides

(4)

Adding a New Slide

(1)

Adding a Slide Title

(1)

Adding Text and Removing Bullets

(1)

Hiding a Slide

(2)

Changing the Order of Slides

(1)

Adding a Summary Slide

(4)

Deleting a Slide

(1)

Repositioning the Summary Slide

(1)

Applying Slide Transition Effects

(1)

Save The Presentation

(1)

Running a Slide Show with a Hiden Slide and Interactive Documents

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(7)

Cases and Places

INTEGRATION FEATURE

Importing Clips from the Microsoft Clip Gallery Live Web Site

Introduction

(1)

Opening an Existing Presentation and Saving It with a New File Name

(2)

Moving to Another Slide

(1)

Importing Clip Art form Microsoft Clip Gallery Live on the World Wide Web

(1)

Connecting to the Microsoft Clip Gallery Live Site

(1)

Searching for and Downloading Microsoft Clip Gallery Live Clips

(5)

Quitting a Web Session

(1)

Moving the Clips

(2)

Saving the Presentation

(1)

Running an Animated Slide Show

(1)

Printing Presentation Slides

(1)

Quitting PowerPoint

(1)

Integration Feature Summary

(1)

What You Should Know

(1)

In the Lab

Integration Case Studies

Introduction

(1)

Office 2000 Integration Case Studies

(1)

Integrating Excel, Word, PowerPoint, and E-Mail

(3)

Integrating Word, WordArt, and Access

(2)

Integrating Access into Word and Excel

Appendix A Microsoft Office 2000 Help System

(1)

Using the Microsoft Office Help System

(1)

The Office Assistant

(3)

Showing and Hiding the Office Assistant

(1)

Turning the Office Assistant On and Off

(1)

Using the Office Assistant

(1)

The Microsoft Word Help Window

(4)

Using the Contents Sheet

(1)

Using the Answer Wizard Sheet

(1)

Using the Index Sheet

(1)

What's This? Command and Question Mark Button

(1)

What's This? Command

(1)

Question Mark Button

(1)

Office on the Web Command

(1)

Other Help Commands

(1)

Word Perfect Help Command

(1)

Detect and Repair Command

(1)

About Microsoft Word Command

(1)

Use Help

Appendix B Publishing Office Web Pages To a Web Server

(1)

Appendix C Resetting the Menus and Toolbars

(1)

Appendix D Microsoft Office User Specialist Certification Program

(1)

Why Should You Get Certified?

(1)

The MOUS Exams

(1)

How Can You Prepare for the MOUS Exams?

(1)

How to Find an Authorized Testing Center

(1)

Shelly Cashman Series MOUS Web Page

(1)

Microsoft Office 2000 User Specialist Certification Map

Microsoft Word 2000 User Specialist Certification Map

(2)

Microsoft Excel 2000 User Specialist Certification Map

(2)

Microsoft Access 2000 User Specialist Certification Map

(2)

Microsoft PowerPoint 2000 User Specialist Certification Map

Index

(1)

Microsoft Office 2000 Quick Reference Summary

Amazon no longer offers textbook rentals. We do!

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

Microsoft Office 2000

0789546493

Summary

Table of Contents

Supplemental Materials

Rewards Program