Microsoft Office 2000 Brief... | Buy

Windows 98 and Microsoft Office 2000

An Introduction to Windows 98 and Office 2000

Objectives

(3)

Introduction

(1)

What Is Microsoft Windows 98?

(3)

What Is a User Interface?

(1)

Launching Microsoft Windows 98

(2)

Closing the Welcome Screen

(1)

The Desktop as a Work Area

(1)

Communicating with Microsoft Windows 98

(18)

Mouse Operations

(1)

Point and Click

(2)

Right-Click

(2)

Double-Click

(1)

My Computer Windows

(1)

Minimize Button

(2)

Maximize and Restore Buttons

(3)

Close Button

(1)

Drag

(1)

Sizing a Window by Dragging

(1)

Scrolling in a Window

(2)

Resizing a Window

(1)

Closing a Window

(1)

Right-Drag

(2)

Summary of Mouse and Windows Operations

(1)

The Keyboard and Keyboard Shortcuts

(1)

The Windows 98 Desktop Views

(1)

Launching an Application Program

(3)

Launching an Application Using the Start Button

(2)

Quitting a Program

(1)

Windows Explorer

(7)

Starting Windows Explorer and Maximizing Its Window

(1)

The Exploring - My Computer Window

(2)

Displaying the Contents of a Folder

(2)

Expanding a Folder

(1)

Collapsing a Folder

(1)

Copying Files to a Folder on a Floppy Disk

(12)

Creating a New Folder

(3)

Displaying the Destination Folder

(1)

Displaying the Contents of the Windows Folder

(2)

Changing the View

(1)

Selecting a Group of Files

(2)

Copying a Group of Files

(1)

Displaying the Contents of the My Files Folder

(1)

Renaming a File or Folder

(2)

Deleting a File or Folder

(3)

Deleting a File by Right-Clicking Its File Name

(2)

Deleting a Folder

(1)

Quitting Windows Explorer

(1)

Using Windows Help

(6)

Contents Sheet

(4)

Index Sheet

(2)

Shutting Down Windows 98

(1)

What Is Microsoft Office 2000?

(2)

The Internet, World Wide Web, and Intranets

(1)

Microsoft Office 2000 and the Internet

(1)

Microsoft Word 2000

(2)

Microsoft Word 2000 and the Internet

(1)

Microsoft Excel 2000

(1)

Microsoft Excel 2000 and the Internet

(1)

Microsoft Access 2000

(2)

Microsoft Access 2000 and the Internet

(1)

Microsoft PowerPoint 2000

(2)

Microsoft PowerPoint 2000 and the Internet

(2)

The Web Toolbar

(1)

Microsoft Publisher 2000

(1)

Microsoft Publisher and the Internet

(1)

Microsoft FrontPage 2000

(1)

Microsoft PhotoDraw 2000

(1)

Microsoft Outlook 2000

(2)

The Microsoft Office 2000 Help System

(1)

Project Summary

(1)

What You Should Know

(1)

In the Lab

Microsoft Word 2000

Creating and Editing a Word Document

Objectives

(5)

What Is Microsoft Word 2000?

(1)

Project One---Summit Peak Announcement

(2)

Starting Word

(1)

The Word Window

(7)

Document Window

(2)

Menu Bar and Toolbars

(3)

Resetting Menus and Toolbars

(1)

Displaying the Entire Standard Toolbar

(1)

Zooming Page Width

(1)

Changing the Default Font Size

(1)

Entering Text

(9)

Entering Blank Lines into a Document

(1)

Displaying Formatting Marks

(1)

Entering More Text

(1)

Using Wordwrap

(1)

Checking Spelling Automatically as You Type

(2)

Entering Text that Scrolls the Document Window

(2)

Saving a Document

(3)

Formatting Paragraphs and Characters in a Document

(13)

Selecting and Formatting Paragraphs and Characters

(1)

Selecting Multiple Paragraphs

(1)

