Amazon no longer offers textbook rentals. We do!

Microsoft Office 2003: Introductory Concepts and Techniques, Premium Edition

by: Shelly,Gary B.

Microsoft Office 2003: Introductory Concepts and Techniques, Premium Edition

by: Shelly,Gary B.

ISBN 13:
9781418859312
ISBN 10:
1418859311
Edition: CD
Format: Paperback
Copyright: 02/03/2006
Publisher: Cengage Learning

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

This exciting Premium Edition, from the Shelly Cashman Series, includes sufficient material for a first course on Office 2003 applications. This book offers our Premium Edition SAM Training Companion CD that helps students reinforce key skills with case studies and tools on the Online Companion. With the Shelly Cashman Series' project-oriented, step-by-step pedagogy, and full-color screenshots, students will easily grasp skills and stay on track.

Preface

xii

To the Student

xxii

Essential Introduction to Computers

Objectives

(1)

What Is a Computer?

(1)

What Does a Computer Do?

(1)

Why Is a Computer so Powerful?

(1)

How Does a Computer Know What to Do?

(1)

What Are the Components of a Computer?

(1)

Input Devices

(3)

The Keyboard

(2)

The Mouse

(1)

System Unit

(1)

Processor

(1)

Memory

(1)

Output Devices

(2)

Printers

(1)

Display Devices

(1)

Storage Devices

(7)

Magnetic Disks

(3)

Optical Disks

(2)

Tape

(1)

Miniature Mobile Storage Media

(2)

Communications Devices

(1)

Computer Software

(2)

System Software

(1)

Application Software

(1)

Networks and the Internet

(4)

The Internet

(1)

The World Wide Web

(2)

Electronic Commerce

(1)

How to Purchase a Personal Computer

(2)

How to Purchase a Desktop Computer

(6)

How to Purchase a Notebook Computer

(3)

How to Purchase a Tablet PC

(2)

How to Purchase a Personal Mobile Device

(2)

Learn It Online

(1)

Index

(1)

Photo Credits

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

(1)

Microsoft Windows XP Professional

(5)

Windows XP Service Pack 2

(1)

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

(23)

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

(2)

Closing a Window

(1)

Opening a Window Using the Start Menu

(1)

The My Documents Window

(1)

Moving a Window by Dragging

(1)

Expanding an Area

(1)

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)

Starting an Application Program

(3)

Starting an Application Using the Start Menu

(2)

Windows Explorer

(12)

Starting Windows Explorer

(2)

Using a Hierarchical Format to Organize Files and Folders

(1)

Removable Media

(1)

Plugging a USB Flash Drive into a USB Port

(2)

Naming a Folder

(1)

Creating a Folder on a Removable Drive

(1)

Downloading a Hierarchy of Folders into the Freshman Folder

(1)

Expanding a Drive

(1)

Expanding a Folder

(1)

Displaying Drive and Folder Contents

(2)

Creating a Document and Folder in Microsoft Word

(6)

Starting Word

(1)

Typing Text

(1)

Saving a Document in a New Folder

(3)

Verify the Contents of a Folder

(1)

File Management in Windows Explorer

(6)

Copying Files in Windows Explorer

(1)

Displaying the Contents of the Homework Folder

(1)

Renaming Files and Folders

(2)

Deleting Files in Windows Explorer

(1)

Closing Folder Expansions

(1)

Quitting Windows Explorer

(1)

Finding Files or Folders

(5)

Searching for a File by Name

(4)

Searching for a File by Using a Word or Phrase in the File

(1)

Using Help and Support

(6)

Starting 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

(3)

What Is Microsoft Office 2003?

(1)

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

(1)

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

(3)

Project Three Creating a Resume Using a Wizard and a Cover Letter with a Table

Objectives

138

(1)

Introduction

138

(1)

Project Three --- Resume and Cover Letter

139

(2)

Starting and Customizing Word

140

(1)

Displaying Formatting Marks

141

(1)

Using Word's Resume Wizard to Create a Resume

141

(9)

Personalizing the Resume

150

(10)

Tables

150

(1)

Styles

151

(1)

Selecting and Replacing Text

152

(2)

Entering a Line Break

154

(1)

AutoFormat As You Type

155

(3)

Viewing and Printing the Resume in Print Preview

158

(1)

Saving the Resume

159

(1)

Creating a Letterhead

160

(15)

Opening a New Document Window

160

(1)

Changing Color of Text

161

(1)

Inserting and Resizing a Graphic

162

(1)

Setting Tab Stops Using the Tabs Dialog Box

163

(2)

Collecting and Pasting

165

(7)

Adding a Bottom Border to a Paragraph

172

(1)

Clearing Formatting

173

(2)

Creating a Cover Letter

175

(15)

Components of a Business Letter

175

(1)

