Title:
Microsoft Office 2003 introductory concepts and techniques
Personal Author:
Series:
Shelly Cashman series
Edition:
Premium ed.
Publication Information:
Boston, MA : Thomson/Course Technology, 2007
Physical Description:
1 CD-ROM ; 12 cm.
ISBN:
9781418859312
General Note:
Accompanies text of the same title : HF5548.4.M525 S524 2007 f
Subject Term:
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
---|---|---|---|---|---|
Searching... | 30000010119567 | CP 11998 | Computer File Accompanies Open Access Book | Compact Disc Accompanies Open Access Book | Searching... |
On Order
Summary
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.
Table of Contents
Preface | p. xii |
To the Student | p. xxii |
Essential Introduction to Computers | |
Objectives | p. COM-1 |
What Is a Computer? | p. COM-2 |
What Does a Computer Do? | p. COM-3 |
Why Is a Computer so Powerful? | p. COM-4 |
How Does a Computer Know What to Do? | p. COM-4 |
What Are the Components of a Computer? | p. COM-4 |
Input Devices | p. COM-5 |
The Keyboard | p. COM-5 |
The Mouse | p. COM-7 |
System Unit | p. COM-8 |
Processor | p. COM-8 |
Memory | p. COM-8 |
Output Devices | p. COM-9 |
Printers | p. COM-9 |
Display Devices | p. COM-10 |
Storage Devices | p. COM-11 |
Magnetic Disks | p. COM-11 |
Optical Disks | p. COM-14 |
Tape | p. COM-16 |
Miniature Mobile Storage Media | p. COM-16 |
Communications Devices | p. COM-18 |
Computer Software | p. COM-18 |
System Software | p. COM-18 |
Application Software | p. COM-19 |
Networks and the Internet | p. COM-20 |
The Internet | p. COM-21 |
The World Wide Web | p. COM-21 |
Electronic Commerce | p. COM-23 |
How to Purchase a Personal Computer | p. COM-24 |
How to Purchase a Desktop Computer | p. COM-26 |
How to Purchase a Notebook Computer | p. COM-32 |
How to Purchase a Tablet PC | p. COM-35 |
How to Purchase a Personal Mobile Device | p. COM-37 |
Learn It Online | p. COM-39 |
Index | p. COM-40 |
Photo Credits | p. COM-40 |
Microsoft Windows XP and Office 2003 | |
Project 1 Introduction to Microsoft Windows XP and Office 2003 | |
Objectives | p. WIN 4 |
Introduction | p. WIN 4 |
Microsoft Windows XP Operating Systems | p. WIN 5 |
Microsoft Windows XP Professional | p. WIN 6 |
The Windows XP Desktop | p. WIN 11 |
The Keyboard and Keyboard Shortcuts | p. WIN 34 |
Starting an Application Program | p. WIN 34 |
Windows Explorer | p. WIN 37 |
Creating a Document and Folder in Microsoft Word | p. WIN 49 |
File Management in Windows Explorer | p. WIN 55 |
Finding Files or Folders | p. WIN 61 |
Using Help and Support | p. WIN 66 |
Logging Off and Turning Off the Computer | p. WIN 72 |
What Is Microsoft Office 2003? | p. WIN 75 |
Microsoft Office Word 2003 | p. WIN 76 |
Microsoft Office Excel 2003 | p. WIN 78 |
Microsoft Office Access 2003 | p. WIN 80 |
Microsoft Office PowerPoint 2003 | p. WIN 82 |
The Web Toolbar | p. WIN 84 |
Microsoft Office Publisher 2003 | p. WIN 85 |
Microsoft Office FrontPage 2003 | p. WIN 86 |
Microsoft Office Outlook 2003 | p. WIN 87 |
The Microsoft Office 2003 Help System | p. WIN 89 |
Project Summary | p. WIN 89 |
What You Should Know | p. WIN 90 |
Learn It Online | p. WIN 91 |
In the Lab | p. WIN 92 |
Microsoft Office Word 2003 | |
Project 1 Creating and Editing a Word Document | |
Objectives | p. WD 4 |
What Is Microsoft Office Word 2003? | p. WD 4 |
Project One - Grand Prix Announcement | p. WD 5 |
Starting and Customizing Word | p. WD 6 |
The Word Window | p. WD 10 |
Speech Recognition | p. WD 16 |
Entering Text | p. WD 16 |
Saving a Document | p. WD 28 |
Formatting Paragraphs and Characters in a Document | p. WD 31 |
Inserting Clip Art in a Word Document | p. WD 45 |
Saving an Existing Document with the Same File Name | p. WD 51 |
Printing a Document | p. WD 53 |
Quitting Word | p. WD 54 |
Starting Word and Opening a Document | p. WD 55 |
Correcting Errors | p. WD 56 |
Word Help System | p. WD 60 |
Project Summary | p. WD 62 |
What You Should Know | p. WD 63 |
Learn It Online | p. WD 64 |
Apply Your Knowledge | p. WD 65 |
In the Lab | p. WD 67 |
Cases and Places | p. WD 71 |
Project 2 Creating a Research Paper | |
Objectives | p. WD 74 |
Introduction | p. WD 74 |
Project Two - Biometrics Research Paper | p. WD 74 |
Changing the Margins | p. WD 77 |
Adjusting Line Spacing | p. WD 79 |
Using a Header to Number Pages | p. WD 81 |
Typing the Body of a Research Paper | p. WD 84 |
Creating an Alphabetical Works Cited Page | p. WD 102 |
Proofing and Revising the Research Paper | p. WD 110 |
Navigating to a Hyperlink | p. WD 122 |
E-Mailing a Copy of the Research Paper | p. WD 123 |
Using the Research Task Pane | p. WD 124 |
Project Summary | p. WD 126 |
What You Should Know | p. WD 127 |
Learn It Online | p. WD 128 |
Apply Your Knowledge | p. WD 129 |
In the Lab | p. WD 130 |
Cases and Places | p. WD 135 |
Project 3 Creating a Resume Using a Wizard and a Cover Letter with a Table | |
Objectives | p. WD 138 |
Introduction | p. WD 138 |
Project Three - Resume and Cover Letter | p. WD 139 |
Using Word's Resume Wizard to Create a Resume | p. WD 141 |
Personalizing the Resume | p. WD 150 |
Creating a Letterhead | p. WD 160 |
Creating a Cover Letter | p. WD 175 |
Addressing and Printing Envelopes and Mailing Labels | p. WD 190 |
Smart Tags | p. WD 191 |
Document Summary | p. WD 193 |
Project Summary | p. WD 195 |
What You Should Know | p. WD 195 |
Learn It Online | p. WD 197 |
Apply Your Knowledge | p. WD 198 |
In the Lab | p. WD 199 |
Cases and Places | p. WD 201 |
Web Feature: Creating Web Pages Using Word | |
Objectives | p. WD 203 |
Introduction | p. WD 203 |
Saving a Word Document as a Web Page | p. WD 205 |
Formatting and Previewing a Web Page | p. WD 206 |
Creating and Modifying a Frames Page | p. WD 209 |
Web Feature Summary | p. WD 215 |
What You Should Know | p. WD 215 |
In the Lab | p. WD 216 |
Microsoft Office Excel 2003 | |
Project 1 Creating a Worksheet and an Embedded Chart | |
Objectives | p. EX 4 |
What Is Microsoft Office Excel 2003? | p. EX 4 |
Project One - Extreme Blading Second Quarter Sales | p. EX 5 |
Starting and Customizing Excel | p. EX 6 |
The Excel Worksheet | p. EX 9 |
Worksheet Window | p. EX 11 |
Speech Recognition and Speech Playback | p. EX 15 |
Selecting a Cell | p. EX 16 |
Entering Text | p. EX 16 |
Entering Numbers | p. EX 21 |
Calculating a Sum | p. EX 23 |
Using the Fill Handle to Copy a Cell to Adjacent Cells | p. EX 24 |
Formatting the Worksheet | p. EX 28 |
Using the Name Box to Select a Cell | p. EX 36 |
Adding a 3-D Clustered Column Chart to the Worksheet | p. EX 38 |
Saving a Workbook | p. EX 42 |
Printing a Worksheet | p. EX 44 |
Quitting Excel | p. EX 46 |
Starting Excel and Opening a Workbook | p. EX 47 |
AutoCalculate | p. EX 48 |
Correcting Errors | p. EX 50 |
Excel Help System | p. EX 53 |
Project Summary | p. EX 55 |
What You Should Know | p. EX 55 |
Learn It Online | p. EX 56 |
Apply Your Knowledge | p. EX 57 |
In the Lab | p. EX 58 |
Cases and Places | p. EX 63 |
Project 2 Formulas, Functions, Formatting, and Web Queries | |
Objectives | p. EX 66 |
Introduction | p. EX 66 |
Project Two - Blue Chip Stock Club Investment Analysis | p. EX 67 |
Entering the Titles and Numbers into the Worksheet | p. EX 70 |
Entering Formulas | p. EX 72 |
Using the AVERAGE, MAX, and MIN Functions | p. EX 80 |
Verifying Formulas Using Range Finder | p. EX 89 |
Formatting the Worksheet | p. EX 90 |
Checking Spelling | p. EX 111 |
Previewing and Printing the Worksheet | p. EX 113 |
Displaying and Printing the Formulas Version of the Worksheet | p. EX 118 |
Importing External Data from a Web Source Using a Web Query | p. EX 120 |
Changing the Worksheet Names | p. EX 124 |
E-Mailing a Workbook from within Excel | p. EX 125 |
Project Summary | p. EX 127 |
What You Should Know | p. EX 127 |
Learn It Online | p. EX 129 |
Apply Your Knowledge | p. EX 130 |
In the Lab | p. EX 132 |
Cases and Places | p. EX 140 |
Project 3 What-If Analysis, Charting, and Working with Large Worksheets | |
Objectives | p. EX 146 |
Introduction | p. EX 146 |
Project Three - Aquatics Wear Six-Month Financial Projection | p. EX 148 |
Rotating Text and Using the Fill Handle to Create a Series | p. EX 151 |
Copying a Cell's Format Using the Format Painter Button | p. EX 154 |
Copying a Range of Cells to a Nonadjacent Destination Area | p. EX 157 |
Inserting and Deleting Cells in a Worksheet | p. EX 159 |
Entering Numbers with Format Symbols | p. EX 162 |
Freezing Worksheet Titles | p. EX 163 |
Displaying a System Date | p. EX 165 |
Absolute versus Relative Addressing | p. EX 168 |
Making Decisions - The IF Function | p. EX 170 |
Formatting the Worksheet | p. EX 177 |
Adding a 3-D Pie Chart to the Workbook | p. EX 187 |
Renaming and Reordering the Sheets and Coloring Their Tabs | p. EX 197 |
Checking Spelling, Saving, Previewing, and Printing the Workbook | p. EX 199 |
Changing the View of the Worksheet | p. EX 201 |
What-If Analysis | p. EX 204 |
Project Summary | p. EX 208 |
What You Should Know | p. EX 209 |
Learn It Online | p. EX 210 |
Apply Your Knowledge | p. EX 211 |
In the Lab | p. EX 212 |
Cases and Places | p. EX 222 |
Web Feature: Creating Static and Dynamic Web Pages Using Excel | |
Objectives | p. EX 225 |
Introduction | p. EX 225 |
Using Web Page Preview and Saving an Excel Workbook as a Static Web Page | p. EX 228 |
Saving an Excel Chart as a Dynamic Web Page | p. EX 234 |
Web Feature Summary | p. EX 238 |
What You Should Know | p. EX 239 |
In the Lab | p. EX 239 |
Microsoft Office Access 2003 | |
Project 1 Creating and Using a Database | |
Objectives | p. AC 4 |
What Is Microsoft Office Access 2003? | p. AC 4 |
What Is New in Access? | p. AC 4 |
Project One - Ashton James College Database | p. AC 5 |
Starting Access | p. AC 7 |
Speech Recognition | p. AC 9 |
Creating a New Database | p. AC 10 |
The Access Window | p. AC 12 |
Creating a Table | p. AC 15 |
Closing and Saving a Table | p. AC 21 |
Adding Records to a Table | p. AC 22 |
Closing a Table and Database and Quitting Access | p. AC 25 |
Opening a Database | p. AC 26 |
Adding Additional Records | p. AC 27 |
Previewing and Printing the Contents of a Table | p. AC 29 |
Creating Additional Tables | p. AC 32 |
Using Queries | p. AC 34 |
Using a Form to View Data | p. AC 38 |
Creating a Report | p. AC 42 |
Closing the Database | p. AC 47 |
Access Help System | p. AC 47 |
Quitting Access | p. AC 50 |
Designing a Database | p. AC 50 |
Project Summary | p. AC 52 |
What You Should Know | p. AC 52 |
Learn It Online | p. AC 53 |
Apply Your Knowledge | p. AC 54 |
In the Lab | p. AC 56 |
Cases and Places | p. AC 63 |
Project 2 Querying a Database Using the Select Query Window | |
Objectives | p. AC 66 |
Introduction | p. AC 66 |
Project Two - Querying the Ashton James College Database | p. AC 66 |
Opening the Database | p. AC 68 |
Creating and Running Queries | p. AC 68 |
Entering Criteria | p. AC 75 |
Sorting Data in a Query | p. AC 85 |
Joining Tables | p. AC 90 |
Calculations | p. AC 96 |
Crosstab Queries | p. AC 104 |
Closing a Database and Quitting Access | p. AC 106 |
Project Summary | p. AC 106 |
What You Should Know | p. AC 107 |
Learn It Online | p. AC 108 |
Apply Your Knowledge | p. AC 109 |
In the Lab | p. AC 110 |
Cases and Places | p. AC 112 |
Project 3 Maintaining a Database Using the Design and Update Features of Access | |
Objectives | p. AC 114 |
Introduction | p. AC 114 |
Project Three - Maintaining the Ashton James College Database | p. AC 115 |
Opening the Database | p. AC 115 |
Updating Records | p. AC 116 |
Filtering Records | p. AC 120 |
Changing the Structure | p. AC 126 |
Changing the Appearance of a Datasheet | p. AC 131 |
Mass Changes | p. AC 135 |
Validation Rules | p. AC 139 |
Referential Integrity | p. AC 150 |
Ordering Records | p. AC 155 |
Creating and Using Indexes | p. AC 157 |
Closing the Database and Quitting Access | p. AC 162 |
Special Database Operations | p. AC 162 |
Project Summary | p. AC 164 |
What You Should Know | p. AC 165 |
Learn It Online | p. AC 166 |
Apply Your Knowledge | p. AC 167 |
In the Lab | p. AC 168 |
Cases and Places | p. AC 171 |
Integration Feature: Sharing Data among Applications | |
Objectives | p. AC 173 |
Introduction | p. AC 173 |
Convert Data from Other Applications to Access | p. AC 176 |
Copy Data from Access to Other Applications | p. AC 181 |
XML | p. AC 185 |
Integration Feature Summary | p. AC 190 |
What You Should Know | p. AC 190 |
In the Lab | p. AC 191 |
Microsoft Office PowerPoint 2003 | |
Project 1 Using a Design Template and Text Slide Layout to Create a Presentation | |
Objectives | PPT 4 |
What Is Microsoft Office PowerPoint 2003? | PPT 4 |
Project One - Strategies for College Success | PPT 7 |
Starting and Customizing PowerPoint | PPT 7 |
The PowerPoint Window | PPT 10 |
Speech Recognition | PPT 16 |
Choosing a Design Template | PPT 17 |
Creating a Title Slide | PPT 20 |
Text Attributes | PPT 23 |
Saving the Presentation on a USB Flash Drive | PPT 27 |
Adding a New Slide to a Presentation | PPT 30 |
Creating a Text Slide with a Single-Level Bulleted List | PPT 31 |
Creating a Text Slide with a Multi-Level Bulleted List | PPT 34 |
Ending a Slide Show with a Black Slide | PPT 42 |
Saving a Presentation with the Same File Name | PPT 43 |
Moving to Another Slide in Normal View | PPT 43 |
Viewing the Presentation in Slide Show View | PPT 46 |
Quitting PowerPoint | PPT 50 |
Starting PowerPoint and Opening a Presentation | PPT 51 |
Checking a Presentation for Spelling and Consistency | PPT 53 |
Correcting Errors | PPT 56 |
Displaying a Presentation in Black and White | PPT 56 |
Printing a Presentation | PPT 59 |
PowerPoint Help System | PPT 62 |
Project Summary | PPT 65 |
What You Should Know | PPT 66 |
Learn It Online | PPT 67 |
Apply Your Knowledge | PPT 68 |
In the Lab | PPT 69 |
Cases and Places | PPT 78 |
Project 2 Using the Outline Tab and Clip Art to Create a Slide Show | |
Objectives | PPT 82 |
Introduction | PPT 82 |
Project Two - Healthy Eating, Healthy Living | PPT 82 |
Starting and Customizing PowerPoint | PPT 84 |
Using the Outline Tab | PPT 85 |
Creating a Presentation on the Outline Tab | PPT 88 |
Adding a Slide on the Outline Tab | PPT 89 |
Creating Text Slides with Multi-Level Bulleted Lists on the Outline Tab | PPT 90 |
Saving a Presentation | PPT 94 |
Reviewing a Presentation in Slide Sorter View | PPT 95 |
Changing Slide Layout | PPT 97 |
Adding Clip Art to a Slide | PPT 99 |
Smart Tags | PPT 106 |
Using the Automatic Layout Options Button to Undo a Layout Change | PPT 107 |
Moving Clip Art | PPT 108 |
Changing the Size of Clip Art | PPT 108 |
Inserting, Moving, and Sizing a Clip into a Slide | PPT 110 |
Adding a Header and Footer to Outline Pages | PPT 112 |
Applying Animation Schemes | PPT 114 |
Animating Clip Art | PPT 116 |
Running an Animated Slide Show | PPT 120 |
Printing a Presentation Created on the Outline Tab | PPT 122 |
E-Mailing a Slide Show from within PowerPoint | PPT 126 |
Project Summary | PPT 128 |
What You Should Know | PPT 129 |
Learn It Online | PPT 130 |
Apply Your Knowledge | PPT 131 |
In the Lab | PPT 132 |
Cases and Places | PPT 138 |
Web Feature: Creating a Presentation on the Web Using PowerPoint | |
Objectives | PPT 141 |
Introduction | PPT 141 |
Using Web Page Preview and Saving a PowerPoint Presentation as a Web Page | PPT 143 |
Editing a Web Page through a Browser | PPT 151 |
Publishing a Web Page | PPT 154 |
Web Feature Summary | PPT 157 |
What You Should Know | PPT 157 |
In the Lab | PPT 158 |
Microsoft Office Outlook 2003 | |
Project 1 E-Mail and Contact Management with Outlook | |
Objectives | p. OUT 4 |
What Is Microsoft Office Outlook 2003? | p. OUT 4 |
Project One - Communicating Over the Internet | p. OUT 6 |
Electronic Mail (E-Mail) | p. OUT 6 |
Contacts | p. OUT 38 |
Quitting Outlook | p. OUT 58 |
Project Summary | p. OUT 59 |
What You Should Know | p. OUT 59 |
Learn It Online | p. OUT 60 |
Apply Your Knowledge | p. OUT 61 |
In the Lab | p. OUT 61 |
Cases and Places | p. OUT 64 |
Microsoft Office 2003 Integration | |
Project 1 Integrating Office 2003 Applications and the World Wide Web | |
Objectives | p. INT 4 |
Introduction | p. INT 4 |
Integration Project - Leland Mortgage Web Site | p. INT 5 |
Adding Hyperlinks to a Word Document | p. INT 8 |
Embedding an Excel Chart into a Word Document | p. INT 14 |
Adding Scrolling Text to a Word Document | p. INT 19 |
Viewing the Word Document in Your Browser and Saving It as a Web Page | p. INT 23 |
Creating a PowerPoint Presentation Web Page | p. INT 26 |
Creating a Data Access Page from an Access Database | p. INT 30 |
Testing the Web Site | p. INT 38 |
Project Summary | p. INT 40 |
What You Should Know | p. INT 40 |
Learn It Online | p. INT 41 |
In the Lab | p. INT 42 |
Cases and Places | p. INT 47 |
Appendix A Microsoft Office Help System | |
Using the Microsoft Office Help System | p. APP 1 |
Navigating the Word Help System | p. APP 2 |
The Office Assistant | p. APP 6 |
Question Mark Button in Dialog Boxes and Help Icon in Task Panes | p. APP 7 |
Other Help Commands on the Help Menu | p. APP 8 |
Use Help | p. APP 10 |
Appendix B Speech and Handwriting Recognition and Speech Playback | |
Introduction | p. APP 11 |
The Language Bar | p. APP 11 |
Buttons on the Language Bar | p. APP 12 |
Customizing the Language Bar | p. APP 12 |
Speech Recognition | p. APP 15 |
Getting Started with Speech Recognition | p. APP 16 |
Using Speech Recognition | p. APP 18 |
Handwriting Recognition | p. APP 19 |
Writing Pad | p. APP 19 |
Write Anywhere | p. APP 21 |
Drawing Pad | p. APP 21 |
On-Screen Keyboard | p. APP 22 |
Speech Playback | p. APP 22 |
Customizing Speech Playback | p. APP 23 |
Appendix C Publishing Office Web Pages to a Web Server | |
Using Web Folders to Publish Office Web Pages | p. APP 24 |
Using FTP to Publish Office Web Pages | p. APP 24 |
Appendix D Changing Screen Resolution and Resetting the Word Toolbars and Menus | |
Changing Screen Resolution | p. APP 25 |
Resetting the Word Toolbars and Menus | p. APP 27 |
Resetting the Standard and Formatting Toolbars | p. APP 27 |
Resetting the Word Menus | p. APP 29 |
Appendix E Microsoft Office Specialist Certification | |
What Is Microsoft Office Specialist Certification? | p. APP 31 |
Why Should You Be Certified? | p. APP 31 |
The Microsoft Office Specialist Certification Exams | p. APP 32 |
How to Prepare for the Microsoft Office Specialist Certification Exams | p. APP 32 |
How to Find an Authorized Testing Center | p. APP 32 |
Shelly Cashman Series Microsoft Office Specialist Center | p. APP 32 |
Microsoft Office Specialist Certification Maps | p. APP 33 |
Microsoft Office Word 2003 | p. APP 33 |
Microsoft Office Excel 2003 | p. APP 36 |
Microsoft Office Access 2003 | p. APP 38 |
Microsoft Office PowerPoint 2003 | p. APP 40 |
Microsoft Office Outlook 2003 | p. APP 41 |
Index | p. IND 1 |
Quick Reference Summary | p. QR 1 |
SAM 2003 Training Companion Task Reference | p. TR 1 |
File Management FastCARD |