9781418859480

Preface

To the Student

xiv

Microsoft: Windows XP and Office 2003

Project One: Introduction to Microsoft Windows XP and Office 2003

Objectives

(1)

Introduction

(1)

Microsoft Windows XP Operating Systems

(2)

Microsoft Windows XP Professional

(5)

What Is a User Interface?

(1)

Launching Microsoft Windows XP

(1)

The Windows XP User Interface

(1)

Logging On to the Computer

(2)

The Windows XP Desktop

(26)

Displaying the Start Menu

(4)

Adding an Icon to the Desktop

(2)

Opening a Window Using a Desktop Icon

(1)

The My Computer Window

(1)

Minimizing a Window

(2)

Maximizing and Restoring a Window

(3)

Closing a Window

(1)

Opening a Window Using the Start Menu

(2)

The My Documents Window

(1)

Moving a Window by Dragging

(1)

Expanding an Area

(2)

Scrolling in a Window

(2)

Sizing a Window by Dragging

(1)

Collapsing an Area

(1)

Resizing a Window

(1)

Closing a Window

(1)

Deleting a Desktop Icon by Right-Dragging

(1)

Summary of Mouse and Windows Operations

(1)

The Keyboard and Keyboard Shortcuts

(1)

Launching an Application Program

(3)

Launching an Application Using the Start Menu

(2)

Windows Explorer

(10)

Launching Windows Explorer

(2)

Expanding a Folder

(1)

Expanding a Drive

(2)

Displaying Files and Folders in Windows Explorer

(1)

Displaying Drive and Folder Contents

(1)

Launching an Application Program from Windows Explorer

(3)

Closing Folder Expansions

(1)

Copying, Moving, Renaming, and Deleting Files in Windows Explorer

(7)

Copying Files in Windows Explorer

(1)

Displaying the Contents of the My Pictures Folder

(1)

Renaming Files and Folders

(2)

Deleting Files in Windows Explorer

(1)

Removing the Status Bar

(1)

Quitting Windows Explorer

(1)

Using Help and Support

(6)

Launching Help and Support

(2)

Browsing for Help Topics in the Table of Contents

(2)

Using the Help and Support Center Index

(2)

Logging Off and Turning Off the Computer

(4)

What Is Microsoft Office 2003?

(2)

The Internet, World Wide Web, and Intranets

(1)

Office and the Internet

(1)

Microsoft Office Word 2003

(2)

Word and the Internet

(1)

Microsoft Office Excel 2003

(2)

Excel and the Internet

(2)

Microsoft Office Access 2003

(2)

Access and the Internet

(2)

Microsoft Office PowerPoint 2003

(2)

PowerPoint and the Internet

(1)

The Web Toolbar

(1)

Microsoft Office Publisher 2003

(1)

Publisher and the Internet

(1)

Microsoft Office FrontPage 2003

(1)

Microsoft Office Outlook 2003

(2)

The Microsoft Office 2003 Help System

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

In the Lab

Microsoft® Office: Word 2003

Project One: Creating and Editing a Word Document

Objectives

(1)

What Is Microsoft Office Word 2003?

(1)

Project One --- Grand Prix Announcement

(1)

Starting and Customizing Word

(4)

The Word Window

(6)

Document Window

(2)

Menu Bar and Toolbars

(3)

Resetting Menus and Toolbars

(1)

Speech Recognition

(1)

Entering Text

(12)

Typing Text

(3)

Entering Blank Lines in a Document

(1)

Displaying Formatting Marks

(2)

Entering More Text

(1)

Using Wordwrap

(1)

Entering Text that Scrolls the Document Window

(2)

Checking Spelling and Grammar as You Type

(3)

Saving a Document

(3)

Formatting Paragraphs and Characters in a Document

(14)

Selecting and Formatting Paragraphs and Characters

(1)

Selecting Multiple Paragraphs

(1)

Changing the Font Size of Text

(2)

Changing the Font of Text

(1)

Right-Align a Paragraph

(2)

Center a Paragraph

(1)

Undoing, Redoing, and Repeating Commands or Actions

(1)

Selecting a Line and Formatting It

(1)

Italicizing Text

(1)

Underlining Text

(1)

Scrolling

(1)

Selecting a Group of Words

(1)

Bolding Text

(1)

Inserting Clip Art in a Word Document

(6)

Inserting Clip Art

(3)

