9780789556912

Microsoft Word 2000

Project 7 Working with a Master Document, an Index, and a Table of Contents

Objectives

(3)

Introduction

(1)

Project Seven---Master Document, Index, and Table of Contents

(3)

Starting Word

(1)

Resetting Menus and Toolbars

(1)

Displaying Formatting Marks

(1)

Reviewing a Document

(15)

Opening a Document

(1)

Saving the Document with a New Name

(1)

Zooming Text Width

(1)

Inserting Comments

(2)

Tracking Changes

(2)

Comparing Documents

(1)

Saving Multiple Versions of a Document

(1)

Reviewing Comments

(1)

Deleting Comments

(1)

Reviewing Tracked Changes

(4)

Preparing a Document to be Included in a Longer Document

(14)

Embedding an Excel Worksheet into a Word Document

(4)

Adding a Caption

(3)

Creating a Cross-Reference

(2)

Marking Index Entries

(1)

Keeping Paragraphs Together

(2)

Password-Protecting a File

(2)

Working with a Master Document

(33)

Creating an Outline

(2)

Inserting a Subdocument in a Master Document

(5)

Creating a Subdocument from a Master Document

(1)

Modifying an Outline

(2)

Entering Text and Graphics as Part of the Master Document

(3)

Adding an AutoShape

(2)

Grouping Drawing Objects

(3)

Creating a Table of Figures

(1)

Building an Index

(2)

Creating a Table of Contents

(1)

Adding Bookmarks

(2)

Creating Alternating Headers and Footers

(2)

Setting a Gutter Margin

(2)

Opening a Master Document

(2)

Using the Document Map

(1)

Modifying the Table of Contents and Index

(2)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(7)

Cases and Places

Project 8 Creating an Online Form

Objectives

(3)

Introduction

(1)

Project Eight---Online Form

(3)

Starting Word

(1)

Resetting Menus and Toolbars

(1)

Displaying Formatting Marks

(1)

Zooming Page Width

(1)

Designing on Online Form

(1)

Creating an Online Form

(40)

Creating a Template

(4)

Highlighting Text

(2)

Inserting a Table into a Form

(2)

Inserting a Text Box that Accepts Any Text

(3)

Inserting a Drop-Down List Box

(6)

Inserting a Text Box that Requires a Number

(1)

Inserting a Check Box

(4)

Inserting a Text Box that Displays the Current Date

(2)

Formatting Form Fields

(1)

Using the Format Painter Button

(2)

Adding Help Text to Form Fields

(3)

Removing Form Field Shading

(2)

Drawing and Formatting a Rectangle

(5)

Animating Text

(2)

Protecting a Form

(1)

Working with an Online Form

(7)

Saving Data on the Form

(3)

Working with Templates

(2)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(3)

Cases and Places

Project 9 Using Visual Basic for Applications (VBA) with Word

Objectives

(3)

Introduction

(1)

Project Nine---Visual Basic for Applications (VBA)

(7)

Starting Word and Opening an Office Document

(1)

Saving the Document with a New File Name

(1)

Unprotecting a Document

(1)

Resetting Menus and Toolbars

(1)

Displaying Formatting Marks

(1)

Zooming Page Width

(1)

Setting a Security Level in Word

(2)

Modifying a Form

(14)

Modifying Graphics, Fonts, and Font Sizes

(2)

Formatting a Character as an In Margin Drop Cap

(3)

Creating a New Style

(5)

Filling a Drawing Object with a Bitmap Picture

(2)

Adding a 3-D Effect to a Drawing Object

(2)

Using a Macro to Automate a Task

(14)

Recording and Executing a Macro

(5)

Assigning a Macro to a Toolbar Button

(4)

Recording an Automatic Macro

(5)

Editing a Recorded Macro

(7)

Viewing a Macro's VBA Code

(2)

Adding Comments to a Macro

(2)

Modifying Existing Code in a Macro

(1)

Entering Code Statements

(2)

Creating a Macro from Scratch Using VBA

(7)

Modifying Form Field Options

(2)

Inserting a Procedure for the Macro

(2)

Planning and Writing a VBA Procedure

(2)

Running a Macro When a User Exits a Form Field

(1)

Adding an ActiveX Control to a Form

(12)

Inserting an ActiveX Control

(2)

Formatting the ActiveX Control

(2)

Setting Properties of an ActiveX Control

(2)

Writing the Macro for the ActiveX Control

(3)