Changing the Font of Selected Text

(1)

Changing the Font Size of Selected Text

(1)

Bold Selected Text

(1)

Right-Align a Paragraph

(1)

Center a Paragraph

(1)

Undoing Commands or Actions

(1)

Selecting a Line and Formatting It

(1)

Selecting a Word

(2)

Italicize Selected Text

(1)

Scrolling

(1)

Selecting a Group of Words

(1)

Underlining Selected Text

(1)

Inserting Clip Art into a Word Document

(6)

Inserting Clip Art

(3)

Selecting and Centering a Graphic

(1)

Resizing a Graphic

(1)

Restoring a Resized Graphic To Its Original Size

(1)

Saving an Existing Document with the Same File Name

(1)

Printing a Document

(1)

Quitting Word

(1)

Opening a Document

(2)

Correcting Errors

(2)

Types of Changes Made to Documents

(1)

Inserting Text into an Existing Document

(1)

Deleting Text from an Existing Document

(1)

Closing the Entire Document

(1)

Word Help System

(3)

Using the Office Assistant

(3)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(3)

Cases and Places

Creating a Research Paper

Objectives

(3)

Introduction

(1)

Project Two---Web Publishing Research Paper

(3)

MLA Documentation Style

(1)

Starting Word

(1)

Resetting Menus and Toolbars

(1)

Displaying Formatting Marks

(1)

Changing the Margins

(2)

Zooming Page Width

(1)

Adjusting Line Spacing

(2)

Using a Header to Number Pages

(4)

Headers and Footers

(2)

Entering Text Using Click and Type

(1)

Entering a Page Number into the Header

(2)

Typing the Body of the Research Paper

(19)

Changing the Default Font Size

(1)

Entering Name and Course Information

(1)

Applying Formatting Using Shortcut Keys

(2)

Saving the Research Paper

(1)

Indenting Paragraphs

(2)

Using Word's AutoCorrect Feature

(3)

Adding Footnotes

(2)

Modifying a Style

(6)

Automatic Page Breaks

(2)

Inserting Arrows, Faces, and Other Symbols Automatically

(1)

Creating an Alphabetical Works Cited Page

(7)

Manual Page Breaks

(1)

Centering the Title of the Works Cited Page

(1)

Creating a Hanging Indent

(2)

Creating a Hyperlink

(1)

Sorting Paragraphs

(2)

Proofing and Revising the Research Paper

(12)

Going to a Specific Location in a Document

(2)

Finding and Replacing Text

(2)

Finding Text

(1)

Moving Text

(3)

Finding a Synonym

(1)

Using Word Count

(2)

Checking Spelling and Grammar at Once

(2)

Saving Again and Printing the Document

(1)

Navigating to a Hyperlink

(1)

E-mailing a Copy of the Research Paper

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

Microsoft Excel 2000

Creating a Worksheet and Embedded Chart

Objectives

(5)

What Is Microsoft Excel 2000?

(1)

Project One---Fun-N-Sun Sojourn First Quarter Sales

(3)

Starting Excel

(1)

The Excel Worksheet

(2)

The Worksheet

(2)

Worksheet Window

(4)

Menu Bar

(1)

Standard Toolbar and Formatting Toolbar

(2)

Resetting Menus and Toolbars

(1)

Formula Bar

(1)

Status Bar

(1)

Selecting a Cell

(1)

Entering Text

(5)

Entering the Worksheet Title

(1)

Correcting a Mistake While Typing

(1)

AutoCorrect

(1)

Entering Column Titles

(1)

Entering Row Titles

(1)

Entering Numbers

(2)

Calculating a Sum

(2)

Using the Fill Handle to Copy a Cell to Adjacent Cells

(3)

Determining Row Totals

(2)

Formatting the Worksheet

(7)

Fonts, Font Size, and Font Style

(1)

Displaying the Formatting Toolbar in Its Entirety

(1)

Bolding a Cell

(2)

Increasing the Font Size