Resizing a Graphic

(2)

Saving an Existing Document with the Same File Name

(2)

Printing a Document

(1)

Quitting Word

(1)

Starting Word and Opening a Document

(1)

Correcting Errors

(4)

Types of Changes Made to Documents

(1)

Inserting Text in an Existing Document

(1)

Deleting Text from an Existing Document

(1)

Closing the Entire Document

(1)

Word Help System

(2)

Using the Type a Question for Help Box

(2)

Quitting Word

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(2)

In the Lab

(4)

Cases and Places

(3)

Project Two: Creating a Research Paper

Objectives

(1)

Introduction

(1)

Project Two --- Biometrics Research Paper

(3)

MLA Documentation Style

(1)

Starting and Customizing Word

(1)

Displaying Formatting Marks

(1)

Changing the Margins

(2)

Adjusting Line Spacing

(2)

Using a Header to Number Pages

(3)

Headers and Footers

(1)

Entering Text Using Click and Type

(1)

Entering a Page Number into the Header

(1)

Typing the Body of a Research Paper

(18)

Applying Formatting Using Shortcut Keys

(2)

Saving the Research Paper

(1)

Indenting Paragraphs

(2)

Using Word's AutoCorrect Feature

(4)

Adding Footnotes

(2)

Modifying a Style

(5)

Using Word Count

100

(1)

Automatic Page Breaks

101

(1)

Recounting Words in a Document

102

(1)

Creating an Alphabetical Works Cited Page

102

(8)

Manual Page Breaks

103

(1)

Centering the Title of the Works Cited Page

104

(1)

Creating a Hanging Indent

104

(2)

Inserting Arrows, Faces, and Other Symbols Automatically

106

(1)

Creating a Hyperlink

107

(2)

Sorting Paragraphs

109

(1)

Proofing and Revising the Research Paper

110

(12)

Going to a Specific Location in a Document

110

(2)

Moving Text

112

(3)

Smart Tags

115

(1)

Finding and Replacing Text

116

(1)

Finding Text

117

(1)

Finding and Inserting a Synonym

118

(1)

Checking Spelling and Grammar at Once

119

(1)

Saving Again and Printing the Document

120

(1)

Working with Main and Custom Dictionaries

121

(1)

Navigating to a Hyperlink

122

(1)

E-Mailing a Copy of the Research Paper

123

(1)

Using the Research Task Pane

124

(2)

Project Summary

126

(1)

What You Should Know

127

(1)

Learn It Online

128

(1)

Apply Your Knowledge

129

(1)

In the Lab

130

(5)

Cases and Places

135

Microsoft® Office: Excel 2003

Project One: Creating a Worksheet and an Embedded Chart

Objectives

(1)

What Is Microsoft Office Excel 2003?

(1)

Project One --- Extreme Blading Second Quarter Sales

(1)

Starting and Customizing Excel

(3)

The Excel Worksheet

(2)

The Worksheet

(1)

Worksheet Window

(4)

Menu Bar

(2)

Standard Toolbar and Formatting Toolbar

(1)

Formula Bar

(1)

Status Bar

(1)

Speech Recognition and Speech Playback

(1)

Selecting a Cell

(1)

Entering Text

(5)

Entering the Worksheet Titles

(1)

Correcting a Mistake while Typing

(1)

AutoCorrect

(1)

Entering Column Titles

(1)

Entering Row Titles

(1)

Entering Numbers

(2)

Calculating a Sum

(1)

Using the Fill Handle to Copy a Cell to Adjacent Cells

(4)

Determining Multiple Totals at the Same Time

(2)

Formatting the Worksheet

(8)

Font Type, Style, Size, and Color

(1)

Changing the Font Type

(1)

Bolding a Cell

(1)

Increasing the Font Size

(1)

Changing the Font Color of a Cell Entry

(1)

Centering a Cell Entry across Columns by Merging Cells

(1)

Formatting the Worksheet Subtitle

(1)

Using AutoFormat to Format the Body of a Worksheet

(2)

Using the Name Box to Select a Cell

(2)

Adding a 3-D Clustered Column Chart to the Worksheet

(4)

Saving a Workbook

(2)

Printing a Worksheet

(2)

Quitting Excel

(1)

Starting Excel and Opening a Workbook

(1)

AutoCalculate

(2)

Correcting Errors

(3)

Correcting Errors While You Are Typing Data into a Cell