Saving the Cover Letter with a New File Name

175

(1)

Setting Tab Stops Using the Ruler

176

(1)

Inserting the Current Date in a Document

177

(1)

Creating an AutoText Entry

178

(2)

Entering a Nonbreaking Space

180

(1)

Inserting an AutoText Entry

181

(1)

Creating a Table with the Insert Table Button

182

(1)

Entering Data in a Word Table

183

(2)

Resizing Table Columns

185

(1)

Changing the Table Alignment

186

(1)

Bulleting a List

187

(2)

Saving Again and Printing the Cover Letter

189

(1)

Addressing and Printing Envelopes and Mailing Labels

190

(1)

Smart Tags

191

(2)

Document Summary

193

(2)

Project Summary

195

(1)

What You Should Know

195

(2)

Learn It Online

197

(1)

Apply Your Knowledge

198

(1)

In the Lab

199

(2)

Cases and Places

201

(2)

Web Feature Creating Web Pages Using Word

Objectives

203

(1)

Introduction

203

(2)

Saving a Word Document as a Web Page

205

(1)

Formatting and Previewing a Web Page

206

(3)

Formatting the E-Mail Address as a Hyperlink

206

(1)

Applying a Theme to the Web Page

207

(1)

Viewing the Web Page in Your Default Browser

208

(1)

Creating and Modifying a Frames Page

209

(6)

Web Feature Summary

215

(1)

What You Should Know

215

(1)

In the Lab

216

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

(8)

Cases and Places

140

(6)

Project Three What-If Analysis, Charting, and Working with Large Worksheets

Objectives

146

(1)

Introduction

146

(2)

Project Three --- Aquatics Wear Six-Month Financial Projection

148

(3)

Starting and Customizing Excel

149

(1)

Bolding the Font of the Entire Worksheet

150

(1)

Entering the Worksheet Titles and Saving the Workbook

150

(1)

Rotating Text and Using the Fill Handle to Create a Series

151

(3)

Copying a Cell's Format Using the Format Painter Button

154

(3)

Increasing the Column Widths and Indenting Row Titles

155

(2)

Copying a Range of Cells to a Nonadjacent Destination Area

157

(2)

Using Drag and Drop to Move or Copy Cells

159

(1)

Using Cut and Paste to Move or Copy Cells

159

(1)

Inserting and Deleting Cells in a Worksheet

159

(3)

Inserting Rows

159

(2)

Inserting Columns

161

(1)

Inserting Single Cells or a Range of Cells

161

(1)

Deleting Columns and Rows

161

(1)

Deleting Individual Cells or a Range of Cells

162

(1)

Entering Numbers with Format Symbols

162

(1)

Freezing Worksheet Titles

163

(2)

Entering the Projected Monthly Total Net Revenues

164

(1)

Displaying a System Date

165

(3)

Absolute versus Relative Addressing

168

(2)

Entering a Formula Containing Absolute Cell References

169

(1)

Making Decisions -- The IF Function

170

(7)

Entering the Remaining Formulas

173

(1)

Copying Formulas with Absolute Cell References

174

(1)

Determining Row Totals in Nonadjacent Cells

175

(1)

Unfreezing Worksheet Titles and Saving the Workbook

175

(1)

Nested Forms of the IF Function

176

(1)

Formatting the Worksheet

177

(10)

Formatting the Numbers

177

(3)

Formatting the Worksheet Titles

180

(1)

Showing the Drawing Toolbar

181

(1)

Moving and Docking a Toolbar

182

(1)

Adding a Drop Shadow

183

(1)

Formatting Nonadjacent Cells

184

(2)

Formatting the Assumptions Table

186

(1)

Hiding the Drawing Toolbar and Saving the Workbook

187

(1)

Adding a 3-D Pie Chart to the Workbook

187

(10)

Drawing a 3-D Pie Chart on a Separate Chart Sheet

188

(4)

Formatting the Chart Title and Data Labels

192

(1)

Changing the Colors of Slices in a Pie Chart

193

(1)

Exploding the 3-D Pie Chart

194

(1)

Rotating and Tilting the 3-D Pie Chart

194

(3)

Showing Leader Lines with the Data Labels

197

(1)

Renaming and Reordering the Sheets and Coloring Their Tabs

197

(2)

Checking Spelling, Saving, Previewing, and Printing the Workbook

199

(2)

Checking Spelling in Multiple Sheets

199

(1)

Previewing and Printing the Workbook

200

(1)

Changing the View of the Worksheet

201

(3)

Shrinking and Magnifying the View of a Worksheet or Chart

201

(1)

Splitting the Window into Panes

202

(2)

What-If Analysis

204

(4)

Analyze Data in a Worksheet by Changing Values

204

(2)

Goal Seeking

206

(2)

Quitting Excel

208

(1)