(1)

Using AutoFormat to Format the Body of a Worksheet

(2)

Centering the Worksheet Title Across Columns

(1)

Using the Name Box to Select a Cell

(2)

Adding a 3-D Column Chart to the Worksheet

(5)

Saving a Workbook

(4)

Printing the Worksheet

(1)

Quitting Excel

(1)

Starting Excel and Opening a Workbook

(2)

AutoCalculate

(2)

Correcting Errors

(3)

Correcting Errors While You Are Typing Data into a Cell

(1)

In-Cell Editing

(1)

Undoing the Last Entry

(1)

Clearing a Cell or Range of Cells

(1)

Clearing the Entire Worksheet

(1)

Excel Help System

(4)

Using the Office Assistant

(3)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(3)

Cases and Places

Formulas, Functions, Formatting, and Web Queries

Objectives

(3)

Introduction

(1)

Project Two---BetNet Stock Club

(3)

Starting Excel and Resetting the Toolbars

(1)

Entering the Titles and Numbers into the Worksheet

(2)

Entering Formulas

(7)

Order of Operations

(1)

Entering Formulas Using Point Mode

(1)

Copying the Formulas Using the Fill Handle

(2)

Determining the Totals Using the AutoSum Button

(1)

Determining the Total Percentage Gain/Loss

(1)

Using the Average, MAX, and MIN Functions

(7)

Determining the Average of a Range of Numbers

(2)

Determining the Highest Number in a Range of Numbers

(2)

Determining the Lowest Number in a Range of Numbers

(1)

Copying the Average, MAX, and MIN Functions

(2)

Verifying Formulas

(3)

Verifying a Formula Using Range Finder

(1)

Verifying a Formula Using the Auditing Commands

(2)

Formatting the Worksheet

(22)

Changing the Font and Centering the Worksheet Title

(2)

Changing the Worksheet Title Background and Font Colors and Applying an Outline Border

(2)

Applying Formats to the Column Titles

(1)

Centering the Stock Symbols and Formatting the Numbers in the Worksheet

(2)

Formatting Numbers Using the Formatting Toolbar

(1)

Formatting Numbers Using the Format Cells Command on the Shortcut Menu

(3)

Formatting Numbers Using the Percent Style Button and Increase Decimal Button

(1)

Conditional Formatting

(3)

Changing the Widths of Columns and Heights of Rows

(1)

Changing the Widths of Columns

(3)

Changing the Heights of Rows

(2)

Checking Spelling

(2)

Saving the Workbook a Second Time Using the Same File Name

(1)

Previewing and Printing the Worksheet

(4)

Printing a Section of the Worksheet

(1)

Displaying and Printing the Formulas Version of the Worksheet

(3)

Changing the Print Scaling Option Back to 100%

(1)

Getting External Data from a Web Source Using a Web Query

(3)

Changing the Sheet Names

(1)

E-mailing a Workbook from within Excel

(2)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(9)

Cases and Places

Microsoft Access 2000

Creating a Database Using Design and Datasheet Views

Objectives

(5)

What Is Microsoft Access 2000?

(1)

Project One---Bavant Marine Services Database

(6)

Starting Access and Creating a New Database

(3)

The Access Desktop and the Database Window

(1)

Creating a Table

(6)

Defining the Fields

(3)

Correcting Errors in the Structure

(1)

Saving a Table

(1)

Adding Records to a Table

(4)

Closing a Table and a Database and Quitting Access

(1)

Opening a Database

(2)

Adding Additional Records

(3)

Correcting Errors in the Data

(1)

Previewing and Printing the Contents of a Table

(4)

Creating Additional Tables

(2)

Adding Records to the Additional Table

(1)

Using a Form to View Data

(7)

Creating a Form

(1)

Closing and Saving the Form

(1)

Opening the Saved Form

(1)

Using the Form

(1)

Switching Between Form View and Datasheet View

(2)

Creating a Report

(6)