(1)

Correcting Errors After Entering Data into a Cell

(1)

Undoing the Last Cell Entry

(1)

Clearing a Cell or Range of Cells

(1)

Clearing the Entire Worksheet

(1)

Excel Help System

(2)

Obtaining Help Using the Type a Question for Help Box on the Menu Bar

(1)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

(3)

Project Two: Formulas, Functions, Formatting, and Web Queries

Objectives

(1)

Introduction

(1)

Project Two --- Blue Chip Stock Club Investment Analysis

(3)

Starting and Customizing Excel

(1)

Entering the Titles and Numbers into the Worksheet

(2)

Entering Formulas

(8)

Order of Operations

(1)

Entering Formulas Using Point Mode

(2)

Copying Formulas Using the Fill Handle

(1)

Smart Tags and Option Buttons

(1)

Determining Totals Using the AutoSum Button

(1)

Determining the Total Percent Gain/Loss

(1)

Using the AVERAGE, MAX, and MIN Functions

(9)

Determining the Average of a Range of Numbers

(1)

Determining the Highest Number in a Range of Numbers

(2)

Determining the Lowest Number in a Range of Numbers

(3)

Copying the AVERAGE, MAX, and MIN Functions

(1)

Saving a Workbook Using the Same File Name

(1)

Verifying Formulas Using Range Finder

(1)

Formatting the Worksheet

(21)

Changing the Font and Centering the Worksheet Title and Subtitle

(3)

Changing the Background and Font Colors and Applying a Box Border to the Worksheet Title and Subtitle

(2)

Applying Formats to the Column Titles

(1)

Centering the Stock Symbols and Formatting the Dates and Numbers in the Worksheet

(2)

Formatting Numbers Using the Formatting Toolbar

(2)

Applying a Thick Bottom Border to the Row above the Total Row and Bolding the Total Row Titles

100

(1)

Formatting Numbers Using the Format Cells Command on the Shortcut Menu

100

(2)

Formatting Numbers Using the Percent Style Button and Increase Decimal Button

102

(1)

Conditional Formatting

103

(4)

Changing the Widths of Columns and Heights of Rows

107

(1)

Changing the Widths of Columns

107

(3)

Changing the Heights of Rows

110

(1)

Checking Spelling

111

(2)

Previewing and Printing the Worksheet

113

(5)

Printing a Section of the Worksheet

116

(2)

Displaying and Printing the Formulas Version of the Worksheet

118

(2)

Changing the Print Scaling Option Back to 100%

120

(1)

Importing External Data from a Web Source Using a Web Query

120

(4)

Changing the Worksheet Names

124

(1)

E-Mailing a Workbook from within Excel

125

(2)

Saving the Workbook and Quitting Excel

126

(1)

Project Summary

127

(1)

What You Should Know

127

(2)

Learn It Online

129

(1)

Apply Your Knowledge

130

(2)

In the Lab

132

(10)

Cases and Places

142

Microsoft® Office: Access 2003

Project One: Creating and Using a Database

Objectives

(1)

What Is Microsoft Office Access 2003?

(1)

What Is New in Access?

(1)

Project One --- Ashton James College Database

(2)

Starting Access

(2)

Speech Recognition

(1)

Creating a New Database

(2)

The Access Window

(3)

Title Bar

(1)

Menu Bar

(1)

Toolbars

(1)

Taskbar

(1)

Status Bar

(1)

Database Window

(1)

Shortcut Menus

(2)

AutoCorrect

(1)

Creating a Table

(6)

Defining the Fields

(3)

Correcting Errors in the Structure

(1)

Closing and Saving a Table

(1)

Adding Records to a Table

(3)

Correcting Errors in the Data

(1)

Closing a Table and Database and Quitting Access

(1)

Opening a Database

(1)

Adding Additional Records

(2)

Previewing and Printing the Contents of a Table

(3)

Creating Additional Tables

(2)

Adding Records to the Additional Table

(1)

Using Queries

(4)

Using a Query

(2)

Using a Form to View Data

(4)

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

(1)

Creating a Report

(5)

Printing the Report

(1)

Closing the Database

(1)

Access Help System

(3)

Obtaining Help Using the Type a Question for Help Box on the Menu Bar

(2)

Quitting Access

(1)

Designing a Database

(2)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(2)

In the Lab

(7)

Cases and Places