Project Summary

208

(1)

What You Should Know

209

(1)

Learn It Online

210

(1)

Apply Your Knowledge

211

(1)

In the Lab

212

(10)

Cases and Places

222

(3)

Web Feature Creating Static and Dynamic Web Pages Using Excel

Objectives

225

(1)

Introduction

225

(3)

Using Web Page Preview and Saving an Excel Workbook as a Static Web Page

228

(6)

Web Page Preview

228

(2)

Saving a Workbook as a Static Web Page in a New Folder

230

(2)

File Management Tools in Excel

232

(1)

Viewing the Static Web Page Using a Browser

233

(1)

Saving an Excel Chart as a Dynamic Web Page

234

(4)

Viewing and Manipulating the Dynamic Web Page Using a Browser

236

(1)

Modifying the Worksheet on a Dynamic Web Page

237

(1)

Web Feature Summary

238

(1)

What You Should Know

239

(1)

In the Lab

239

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

(2)

Project Three Maintaining a Database Using the Design and Update Features of Access

Objectives

114

(1)

Introduction

114

(1)

Project Three --- Maintaining the Ashton James College Database

115

(1)

Opening the Database

115

(1)

Updating Records

116

(4)

Adding Records

116

(1)

Searching for a Record

117

(2)

Changing the Contents of a Record

119

(1)

Switching Between Views

119

(1)

Filtering Records

120

(6)

Using Filter By Selection

121

(1)

Using Filter By Form

122

(1)

Using Advanced Filter/Sort

123

(2)

Deleting Records

125

(1)

Changing the Structure

126

(5)

Changing the Size of a Field

127

(1)

Adding a New Field

128

(2)

Deleting a Field

130

(1)

Updating the Restructured Database

130

(1)

Changing the Appearance of a Datasheet

131

(4)

Resizing Columns

131

(2)

Formatting a Datasheet

133

(2)

Mass Changes

135

(4)

Using an Update Query

136

(1)

Using a Delete Query

137

(2)

Using Append and Make-Table Queries

139

(1)

Validation Rules

139

(11)

Specifying a Required Field

139

(1)

Specifying a Range

140

(1)

Specifying a Default Value

141

(1)

Specifying a Collection of Legal Values

142

(1)

Using a Format

143

(1)

Saving Rules, Values, and Formats

144

(1)

Updating a Table that Contains Validation Rules

145

(1)

Creating a Lookup Field

146

(3)

Using a Lookup Field

149

(1)

Referential Integrity

150

(5)

Specifying Referential Integrity

150

(3)

Using Subdatasheets

153

(1)

Finding Duplicate Records

154

(1)

Finding Unmatched Records

154

(1)

Ordering Records

155

(2)

Using the Sort Ascending Button to Order Records

155

(1)

Ordering Records on Multiple Fields

156

(1)

Creating and Using Indexes

157

(5)

How Does Access Use an Index?

159

(1)

When Should You Create an Index?

159

(1)

Creating Single-Field Indexes

159

(1)

Creating Multiple-Field Indexes

160

(2)

Closing the Database and Quitting Access

162

(1)

Special Database Operations

162

(2)

Backup and Recovery

162

(1)

Compacting and Repairing a Database

163

(1)

Project Summary

164

(1)

What You Should Know

165

(1)

Learn It Online

166

(1)

Apply Your Knowledge

167

(1)

In the Lab

168

(3)

Cases and Places

171

(2)

Integration Feature Sharing Data among Applications

Objectives

173

(1)

Introduction

173

(3)

Convert Data from Other Applications to Access

176

(5)

Creating an Access Database

176

(1)

Importing an Excel Worksheet

176

(4)

Using the Access Table

180

(1)

Linking versus Importing

180

(1)

Closing the Database

181

(1)

Copy Data from Access to Other Applications

181

(4)

Opening the Database

181

(1)

Using the Export Command to Export Data to Excel

181

(1)

Using Drag-and-Drop to Export Data to Word

182

(2)

Using the Export Command to Create a Snapshot

184

(1)

XML

185

(5)

Exporting XML Data

185

(2)

Creating an Access Database

187

(1)

Importing XML Data

187

(3)

Closing the Database

190

(1)

Integration Feature Summary

190

(1)

What You Should Know

190

(1)

In the Lab

191

Microsoft Office PowerPoint 2003

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

Objectives

(1)

What Is Microsoft Office PowerPoint 2003?

(3)

Project One --- Strategies for College Success

(1)

Starting and Customizing PowerPoint

(3)

The PowerPoint Window

(6)

PowerPoint Views

(1)

Placeholders, Text Areas, Mouse Pointer, and Scroll Bars

(1)

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

(3)

Speech Recognition

(1)

Choosing a Design Template

(3)

Creating a Title Slide

(3)