Selecting the Fields for the Report

(2)

Completing the Report

(2)

Printing the Report

(1)

Closing the Database

(1)

Access Help System

(2)

Using the Office Assistant

(2)

Designing a Database

(3)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(2)

In the Lab

(6)

Cases and Places

Querying a Database Using the Select Query Window

Objectives

(3)

Introduction

(1)

Project Two---Querying the Bavant Marine Services Database

(2)

Opening the Database

(1)

Creating a New Query

(8)

Using the Select Query Window

(1)

Displaying Selected Fields in a Query

(2)

Running a Query

(1)

Printing the Results of a Query

(1)

Returning to Design View

(2)

Closing a Query

(1)

Including All Fields in a Query

(2)

Clearing the Design Grid

(1)

Entering Criteria

(6)

Using Text Data in Criteria

(1)

Using Wildcards

(1)

Criteria for a Field Not in the Result

(2)

Using Numeric Data in Criteria

(1)

Using Comparison Operators

(1)

Using Compound Criteria

(3)

Using And Criteria

(2)

Using Or Criteria

(1)

Sorting Data in a Query

(5)

Sorting on Multiple Keys

(2)

Omitting Duplicates

(2)

Joining Tables

(4)

Restricting Records in a Join

(1)

Using Calculated Fields in a Query

(3)

Calculating Statistics

(4)

Using Criteria in Calculating Statistics

(1)

Grouping

(1)

Saving a Query

(1)

Closing a Database

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(3)

Cases and Places

Microsoft PowerPoint 2000

Using a Design Template and AutoLayouts to Create a Presentation

Objectives

(5)

What Is Microsoft PowerPoint 2000?

(2)

Project One---Effective Study Skills

(2)

Starting a Presentation as a New Office Document

(2)

The PowerPoint Window

(6)

PowerPoint Views

(1)

Placeholders, Title Area, Object Area, Mouse Pointer, and Scroll Bars

(1)

Menu Bar, Standard Toolbar, Formatting Toolbar, Drawing Toolbar, and Status Bar

(3)

Resetting Menus and Toolbars

(1)

Displaying the Formatting Toolbar in Its Entirety

(1)

Choosing a Design Template

(2)

Creating a Title Slide

(4)

Entering the Presentation Title

(2)

Correcting a Mistake When Typing

(1)

Entering the Presentation Subtitle

(1)

Text Attributes

(4)

Changing the Font Size

(3)

Changing the Style of Text to Italic

(1)

Saving the Presentation on a Floppy Disk

(3)

Adding a New Slide to a Presentation

(2)

Creating a Bulleted List Slide

(7)

Entering a Slide Title

(1)

Selecting an Object Area Placeholder

(1)

Typing a Multi-level Bulleted List

(4)

Adding New Slides with the Same AutoLayout

(2)

Ending a Slide Show with a Black Slide

(2)

Saving a Presentation with the Same File Name

(1)

Moving to Another Slide in Normal View

(2)

Using the Scroll Box on the Slide Pane to Move to Another Slide

(2)

Viewing the Presentation Using Slide Show

(4)

Starting Slide Show View

(1)

Advancing Through a Slide Show Manually

(1)

Using the Popup Menu to Go to a Specific Slide

(2)

Using the Popup Menu to End a Slide Show

(1)

Quitting PowerPoint

(1)

Opening a Presentation

(3)

Opening an Existing Presentation

(3)

Checking a Presentation for Spelling and Consistency

(3)

Checking a Presentation for Spelling Errors

(1)

Starting the Spelling Checker

(2)

Checking a Presentation for Style Consistency

(1)

Correcting Errors

(1)

Types of Corrections Made to Presentations

(1)

Deleting Text

(1)

Replacing Text in an Existing Slide

(1)

Changing Line Spacing

(6)

Displaying the Slide Master

(1)

Changing Line Spacing on the Slide Master

(4)

Displaying a Presentation in Black and White

(1)