(3)

Project Two: Querying a Database Using the Select Query Window

Objectives

(1)

Introduction

(1)

Project Two --- Querying the Ashton James College Database

(2)

Opening the Database

(1)

Creating and Running Queries

(7)

Using the Select Query Window

(1)

Displaying Selected Fields in a Query

(1)

Running a Query

(1)

Printing the Results of a Query

(1)

Returning to the Select Query Window

(1)

Closing a Query

(1)

Including All Fields in a Query

(1)

Clearing the Design Grid

(1)

Entering Criteria

(10)

Using Text Data in Criteria

(1)

Using Wildcards

(1)

Criteria for a Field Not in the Result

(2)

Creating a Parameter Query

(1)

Saving a Query

(1)

Using a Saved Query

(1)

Using Numeric Data in Criteria

(1)

Using Comparison Operators

(1)

Using Compound Criteria

(1)

Using AND Criteria

(1)

Using OR Criteria

(1)

Sorting Data in a Query

(5)

Omitting Duplicates

(1)

Sorting on Multiple Keys

(1)

Creating a Top-Values Query

(1)

Joining Tables

(6)

Changing Join Properties

(2)

Restricting Records in a Join

(1)

Calculations

(8)

Using Calculated Fields

(2)

Changing Format and Caption

(1)

Calculating Statistics

(2)

Using Criteria in Calculating Statistics

101

(1)

Grouping

102

(2)

Crosstab Queries

104

(2)

Closing a Database and Quitting Access

106

(1)

Project Summary

106

(1)

What You Should Know

107

(1)

Learn It Online

108

(1)

Apply Your Knowledge

109

(1)

In the Lab

110

(2)

Cases and Places

112

Microsoft® Office: PowerPoint 2003

Project One: Using a Design Template and Text Slide Layout to Create a Presentation

Objectives

(3)

What Is Microsoft Office PowerPoint 2003?

(1)

Project One --- Strategies for College Success

(1)

Starting and Customizing PowerPoint

(3)

The PowerPoint Window

(7)

PowerPoint Views

(1)

Placeholders, Text Areas, Mouse Pointer, and Scroll Bars

(1)

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

(4)

Speech Recognition

(1)

Choosing a Design Template

(3)

Creating a Title Slide

(3)

Entering the Presentation Title

(1)

Correcting a Mistake When Typing

(1)

Entering the Presentation Subtitle

(1)

Text Attributes

(3)

Changing the Style of Text to Italic

(1)

Changing the Font Size

(1)

Saving the Presentation on a Floppy Disk

(3)

Adding a New Slide to a Presentation

(2)

Creating a Text Slide with a Single-Level Bulleted List

(3)

Entering a Slide Title

(1)

Selecting a Text Placeholder

(1)

Typing a Single-Level Bulleted List

(2)

Creating a Text Slide with a Multi-Level Bulleted List

(7)

Adding New Slides and Entering Slide Titles

(1)

Typing a Multi-Level Bulleted List

(4)

Creating a Third-Level Paragraph

(2)

Ending a Slide Show with a Black Slide

(1)

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 in Slide Show View

(4)

Starting Slide Show View

(1)

Advancing Through a Slide Show Manually

(1)

Using the Popup Menu to Go to a Specific Slide

(1)

Using the Popup Menu to End a Slide Show

(1)

Quitting PowerPoint

(1)

Starting PowerPoint and Opening a Presentation

(2)

Checking a Presentation for Spelling and Consistency

(3)

Checking a Presentation for Spelling Errors

(1)

Starting the Spelling Checker

(2)

Correcting Errors

(1)

Types of Corrections Made to Presentations

(1)

Deleting Text

(1)

Replacing Text in an Existing Slide

(1)

Displaying a Presentation in Black and White

(3)

Printing a Presentation

(3)

Saving Before Printing

(1)

Printing the Presentation

(1)

Making a Transparency

(1)

PowerPoint Help System

(3)

Obtaining Help Using the Type a Question for Help Box on the Menu Bar

(2)

Quitting PowerPoint

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(1)

In the Lab

(10)

Cases and Places

(3)

Project Two: Using the Outline Tab and Clip Art to Create a Slide Show

Objectives

(1)

Introduction

(1)

Project Two --- Healthy Eating, Healthy Living

(2)

Starting and Customizing PowerPoint

(1)

Using the Outline Tab