Entering the Presentation Title

(2)

Correcting a Mistake When Typing

(1)

Entering the Presentation Subtitle

(1)

Text Attributes

(4)

Changing the Style of Text to Italic

(1)

Changing the Font Size

(2)

Saving the Presentation on a USB Flash Drive

(3)

Adding a New Slide to a Presentation

(1)

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

(1)

Creating a Text Slide with a Multi-Level Bulleted List

(8)

Adding New Slides and Entering Slide Titles

(1)

Typing a Multi-Level Bulleted List

(3)

Creating a Third-Level Paragraph

(3)

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

(3)

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

(3)

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

(9)

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

(3)

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

Microsoft Office Outlook 2003

Project One E-Mail and Contact Management with Outlook

Objectives

(1)

What Is Microsoft Office Outlook 2003?

(2)

Project One --- Communicating Over the Internet

(1)

Electronic Mail (E-Mail)

(32)

Starting and Customizing Outlook

(2)

The Inbox - Microsoft Outlook Window

(3)

Opening and Reading E-Mail Messages

(1)

Printing an E-Mail Message

(1)

Closing an E-Mail Message

(1)

Replying to an E-Mail Message

(2)

Forwarding an E-Mail Message

(1)

Deleting an E-Mail Message

(2)

Viewing a File Attachment

(1)

Creating an E-Mail Signature

(4)

Creating Unique E-Mail Signatures for Multiple Accounts

(1)

Composing a New Mail Message

(3)

Formatting an E-Mail Message

(1)

Attaching a File to an E-Mail Message

(2)

Sending an E-Mail Message

(1)

Flagging, Sorting, and Filtering E-Mail Messages

(5)

Setting E-Mail Message Importance, Sensitivity, and Delivery Options

(4)

Using Search Folders to Display Categories of E-Mail Messages

(1)

Contacts

(20)

Creating a Personal Folder

(2)

Creating a Contact List

(3)

Changing the View and Sorting the Contacts List

(2)

Finding a Contact

(1)

Organizing Contacts

(2)

Displaying the Contacts in a Category

(1)

Previewing and Printing the Contact List

(2)

Using the Contact List to Address an E-Mail Message

(2)

Creating and Modifying a Distribution List

(3)

Saving Outlook Information in Different Formats

(2)

Tracking Activities for Contacts

(1)

Quitting Outlook

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(1)

In the Lab

(3)

Cases and Places

Microsoft Office 2003 Integration

Project One Integrating Office 2003 Applications and the World Wide Web

Objectives

(1)

Introduction

(1)

Integration Project --- Leland Mortgage Web Site

(3)

Adding Hyperlinks to a Word Document

(6)

Starting Word and Opening a Document

(1)

Inserting a Table into a Word Document

(1)

Eliminating the Table Border

(1)

Inserting the Text for the Hyperlinks

(1)

Inserting a Hyperlink to PowerPoint Web Pages

(2)

Embedding an Excel Chart into a Word Document

(5)

Changing the Size of an Embedded Object

(3)

Quitting Excel

(1)

Adding Scrolling Text to a Word Document

(4)

Inserting Scrolling Text

(2)

Resizing the Scrolling Text

(1)

Viewing the Word Document in Your Browser and Saving It as a Web Page

(3)

Creating a PowerPoint Presentation Web Page

(4)

Adding Text for a Hyperlink

(1)

Creating a Hyperlink

(1)

Viewing and Saving the PowerPoint Web Page

(2)

Saving the PowerPoint Presentation as a Web Page

(1)

Creating a Data Access Page from an Access Database

(8)

Creating a Data Access Page Using the Page Wizard

(2)

Adding a Title and Resizing a Label on a Data Access Page

(2)

Adding a Hyperlink to a Data Access Page

(1)

Saving the Data Access Page and Viewing It

(1)

Testing the Web Site

(2)

Verifying the Hyperlinks in Your Browser

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

In the Lab

(5)

Cases and Places

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

(3)

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

(1)

Microsoft Office Specialist Certification Maps

Microsoft Office Word 2003

(3)

Microsoft Office Excel 2003

(2)

Microsoft Office Access 2003

(2)

Microsoft Office PowerPoint 2003

(1)

Microsoft Office Outlook 2003

Index

(1)

Quick Reference Summary

(1)

SAM 2003 Training Companion Task Reference

File Management FastCARD

Amazon no longer offers textbook rentals. We do!

Microsoft Office 2003: Introductory Concepts and Techniques, Premium Edition

Microsoft Office 2003: Introductory Concepts and Techniques, Premium Edition

9781418859312

1418859311

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Microsoft Office 2003: Introductory Concepts and Techniques, Premium Edition

Microsoft Office 2003: Introductory Concepts and Techniques, Premium Edition

9781418859312

1418859311

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products