Printing a Presentation

(3)

Saving a Presentation Before Printing

(1)

Printing the Presentation

(2)

Making a Transparency

(1)

PowerPoint Help System

(2)

Using the Office Assistant

(2)

Quitting PowerPoint

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

Using Outline View and Clip Art to Create a Slide Show

Objectives

(3)

Creating a Presentation from an Outline

(1)

Project Two---Searching for Scholarships

(1)

Starting a New Presentation

(1)

Using Outline View

(3)

The PowerPoint Window in Outline View

(1)

Creating a Presentation in Outline View

(2)

Creating a Title Slide in Outline View

(1)

Adding a Slide in Outline View

(1)

Creating Multi-level Bulleted List Slides in Outline View

(6)

Creating Subordinate Slides

(2)

Creating a Second Subordinate Slide

(1)

Creating a Closing Slide in Outline View

(1)

Saving a Presentation

(1)

Reviewing a Presentation in Slide Sorter View

(2)

Changing Slide Layout

(2)

Adding Clip Art to a Slide

(7)

Inserting Clip Art into an Object Area Placeholder

(3)

Inserting Clip Art on Other Slides

(3)

Inserting Clip Art on a Slide without a Clip Art Region

(1)

Moving Clip Art

(1)

Changing the Size of Clip Art

(3)

Creating a Hyperlink

(1)

Saving the Presentation Again

(1)

Adding a Header and Footer to Outline Pages

(2)

Using the Notes and Handouts Sheet to Add Headers and Footers

(1)

Adding Animation Effects

(5)

Slide Sorter Toolbar

(1)

Adding Slide Transitions to a Slide Show

(4)

Applying Animation Effects to Bulleted Slides

(4)

Animating Clip Art Objects

(1)

Displaying a Slide in Slide View

(1)

Animating Clip Art

(1)

Formatting and Animating a Title Slide

(2)

Saving the Presentation Again

(1)

Running an Animated Slide Show

(2)

Printing in Outline View

(4)

Printing an Outline

(3)

Printing Presentation Slides

(1)

E-mailing a Slide Show from Within PowerPoint

(3)

Saving and Quitting PowerPoint

(1)

Project Summary

(1)

What You Should Know

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

WEB FEATURE Creating a Presentation on the Web Using PowerPoint

Introduction

(2)

Saving a PowerPoint Presentation as a Web Page

(3)

Viewing a Presentation as a Web Page

(3)

Editing a Web Page through a Browser

(3)

Web Feature Summary

(1)

What You Should Know

(1)

In the Lab

APPENDIX A Microsoft Office 2000 Help System

A.1

Using the Microsoft Office Help System

A.1

The Office Assistant

A.2

Showing and Hiding the Office Assistant

A.3

Turning the Office Assistant On and Off

A.3

Using the Office Assistant

A.4

The Microsoft Word Help Window

A.5

Using the Contents Sheet

A.6

Using the Answer Wizard Sheet

A.7

Using the Index Sheet

A.8

What's This? Command and Question Mark Button

A.9

What's This? Command

A.9

Question Mark Button

A.9

Office on the Web Command

A.10

Other Help Commands

A.10

WordPerfect Help Command

A.10

Detect and Repair Command

A.10

About Microsoft Word Command

A.10

Use Help

A.11

APPENDIX B Publishing Office Web Pages to a Web Server

B.1

APPENDIX C Resetting the Menus and Toolbars

C.1

APPENDIX D Microsoft Office User Specialist Certification Program

D.1

Why Should You Get Gertified?

D.1

The Mous Exams

D.1

How Can You Prepare for the Mous Exams?

D.2

How to Find an Authorized Testing Center

D.2

Shelly Cashman Series Mous Web Page

D.2

Index

I.1

Rent More, Save More! Use code: ECRENTAL

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Microsoft Office 2000 Brief Concepts and Techniques

Summary

Table of Contents

Supplemental Materials

Rewards Program