(3)

Creating a Presentation on the Outline Tab

(1)

Creating a Title Slide on the Outline Tab

(1)

Adding a Slide on the Outline Tab

(1)

Creating Text Slides with Multi-Level Bulleted Lists on the Outline Tab

(4)

Creating a Second Text Slide with a Multi-Level Bulleted List

(1)

Creating a Third Text Slide with a Multi-Level Bulleted List

(1)

Creating a Closing Slide on the Outline Tab

(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 a Content Placeholder

100

(3)

Inserting a Second Clip into a Slide

103

(1)

Inserting Clip Art into a Slide without a Content Placeholder

104

(2)

Smart Tags

106

(1)

Using the Automatic Layout Options Button to Undo a Layout Change

107

(1)

Moving Clip Art

108

(1)

Changing the Size of Clip Art

108

(2)

Inserting, Moving, and Sizing a Clip into a Slide

110

(2)

Saving the Presentation Again

111

(1)

Adding a Header and Footer to Outline Pages

112

(2)

Using the Notes and Handouts Sheet to Add Headers and Footers

112

(2)

Applying Animation Schemes

114

(2)

Adding an Animation Scheme to a Slide Show

114

(2)

Animating Clip Art

116

(4)

Adding Animation Effects

116

(3)

Saving the Presentation Again

119

(1)

Running an Animated Slide Show

120

(2)

Printing a Presentation Created on the Outline Tab

122

(4)

Printing an Outline

122

(3)

Printing Presentation Slides

125

(1)

E-Mailing a Slide Show from within PowerPoint

126

(2)

Saving and Quitting PowerPoint

128

(1)

Project Summary

128

(1)

What You Should Know

129

(1)

Learn It Online

130

(1)

Apply Your Knowledge

131

(1)

In the Lab

132

(6)

Cases and Places

138

(3)

Web Feature: Creating a Presentation on the Web Using PowerPoint

Objectives

141

(1)

Introduction

141

(2)

Using Web Page Preview and Saving a PowerPoint Presentation as a Web Page

143

(8)

Previewing the Presentation as a Web Page

143

(3)

Saving a PowerPoint Presentation as a Web Page to a New Folder

146

(3)

File Management Tools in PowerPoint

149

(1)

Viewing the Web Page Using Your Browser

149

(2)

Editing a Web Page through a Browser

151

(3)

Publishing a Web Page

154

(3)

Web Feature Summary

157

(1)

What You Should Know

157

(1)

In the Lab

158

Appendix A. Microsoft Office Help System

Using the Microsoft Office Help System

(1)

Navigating the Word Help System

(6)

The Office Assistant

(1)

Question Mark Button in Dialog Boxes and Help Icon in Task Panes

(1)

Other Help Commands on the Help Menu

(2)

Use Help

(1)

Appendix B. Speech and Handwriting Recognition and Speech Playback

Introduction

(4)

The Language Bar

(1)

Buttons on the Language Bar

(1)

Customizing the Language Bar

(3)

Speech Recognition

(4)

Getting Started with Speech Recognition

(2)

Using Speech Recognition

(1)

Handwriting Recognition

(3)

Writing Pad

(2)

Write Anywhere

(1)

Drawing Pad

(1)

On-Screen Keyboard

(1)

Speech Playback

(2)

Customizing Speech Playback

(1)

Appendix C. Publishing Office Web Pages to a Web Server

Using Web Folders to Publish Office Web Pages

(1)

Using FTP to Publish Office Web Pages

(1)

Appendix D. Changing Screen Resolution and Resetting the Word Toolbars and Menus

Changing Screen Resolution

(2)

Resetting the Word Toolbars and Menus

(4)

Resetting the Standard and Formatting Toolbars

(2)

Resetting the Word Menus

(2)

Appendix E. Microsoft Office Specialist Certification

What Is Microsoft Office Specialist Certification?

(1)

Why Should You Be Certified?

(1)

The Microsoft Office Specialist Certification Exams

(1)

How to Prepare for the Microsoft Office Specialist Certification Exams

(1)

How to Find an Authorized Testing Center

(1)

Shelly Cashman Series Microsoft Office Specialist Center

Index

(1)

Quick Reference Summary

Microsoft Office 2003 CourseCard

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 2003: Brief Concepts and Techniques

1418859486

Summary

Table of Contents

Supplemental Materials

Rewards Program