More About Visual Basic for Applications

(1)

Testing the Online Form

(1)

Copying, Renaming, and Deleting Macros

(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 and Charting Its Data in Word

Introduction

(2)

Starting Word and Opening a Document

(1)

Saving the Document with a New File Name

(1)

Linking an Excel Worksheet

(3)

Creating a Chart from an Excel Worksheet

(6)

Editing a Linked Worksheet

(1)

Integration Feature Summary

(1)

In the Lab

Microsoft Excel 2000

Project 7 Using Visual Basic for Applications (VBA) with Excel

Objectives

(3)

Introduction

(1)

Project Seven---Golden Years.Com's 401(k) Planning Worksheet

(5)

Starting Excel and Opening a Workbook

(1)

Gaining Confidence in a Workbook Created

(2)

Someone Else

Unprotecting a Password-Protected Worksheet

(1)

Recording a Macro and Assigning It to a Toolbar Button and Menu Command

(14)

Recording a Macro

(4)

Opening a Workbook with a Macro and Executing the Macro

(1)

Viewing a Macro's VBA Code

(2)

Customizing Toolbars and Menus

(6)

Creating a Procedure to Automate the 401(k) Data Entry

(16)

Create the User Interface

(2)

Set the Properties

(2)

Write the VBA Code

(4)

More About Visual Basic for Applications

(1)

Testing the 401(k) Data Entry Procedure

(4)

Creating an Adjustment Center to Automate the 401(k) Data Entry

(31)

Create the User Interface

(4)

Set the Properties

(16)

Write the Code

(8)

Testing the Controls

(1)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(7)

Cases and Places

Project 8 Auditing, Data Validation, and Solving Complex Problems

Objectives

(3)

Introduction

(4)

Project Eight---Union Cafeteria Menu Planning Worksheet

(1)

Starting Excel and Opening a Workbook

(1)

Auditing

(6)

Displaying the Auditing Toolbar

(1)

Tracing Precedents with the Auditing Toolbar

(1)

Removing Precedents Arrows with the Auditing Toolbar

(1)

Tracing Dependents with the Auditing Toolbar

(1)

Removing All Arrows with the Auditing Toolbar

(2)

Data Validation, Trial and Error, and Goal Seek

(8)

Adding Data Validation to Cells

(3)

Using Trial and Error to Solve a Complex Problem

(2)

Goal Seeking to Solve a Complex Problem

(2)

Using Solver to Solve Complex Problems

(9)

Using Solver to Find the Optimal Combination of Servings

(6)

Viewing a Solver Answer Report

(1)

Saving the Workbook with Passwords

(3)

Using Scenario Manager to Analyze Data

(13)

Saving the Current Data as a Scenario

(4)

Creating a New Scenario

(2)

Using Solver to Find a New Solution

(4)

Saving the Second Solver Solution as a Scenario

(2)

Showing a Scenario

(1)

Summarizing Scenarios

(6)

Creating a Scenario Summary Worksheet

(2)

Working with an Outlined Worksheet

(1)

Creating a Scenario PivotTable

(2)

Changing the Properties on a Workbook

(2)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

Project 9 Importing External Data, Tracking and Routing Changes, and Creating Data Maps, PivotCharts, and PivotTables

Objectives

(3)

Introduction

(1)

Project Nine---Burrito Land Sales Analysis

(4)

Starting Excel and Opening a Workbook

(1)

Importing Files

(14)

Importing Text Files

(4)

Importing Access Tables

(5)

Importing Data from a Web Page

(4)

Replicating Formulas

(1)

Saving the Workbook with a New File Name

(1)

Preparing the Workbook for Routing

(7)

Inserting Comments

(2)

Collaborating on Workbooks

(1)

Tracking Changes

(2)

Routing the Workbook

(3)

Reviewing Tracked Changes

(5)

Reviewing the Routed Workbook

(5)

Creating a Data Map

(10)

Adding the Map Button to the Standard Toolbar

(1)

Creating the Data Map

(3)

Changing the Map's Features

(2)

Formatting a Data Map and Adding Column Chart Symbols

(4)

Creating and Formatting PivotCharts and PivotTables

(16)

Creating a PivotChart

(4)

Adding Data to the PivotChart

(2)

Formatting a PivotChart

(3)

Changing the View of a PivotChart

(3)

PivotChart and PivotTable Relationships

(1)

Formatting a PivotTable

(2)

Interacting with the PivotTable

(2)

Quitting Excel

(1)

Merging Workbooks

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(5)

Cases and Places

Web Feature Creating a PivotTable List Web Page Using Excel

Introduction

(2)

Saving a Worksheet Database as a PivotTable List

(2)

Viewing the PivotTable List Using Your Browser

(1)

Changing the View of the PivotTable List

(7)

Using the Field Drop-Down Arrows to Display Records That Pass a Test

(2)

Adding Summary Totals

(1)

Sorting Columns of Data

(1)

Dragging Data Fields to the Row Field Area

(1)

Dragging Data Fields to the Filter Field Area

(2)

Removing Fields and Adding Fields to a PivotTable List

(2)

Improving the Appearance of a PivotTable List

(1)

Web Feature Summary

(1)

What You Should Know

(1)

In the Lab

Microsoft Access 2000

Project 7 Creating a Report Using Design View

Objectives

(3)

Introduction

(4)

Opening the Database

(1)

Creating the Additional Tables

(2)

Creating the New Tables

(1)

Importing the Data

(1)

Changing the Layout

(4)

Relating Several Tables

(1)

Creating a Lookup Wizard Field

(2)

Creating Join Queries

(9)

Creating a Query

(1)

Changing Join Properties

(1)

Changing Field Properties

(1)

Running the Query and Changing the Layout

(1)

Filtering the Query's Recordset

(1)

Creating a Parameter Query

(2)

Running a Parameter Query

(1)

Creating Queries for Reports

(1)

Creating a Report

(23)

Creating the Initial Report

(3)

Adding the Fields

(1)

Saving the Report

(1)

Adding a Subreport

(4)

Modifying the Subreport

(5)

Moving the Subreport

(1)

Adding a Date

(2)

Adding a Page Number

(1)

Bolding Labels

(1)

Adding a Title

(3)

Changing Margins

(1)

Printing a Report

(1)

Mailing Labels

(4)

Creating Labels

(4)

Printing the Labels

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(9)

Cases and Places

Project 8 Customizing Forms Using Visual Basic for Applications (VBA), Charts, and PivotTable Objects

Objectives

(3)

Introduction

(3)

Project Eight---Using Advanced Form Techniques

(10)

Opening the Database

(1)

Enhancing the Form

(1)

Adding Command Buttons to the Form

(5)

Using the Buttons

(1)

Modifying the Add Record Button

(3)

Creating and Using Combo Boxes

(16)

Creating a Combo Box

(4)

Using the Combo Box

(2)

Issues with the Combo Box

(1)

Modifying the Combo Box

(5)

Using the Modified Combo Box

(2)

Placing a Rectangle

(2)

Closing and Saving a Form

(1)

Opening a Form

(1)

Creating a Form Using Design View

(13)

Creating a Query for the Subform

(1)

Creating the Form

(1)

Placing a Subform

(3)

Closing and Saving the Form

(1)

Modifying the Subform

(2)

Resizing the Subform

(1)

Inserting a Chart

(4)

Inserting an Additional Chart

(1)

Adding a Title

(1)

Creating and Using PivotTable Forms

(6)

Creating a PivotTable Form

(3)

Using the PivotTable Form

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(7)

Cases and Places

Project 9 Administering a Database System

Objectives

(3)

Introduction

(2)

Project Nine---Administering a Database System

(1)

Opening the Database

(1)

Using Microsoft Access Tools

(1)

Converting a Database to an Earlier Version

(1)

Using the Analyze Tool

(7)

Using the Table Analyzer

(4)

Using the Performance Analyzer

(1)

Using the Documenter

(2)

Integrity and Security Features

(12)

Using Input Masks

(2)

Specifying Referential Integrity Options

(2)

Updating Tables with the Cascade Options

(2)

Setting Startup Options

(1)

Setting Passwords

(2)

Encrypting a Database

(1)

Removing a Password

(2)

Creating a Grouped Data Access Page

(6)

Previewing the Data Access Page

(3)

Using Replication

(4)

Creating a Replica

(1)

Using a Replica

(2)

Synchronizing the Design Master and the Replica

(2)

SQL

(20)

Creating a New SQL Query

(1)

Including Only Certain Fields

(1)

Preparing to Enter a New SQL Command

(1)

Including All Fields

(1)

Using a Criterion Involving a Numeric Field

(1)

Using a Criterion Involving a Text Field

(1)

Using Compound Criteria

(1)

Using NOT in a Criterion

(1)

Using Computed Fields

(1)

Sorting the Results

(1)

Using Built-In Functions

(1)

Using Multiple Functions in the Same Command

(1)

Using Grouping

(2)

Restricting the Groups that Display

(1)

Joining Tables

(2)

Restricting the Records in a Join

(1)

Joining Multiple Tables

(2)

Closing the Query

(1)

Comparison with Access-Generated SQL

(1)

Closing the Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

Integration Feature Using Access Data in Other Applications

Introduction

(2)

Opening the Database

(1)

Using the Export Command to Export Data to Excel

(3)

Using Drag-and-Drop to Export Data to Word

(2)

Using the Export Command to Create a Snapshot

(2)

Closing the Database

(1)

Integration Feature Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

Microsoft PowerPoint 2000

Project 5 Creating a Self-Running Presentation Using Animation Effects

Objectives

(3)

Introduction

(2)

Project Five---Half-Hour Workout

(3)

Starting a New Presentation

(1)

Creating the Title Slide in Slide View

(2)

Adding a Presentation within a Presentation

(4)

Inserting a Slide from Another Presentation

(4)

Creating a New Slide with Animated Clip Art

(6)

Inserting a New Slide, Choosing a Layout, and Adding Text

(2)

Increasing the Right Object Area Placeholder Width

(1)

Inserting Animated Clip Art

(1)

Moving the Animated Clip Art

(1)

Sizing the Animated Clip Art

(1)

Saving the Presentation

(1)

Inserting an Excel Chart

(6)

Scaling an Excel Chart

(1)

Building a PowerPoint Chart

(11)

Creating a New Slide, Choosing the Chart AutoLayout, and Typing the Title Text

(1)

Selecting a Different Chart Type

(3)

Replacing the Sample Data

(4)

Adding a Chart Title and Data Labels

(3)

Adding a Table from Word

(2)

Inserting and Formatting an AutoShape

(7)

Inserting an AutoShape

(2)

Adding a Shadow to an AutoShape

(1)

Adding Text to an AutoShape

(1)

Rotating an AutoShape

(2)

Animating the AutoShape Object

(1)

Omitting Background Graphics and Changing the Background Color

(3)

Applying Custom Animation

(4)

Setting the Animation Order

(2)

Changing the Slide Timing

(2)

Creating a Self-Running Presentation

(2)

Setting Timings for the Slide Show

(4)

Adding Slide Transition and Text Preset Animation Effects

(3)

Saving the Presentation

(1)

Starting the Self-Running Presentation

(1)

Printing Slides as Handouts

(2)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(9)

Cases and Places

Project 6 Using Visual Basic for Applications (VBA) with PowerPoint

Objectives

(3)

Introduction

(2)

Project Six---Creating an Electronic Portfolio

(3)

Opening a Presentation and Saving It with a New File Name

(2)

Creating a Toolbar and Adding Two Buttons

(6)

Creating and Customizing a Toolbar

(5)

Saving the Presentation

(1)

Recording a Macro and Assigning It to a Menu Command

(10)

Recording a Macro

(4)

Customizing a Menu

(3)

Opening a Presentation Containing a Macro and Executing the Macro

(1)

Viewing a Macro's VBA Code

(2)

Creating a Form to Customize the Presentation

(43)

Create the User Interface

(1)

Opening the Visual Basic IDE and a New Form

(1)

Changing the Form Size and Arranging the Toolbox Position

(2)

Adding Controls

(10)

Set the Control Properties

(7)

Saving the Form

(1)

Write the VBA Code

(3)

More About Visual Basic for Applications

(16)

Adding a Button to Run the Form

(1)

Saving the Presentation

(1)

Testing the Controls

(1)

Quitting PowerPoint

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(9)

Cases and Places

Web Feature Distributing Presentations to Remote Audiences

Introduction

(1)

Part 1---Saving the Presentation Using the Pack and Go Wizard

(4)

Unpacking a Presentation

(1)

Part 2---Discussing and Subscribing to a Publication

(6)

Opening a File in a Web Folder

(1)

Starting Web Discussions

(2)

Subscribing to a Publication

(2)

Ending the Discussion

(1)

Web Feature Summary

(1)

What You Should Know

(1)

In the Lab

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)

WordPerfect 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

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

I.1

Microsoft Office 2000 Quick Reference Summary

QR.1

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

078955691X

Summary

Table of Contents

Supplemental Materials

Rewards Program