Microsoft Office 2003 : Advanced Concepts and Techniques

by Shelly, Gary B.; Cashman, Thomas J.; Vermaat, Misty E.

• ISBN13: 9780619200251
• ISBN10: 0619200251
• Format: Paperback
• Copyright: 2003-12-12
• Publisher: Cengage Learning

Summary

For the past three decades, the Shelly Cashman Series® has effectively introduced computers to millions of students, consistently providing the highest quality, most up-to-date, and innovative materials in computer education. We are proud of the fact that our series of Microsoft Office 4.3, Microsoft Office 95, Microsoft Office 97, Microsoft Office 2000, and Microsoft Office XP textbooks have been the most widely used books in computer education. With each new edition of our Office books, we have made significant improvements based on software changes and comments made by both instructors and students. Our Microsoft Office 2003 books continue with the innovation, quality, and reliability that you have come to expect from the Shelly Cashman Series.

Table of Contents

Preface	xi
To the Student	xxii
Project Four Creating a Document with a Table, Chart, and Watermark
Objectives	WD 218
Introduction	WD 218
Project Four - Sales Proposal	WD 218
Starting and Customizing Word	WD 220
Displaying Formatting Marks	WD 220
Zooming Page Width	WD 220
Creating a Title Page	WD 221
Formatting and Entering Characters	WD 221
Adding a Border and Shading to a Paragraph	WD 221
Formatting Characters Using the Font Dialog Box	WD 226
Inserting Clip Art from the Web in a Word Document	WD 229
Centering the Title Page Contents Vertically on the Page	WD 232
Saving the Title Page	WD 234
Inserting an Existing Document into an Open Document	WD 235
Inserting a Section Break	WD 235
Inserting a Word Document into an Open Document	WD 238
Saving the Active Document with a New File Name	WD 240
Printing Specific Pages in a Document	WD 240
Deleting a Page Break	WD 244
Cutting Text	WD 245
Creating Headers and Footers	WD 246
Creating a Header Different from a Previous Section Header	WD 246
Creating a Footer Different from a Previous Section Footer	WD 249
Formatting and Charting a Table	WD 250
Adding and Deleting Table Rows and Columns	WD 250
Summing Table Contents	WD 254
Formatting a Table	WD 255
Formatting Nonadjacent Characters	WD 257
Charting a Word Table	WD 258
Changing the Chart in Graph	WD 260
Formatting the Chart Object in Word	WD 264
Working with Formats, Styles, and Bulleted Lists	WD 265
Finding a Format	WD 265
Creating and Applying a Character Style	WD 267
Customizing Bullets in a List	WD 270
Drawing a Table	WD 271
Drawing an Empty Table	WD 272
Single-Space the Table Contents	WD 275
Entering Data into the Table	WD 275
Formatting the Table	WD 276
Creating a Watermark	WD 280
Checking Spelling, Saving Again, and Printing the Sales Proposal	WD 282
Revealing Formatting	WD 282
Project Summary	WD 284
What You Should Know	WD 285
Learn It Online	WD 286
Apply Your Knowledge	WD 287
In the Lab	WD 289
Cases and Places	WD 295
Project Five Generating Form Letters, Mailing Labels, and Directories
Objectives	WD 298
Introduction	WD 298
Project Five - Form Letters, Mailing Labels, and Directories	WD 300
Starting and Customizing Word	WD 300
Displaying Formatting Marks	WD 301
Zooming Page Width	WD 301
Identifying the Main Document for Form Letters	WD 301
Identifying the Main Document	WD 301
Working with AutoShapes and the Drawing Canvas	WD 304
Adding an AutoShape in a Drawing Canvas	WD 304
Formatting an AutoShape	WD 307
Resizing and Formatting the Drawing Canvas	WD 309
Creating a Folder	WD 313
Creating a Data Source	WD 314
Editing Records in the Data Source	WD 321
Composing the Main Document for the Form Letters	WD 321
Modifying a Field	WD 322
Inserting Merge Fields in the Main Document	WD 323
Using an IF Field to Conditionally Print Text in a Form Letter	WD 326
Creating an Outline Numbered List	WD 329
Applying a Paragraph Style	WD 332
Saving the Document Again	WD 334
Displaying Field Codes	WD 335
Printing Field Codes	WD 336
Merging the Documents and Printing the Letters	WD 338
Selecting Data Records to Merge and Print	WD 339
Sorting Data Records to Merge and Print	WD 342
Viewing Merged Data	WD 343
Renaming a Folder	WD 344
Addressing and Printing Mailing Labels	WD 345
Saving the Mailing Labels	WD 350
Addressing and Printing Envelopes	WD 350
Merging All Data Records to a Directory	WD 352
Saving the Directory	WD 362
Closing All Open Word Documents	WD 362
Project Summary	WD 363
What You Should Know	WD 363
Learn It Online	WD 365
Apply Your Knowledge	WD 366
In the Lab	WD 367
Cases and Places	WD 374
Project Six Creating a Professional Newsletter
Objectives	WD 378
Introduction	WD 378
Project Six - Clever Clicks Newsletter	WD 378
Desktop Publishing Terminology	WD 380
Starting and Customizing Word	WD 380
Displaying Formatting Marks	WD 381
Zooming Page Width	WD 381
Changing All Margin Settings	WD 381
Creating the Nameplate	WD 382
Inserting a WordArt Drawing Object	WD 382
Formatting a WordArt Drawing Object	WD 384
Changing the WordArt Shape	WD 386
Adding Ruling Lines	WD 388
Inserting Symbols	WD 389
Inserting and Formatting a Floating Graphic	WD 392
Saving the Newsletter	WD 398
Formatting the First Page of the Body of the Newsletter	WD 398
Formatting a Document into Multiple Columns	WD 398
Justifying a Paragraph	WD 401
Inserting the Remainder of the Feature Article	WD 401
Formatting a Letter as a Drop Cap	WD 403
Inserting a Column Break	WD 404
Inserting Text from a File, Viewing the Document, and Modifying the Inserted Text	WD 406
Adding a Vertical Rule between Columns	WD 409
Creating a Pull-Quote	WD 410
Inserting a Text Box	WD 411
Formatting the Second Page of the Newsletter	WD 415
Changing Column Formatting	WD 415
Using the Paste Special Command to Link Text	WD 418
Balancing Columns	WD 419
Creating a Diagram	WD 421
Using the Format Painter Button	WD 427
Copying, Pasting, and Positioning a Diagram	WD 429
Enhancing the Newsletter with Color and a Page Border	WD 431
Adding a Page Border	WD 433
Enhancing a Document for Online Viewing	WD 436
Highlighting Text	WD 436
Animating Text	WD 437
Changing a Document's Background	WD 438
Splitting the Window and Arranging Open Windows	WD 441
Viewing a Document in Reading Layout	WD 443
Project Summary	WD 445
What You Should Know	WD 445
Learn It Online	WD 447
Apply Your Knowledge	WD 448
In the Lab	WD 450
Cases and Places	WD 455
Collaboration Feature Using Word's Collaboration Tools
Objectives	WD 457
Introduction	WD 457
Creating an Outline	WD 458
Reviewing a Document	WD 461
E-Mailing a Document for Review	WD 461
Inserting, Viewing, and Editing Comments WD 463
Tracking Changes	WD 466
Reviewing Tracked Changes and Comments	WD 468
Changing Review Settings	WD 472
Comparing and Merging Documents	WD 473
Sending an Outline to PowerPoint	WD 475
Collaboration Feature Summary	WD 478
What You Should Know	WD 478
In the Lab	WD 479
Project Four Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks
Objectives	EX 242
Introduction	EX 242
Project Four - e-Money Lenders Loan Payment Calculator	EX 244
Starting and Customizing Excel	EX 245
Bolding the Entire Worksheet	EX 246
Entering the Section Title, Row Titles, System Date, and Saving the Workbook	EX 246
Adding Custom Borders and a Background Color to a Range	EX 248
Formatting Cells Before Entering Values	EX 249
Entering the Loan Data	EX 250
Creating Cell Names Based on Row Titles	EX 251
Determining the Loan Amount Using Names	EX 253
Determining the Monthly Payment Using Names	EX 254
Determining the Total Interest and Total Cost Using Names	EX 255
Entering New Loan Data	EX 256
Using a Data Table to Analyze Worksheet Data	EX 256
Entering the Data Table Titles and Column Titles	EX 257
Creating a Percent Series Using the Fill Handle	EX 258
Entering the Formulas in the Data Table	EX 259
Defining the Data Table	EX 261
Formatting the Data Table	EX 262
Adding a Pointer to the Data Table Using Conditional Formatting	EX 263
Creating an Amortization Schedule	EX 266
Changing Column Widths and Entering the Titles	EX 266
Creating a Series of Integers Using the Fill Handle	EX 267
Entering the Formulas in the Amortization Schedule	EX 268
Entering the Total Formulas in the Amortization Schedule	EX 272
Formatting New Loan Data	EX 273
Entering New Loan Data	EX 275
Adding a Hyperlink to the Worksheet	EX 277
Assigning a Hyperlink to an Embedded Graphic	EX 277
Formatting and Re-Sizing a Graphic	EX 280
Displaying and Printing a Hyperlinked File	EX 280
Printing Sections of the Worksheet	EX 281
Setting Up a Worksheet to Print	EX 282
Printing a Section of a Worksheet Using the Set Print Area Command	EX 283
Naming Print Areas	EX 284
Protecting the Worksheet	EX 286
Hiding and Unhiding Rows, Columns, and Sheets	EX 289
Hiding and Unhiding Workbooks	EX 290
Formula Checking	EX 292
Background Formula Checking	EX 292
Quitting Excel	EX 293
Project Summary	EX 293
What You Should Know	EX 294
Learn It Online	EX 295
Apply Your Knowledge	EX 296
In the Lab	EX 297
Cases and Places	EX 304
Project Five Creating, Sorting, and Querying a List
Objectives	EX 306
Introduction	EX 306
Project Five - Soccer Gear Sales Rep List	EX 308
Starting and Customizing Excel	EX 310
Creating a List	EX 311
Entering the Column Headings for a List	EX 311
Defining a Range as a List	EX 313
Formatting the Insert Row in an Empty List	EX 315
Data Validation	EX 315
Entering Records into a List Using a Data Form	EX 318
Moving from Field to Field in a Data Form	EX 321
Adding Computational Fields to the List	EX 321
Adding New Fields to a List	EX 321
Using Excel's VLOOKUP Function to Determine Letter Grades	EX 323
Guidelines for Creating a List in Excel	EX 327
The List Toolbar	EX 328
The List Button	EX 328
The Toggle Total Row Button	EX 329
The Print List Button	EX 330
Using a Data Form to View Records and Change Data	EX 331
Sorting a List	EX 333
Sorting a List in Ascending Sequence by Name Using the Sort Ascending Button	EX 333
Sorting a List in Descending Sequence by Name Using the Sort Descending Button	EX 334
Sorting a List Using the Sort Command on a Column Heading List	EX 335
Sorting a List on Multiple Fields Using the Sort Command on the List Button Menu	EX 335
Sorting a List on More than Three Fields	EX 338
Displaying Automatic Subtotals in a List	EX 338
Zooming Out on a Subtotaled List and Using the Outline Feature	EX 340
Removing Automatic Subtotals from a List	EX 342
Finding Records Using a Data Form	EX 343
Using Wildcard Characters in Comparison Criteria	EX 345
Using Computed Criteria	EX 346
Querying a List Using AutoFilter	EX 346
Showing All Records in a List	EX 348
Entering Custom Criteria Using AutoFilter	EX 348
Using a Criteria Range on the Worksheet	EX 350
Creating a Criteria Range on the Worksheet	EX 350
Query a List Using the Advanced Filter Command	EX 351
Extracting Records	EX 354
Creating an Extract Range and Extracting Records	EX 354
Enabling AutoFilter	EX 356
More About the Criteria Range	EX 356
A Blank Row in the Criteria Range	EX 356
Using Multiple Comparison Criteria with the Same Field	EX 357
Comparison Criteria in Different Rows and Below Different Fields	EX 357
Using Database Functions	EX 358
Using the SUMIF and COUNTIF Functions	EX 359
Printing the Worksheet and Saving the Workbook	EX 361
Saving a Workbook in Different File Formats	EX 361
Quitting Excel	EX 365
Project Summary	EX 365
What You Should Know	EX 366
Learn It Online	EX 367
Apply Your Knowledge	EX 368
In the Lab	EX 369
Cases and Places	EX 376
Project Six Creating Templates and Working with Multiple Worksheets and Workbooks
Objectives	EX 378
Introduction	EX 378
Project Six - Awesome Images Profit Potential	EX 380
Starting and Customizing Excel	EX 381
Creating the Template	EX 382
Bolding the Font and Adjusting the Row Heights and Column Widths of the Template	EX 383
Entering the Title, Subtitle, and Row Titles in the Template	EX 383
Entering Column Titles and the System Date in the Template	EX 384
Entering Dummy Data in the Template	EX 385
The ROUND Function and Entering Formulas in the Template	EX 386
Saving the Template	EX 390
Formatting the Template	EX 391
Formatting the Template Title and Subtitle	EX 392
Formatting the Column Titles and Total Row	EX 393
Applying Number Formats Using the Format Dialog Box	EX 393
Creating and Assigning a Custom Format Code	EX 395
Creating a New Style	EX 398
Applying a Style	EX 400
Finding a Synonym Using the Research Task Pane	EX 401
Spell Checking, Saving, and Printing the Template	EX 401
Using Templates	EX 401
Creating a Workbook from a Template	EX 404
Adding a Worksheet to a Workbook	EX 406
Copying the Contents of a Worksheet to Other Worksheets in a Workbook	EX 407
Drilling an Entry through Worksheets	EX 408
Modifying the Cleveland Sheet	EX 410
Modifying the Lexington Sheet	EX 412
Modifying the San Diego Sheet	EX 413
Referencing Cells in Other Sheets in a Workbook	EX 414
Entering a Sheet Reference	EX 414
Modifying the Company Sheet	EX 414
Drawing the 3-D Cylinder Chart	EX 419
Formatting the 3-D Cylinder Chart	EX 422
Adding a Chart Title Using the WordArt Tool	EX 423
Adding a Text Box and an Arrow to the Chart	EX 427
Assigning a Comment to a Cell	EX 428
Researching a Topic Using the Research Task Pane	EX 430
Adding a Header, Changing the Margins, and Printing the Workbook	EX 432
Printing All Worksheets in a Workbook	EX 437
Printing Nonadjacent Worksheets in a Workbook	EX 439
Inserting and Removing Page Breaks	EX 439
Hiding Page Breaks	EX 442
The Find and Replace Commands	EX 443
The Find Command	EX 443
The Replace Command	EX 445
Quitting Excel	EX 446
Consolidating Data by Linking Workbooks	EX 446
Searching for and Opening Workbooks	EX 447
Creating a Workspace File	EX 449
Consolidating Data by Linking Workbooks	EX 451
Updating Links	EX 452
Closing All Workbooks at One Time and Quitting Excel	EX 452
Project Summary	EX 452
What You Should Know	EX 453
Learn It Online	EX 454
Apply Your Knowledge	EX 455
In the Lab	EX 456
Cases and Places	EX 463
Integration Feature Object Linking and Embedding (OLE) and Web Discussions
Objectives	EX 465
Introduction	EX 465
Opening a Word Document and an Excel Workbook	EX 467
Linking an Excel Worksheet and Chart to a Word Document	EX 469
Printing and Saving the Word Document with the Linked Worksheet and Chart	EX 471
Editing the Linked Worksheet	EX 472
Saving the Word Document as a Web Page and Using a Discussion Server	EX 473
Replying to a Comment on a Discussion Server	EX 476
Integration Feature Summary	EX 479
What You Should Know	EX 479
In the Lab	EX 480
Project Four Reports, Forms, and Combo Boxes
Objectives	AC 194
Introduction	AC 194
Project Four - Reports, Forms, and Combo Boxes	AC 197
Opening the Database	AC 197
Report Creation	AC 198
Creating a Report	AC 198
Using Design View	AC 202
Report Sections	AC 204
Sorting and Grouping	AC 204
Moving a Control	AC 206
Changing Properties	AC 207
Adding Totals and Subtotals	AC 209
Aligning Controls	AC 211
Formatting Controls	AC 214
Changing Labels	AC 216
Closing and Saving a Report	AC 216
Printing a Report	AC 216
Using Multiple Tables In a Report	AC 217
Creating a Report Involving Multiple Tables	AC 217
Removing Unwanted Controls	AC 222
Changing a Property	AC 223
Enlarging the Page Header Section	AC 224
Changing Column Headings	AC 225
Previewing a Report	AC 226
Closing and Saving a Report	AC 226
Printing a Report	AC 227
Report Design Considerations	AC 227
Creating and Using Custom Forms	AC 227
Beginning the Form Creation	AC 227
Modifying the Form Design	AC 229
Adding a Calculated Field	AC 232
Changing the Format of a Field	AC 233
Combo Boxes	AC 234
Adding a Title	AC 240
Enhancing a Title	AC 242
Saving and Closing a Form	AC 245
Opening a Form	AC 245
Using a Form	AC 246
Closing a Form	AC 246
Form Design Considerations	AC 246
Closing the Database and Quitting Access	AC 246
Project Summary	AC 247
What You Should Know	AC 247
Learn It Online	AC 248
Apply Your Knowledge	AC 249
In the Lab	AC 250
Cases and Places	AC 255
Project Five Enhancing Forms with OLE Fields, Hyperlinks, and Subforms
Objectives	AC 258
Introduction	AC 258
Project Five - Enhancing the Ashton James College Forms	AC 259
Opening the Database	AC 259
Special Fields	AC 260
Adding Fields to a Table	AC 260
Using the Input Mask Wizard	AC 262
Updating the New Fields	AC 264
Entering Data Using an Input Mask	AC 265
Entering Data in Date Fields	AC 266
Entering Data in Memo Fields	AC 266
Changing the Row and Column Size	AC 267
Entering Data in OLE Fields	AC 268
Entering Data in Hyperlink Fields	AC 271
Saving the Table Properties	AC 273
Advanced Form Techniques	AC 273
Creating a Form with a Subform	AC 274
Modifying the Subform Design	AC 278
Modifying the Form Design	AC 280
Moving and Resizing Fields	AC 281
Moving Labels	AC 283
Moving Remaining Fields	AC 284
Changing Label Alignment	AC 285
Resizing the Labels	AC 287
Changing the Size Mode	AC 287
Changing the Special Effects and Colors of Labels	AC 288
Adding a Form Title	AC 290
Fine-Tuning the Form	AC 293
Changing Tab Stops	AC 293
Changing the Tab Order	AC 295
Viewing Data and Web Pages Using the Form	AC 296
Viewing Object Dependencies	AC 299
Using Date and Memo Fields in a Query	AC 299
Closing the Database and Quitting Access	AC 302
Project Summary	AC 302
What You Should Know	AC 302
Learn It Online	AC 303
Apply Your Knowledge	AC 304
In the Lab	AC 306
Cases and Places	AC 311
Project Six Switchboards, PivotTables, and PivotCharts
Objectives	AC 314
Introduction	AC 314
Project Six - Switchboards, PivotTables, and PivotCharts	AC 316
Opening the Database	AC 316
Creating and Using Macros	AC 317
The Macro Window	AC 318
Adding Actions to a Macro	AC 319
Running a Macro	AC 321
Modifying a Macro	AC 322
Errors in Macros	AC 324
Additional Macros	AC 324
Copying a Macro	AC 325
Modifying the Copied Macro	AC 327
Macro Arguments	AC 328
Creating Additional Macros	AC 329
Running the Macros	AC 329
Opening Databases Containing Macros	AC 329
Creating and Using a Switchboard	AC 329
Creating a Switchboard	AC 329
Creating Switchboard Pages	AC 331
Modifying Switchboard Pages	AC 332
Modifying the other Switchboard Pages	AC 334
Opening a Switchboard	AC 337
Closing the Switchboard and Database	AC 338
Additional Tables	AC 339
Creating the New Tables	AC 340
Importing the Data	AC 342
Relating Several Tables	AC 342
PivotTables and PivotCharts	AC 343
Creating a Query	AC 343
PivotTables	AC 346
Changing Properties in a PivotTable	AC 349
Saving the PivotTable Changes	AC 350
Using a PivotTable	AC 350
PivotCharts	AC 354
Changing the Chart Type	AC 356
Changing PivotChart Organization	AC 357
Assigning Axis Titles	AC 358
Removing Drop Areas	AC 359
Adding a Chart Title	AC 360
Saving the PivotChart Changes	AC 362
Using a PivotChart	AC 362
Closing the Database and Quitting Access	AC 364
Project Summary	AC 364
What You Should Know	AC 364
Learn It Online	AC 365
Apply Your Knowledge	AC 366
In the Lab	AC 368
Cases and Places	AC 374
Web Feature Data Access Pages
Objectives	AC 377
Introduction	AC 377
Data Access Pages	AC 377
Opening the Database	AC 379
Creating a Data Access Page	AC 380
Previewing the Data Access Page	AC 383
Using the Data Access Page	AC 384
Grouped Data Access Pages	AC 385
Adding the Fields and Grouping	AC 386
Using the Data Access Page	AC 388
PivotTables in Data Access Pages	AC 389
Creating a PivotTable in a Data Access Page	AC 390
Using the PivotTable	AC 393
Saving a PivotChart to a Data Access Page	AC 394
Using the Data Access Page	AC 395
Closing the Database and Quitting Access	AC 397
Web Feature Summary	AC 397
What You Should Know	AC 397
In the Lab	AC 398
Project Three Using Visuals to Enhance a Slide Show
Objectives	PPT 162
Introduction	PPT 162
Project Three - Hidden Lake Camping and Outdoor Activities	PPT 162
Starting and Customizing a New Presentation	PPT 163
Importing Text Created in Another Application	PPT 165
Opening a Microsoft Word Outline as a Presentation	PPT 165
Deleting a Slide	PPT 167
Changing the Slide 1 Layout to Title Slide	PPT 169
Saving the Presentation	PPT 170
Adding a Picture to Create a Custom Background	PPT 170
Formatting Text-Based Content	PPT 172
Changing the Font and Font Attributes	PPT 173
Inserting and Modifying Clips	PPT 175
Changing the Slide 2 Layout to Title, Content and Text	PPT 176
Inserting a Clip into a Content Placeholder	PPT 177
Sizing and Moving Clips	PPT 177
Ungrouping a Clip	PPT 178
Deselecting Clip Art Objects	PPT 179
Changing the Color of a PowerPoint Object	PPT 180
Changing the Color of Other PowerPoint Objects	PPT 182
Regrouping Objects	PPT 183
Customizing Graphical Bullets Using the Slide Master	PPT 184
Displaying the Slide Master	PPT 185
Changing a Bullet Character on the Slide Master	PPT 186
Changing a Bullet Color on the Slide Master	PPT 188
Creating a Table on a Slide	PPT 190
Inserting a Basic Table	PPT 190
Entering Data in a Table	PPT 192
Formatting a Table Cell	PPT 193
Creating an Organization Chart	PPT 195
Displaying the Next Slide and the Organization Chart Diagram	PPT 196
Adding Text to the Superior Shape	PPT 198
Adding Text to the Subordinate Shapes	PPT 199
Inserting Subordinate and Coworker Shapes	PPT 200
Adding Text to Coworker Shapes	PPT 202
Changing the Shape Layout	PPT 202
Inserting Additional Subordinate and Coworker Shapes	PPT 204
Changing the Preset Design Scheme	PPT 205
Scaling an Organization Chart	PPT 206
Applying a New Design Template	PPT 207
Rearranging Slides	PPT 209
Adding an Animation Scheme to Selected Slides	PPT 210
Printing Slides as Handouts	PPT 211
Creating and Presenting a Custom Show	PPT 212
Running the Slide Show, Saving, and Quitting PowerPoint	PPT 213
Project Summary	PPT 213
What You Should Know	PPT 214
Learn It Online	PPT 215
Apply Your Knowledge	PPT 216
In the Lab	PPT 217
Cases and Places	PPT 22
Project Four Modifying Visual Elements and Presentation Formats
Objectives	PPT 226
Introduction	PPT 226
Project Four - College Finances	PPT 226
Starting a New Presentation Using the AutoContent Wizard	PPT 228
Starting and Customizing a New Presentation	PPT 228
Using the AutoContent Wizard	PPT 229
Creating a Folder and Saving a Presentation	PPT 231
Adding a Picture to Create a Custom Background	PPT 232
Creating a WordArt Element and Adding It to a Slide	PPT 233
Deleting the Title and Subtitle Text Placeholders	PPT 233
Selecting a WordArt Style	PPT 236
Entering the WordArt Text	PPT 237
Changing the WordArt Height and Width	PPT 239
Displaying Grids and Guides and Positioning a WordArt Object	PPT 240
Hiding Guides	PPT 242
Adding a Sound Effect	PPT 243
Deleting Slides	PPT 245
Adding a Chart to a Slide	PPT 246
Displaying the Next Slide and Editing the Title and Bulleted List Text	PPT 247
Changing the Slide Layout and Positioning the Text Placeholder	PPT 248
Inserting a Chart and Replacing the Sample Data	PPT 249
Inserting an Excel Chart	PPT 251
Displaying the Next Slide, Editing the Title Text, and Deleting the Text Placeholder	PPT 252
Inserting an Excel Chart	PPT 253
Scaling and Moving an Excel Chart	PPT 255
Adding a Table from Word	PPT 256
Displaying the Next Slide, Editing the Title Text, and Changing the Slide Layout	PPT 257
Inserting a Word Table	PPT 258
Scaling and Moving a Word Table	PPT 258
Adding Hyperlinks	PPT 259
Displaying the Next Slide and Editing the Text	PPT 260
Adding a Hyperlink to a Slide	PPT 261
Adding the Remaining Hyperlink to the Slide	PPT 262
Revising and Customizing Individual Slides	PPT 263
Hiding Slides	PPT 263
Finding Text	PPT 265
Finding and Replacing Text	PPT 265
Using the Thesaurus	PPT 266
Finding a Second Synonym	PPT 268
Customizing Entire Presentation Elements	PPT 268
Changing the Presentation Template Color Scheme	PPT 268
Modifying the Footer on the Slide Master	PPT 270
Adding an Action Button on the Slide Master	PPT 272
Adding an Action Button and an Action Setting	PPT 272
Scaling an Action Button	PPT 274
Adding a Fill Color to the Action Button	PPT 274
Displaying Guides and Positioning the Action Button	PPT 275
Rotating the Action Button	PPT 277
Closing Master View	PPT 278
Modifying the Presentation Format	PPT 278
Adding a Slide Transition Effect to a Slide Show	PPT 279
Rehearsing Timings	PPT 281
Replacing the Slide Master	PPT 283
Adding Notes and Printing Speaker Notes	PPT 285
Adding Notes	PPT 285
Printing Speaker Notes	PPT 286
Saving the Presentation in Rich Text Format	PPT 289
Running a Slide Show with Hyperlinks and an Action Button	PPT 290
Running a Slide Show with Hyperlinks to the Internet	PPT 290
Running a Slide Show with an Action Button	PPT 290
Delivering and Navigating a Presentation Using the Slide Show Toolbar	PPT 292
Project Summary	PPT 293
What You Should Know	PPT 294
Learn It Online	PPT 295
Apply Your Knowledge	PPT 296
In the Lab	PPT 297
Cases and Places	PPT 305
Collaboration Feature Delivering Presentations to and Collaborating with Workgroups
Objectives	PPT 307
Introduction	PPT 307
Part 1: Workgroup Collaboration Using a Review Cycle	PPT 308
Starting PowerPoint and Opening a File	PPT 309
Displaying the Reviewing Toolbar and Inserting a Comment	PPT 310
Collaborating with Workgroups	PPT 314
Distributing the Slide Show for Review	PPT 314
Merging Slide Shows and Printing Comments	PPT 316
Reviewing, Accepting, and Rejecting Comments	PPT 321
Reviewing, Accepting, and Rejecting Comments on Slides 2, 3, and 4	PPT 325
Part 2: Scheduling and Delivering Online Broadcasts	PPT 330
Part 3: Saving the Presentation Using the Package for CD Option	PPT 333
Copying a Presentation Package to a Folder	PPT 335
Viewing a Packaged Presentation Using the PowerPoint Viewer	PPT 336
Closing the Presentation	PPT 336
Collaboration Feature Summary	PPT 337
What You Should Know	PPT 337
In the Lab	PPT 338
Project Two Schedule Management Using Outlook
Objectives	OUT 66
Introduction	OUT 66
Project Two - Personal Information Manager	OUT 68
Starting and Customizing Outlook	OUT 68
The Calendar - Microsoft Outlook Window	OUT 69
Creating a Personal Folder	OUT 70
Entering Appointments Using the Appointment Area	OUT 72
Entering Appointments Using the Appointment Window	OUT 73
Recurring Appointments	OUT 75
Moving to the Next Day in Calendar and Entering the Remaining Recurring Appointments	OUT 77
Using Natural Language Phrases to Enter Appointment Dates and Times	OUT 79
Entering the Remaining One-Time Appointments	OUT 81
Editing Appointments	OUT 82
Deleting Appointments	OUT 82
Moving Appointments to a New Time	OUT 83
Moving Appointments to a New Date	OUT 85
Moving an Appointment to a New Month	OUT 86
Creating an Event	OUT 88
Displaying the Calendar in Week and Month Views	OUT 89
Work Week View	OUT 89
Week View	OUT 90
Month View	OUT 91
Using Tasks to Create a Task List	OUT 91
Exporting, Deleting, and Importing Subfolders	OUT 93
Exporting Subfolders	OUT 93
Deleting Subfolders	OUT 95
Importing Subfolders	OUT 97
Meeting and Task Management Using Outlook	OUT 98
Assigning Tasks	OUT 98
Accepting a Task Assignment	OUT 100
Customizing the Tasks Window and Moving Tasks to a Personal Folder	OUT 103
Scheduling a Meeting with Outlook	OUT 103
Scheduling Resources	OUT 107
Accepting and Declining Meeting Requests	OUT 107
Proposing New Meeting Times	OUT 109
Creating and Editing Notes with Outlook	OUT 110
Customize Calendar Settings	OUT 112
Setting Work Days and Times	OUT 112
Color Coding the Calendar	OUT 114
Printing a Calendar	OUT 118
Daily Style	OUT 118
Weekly Style	OUT 118
Monthly Style	OUT 119
Printing the Task List	OUT 119
Archiving Items	OUT 120
Customizing AutoArchive	OUT 120
Using Windows Messenger and Instant Messaging with Outlook	OUT 122
Adding a Contact to the Messenger Contact List	OUT 125
Updating an Outlook Contact List	OUT 128
Communicating Using Outlook and Windows Messenger	OUT 129
Closing the Conversation Window	OUT 134
Quitting Outlook	OUT 135
Project Summary	OUT 135
What You Should Know	OUT 135
Learn It Online	OUT 137
Apply Your Knowledge	OUT 138
In the Lab	OUT 139
Cases and Places	OUT 143
Integration Case Studies
Introduction	CS 1
Office 2003 Integration Case Studies	CS 1
1 Integrating Excel, Word, PowerPoint, and Outlook	CS 1
2 Integrating Word, WordArt, and Access	CS 4
3 Integrating Access into Word and Excel	CS 6
Appendix A Microsoft Office Help System
Using the Microsoft Office Help System	APP 1
Navigating the Word Help System	APP 2
The Office Assistant	APP 6
Question Mark Button in Dialog Boxes and Help Icon in Task Panes	APP 7
Other Help Commands on the Help Menu	APP 8
Use Help	APP 10
Appendix B Speech and Handwriting Recognition and Speech Playback
Introduction	APP 11
The Language Bar	APP 11
Buttons on the Language Bar	APP 12
Customizing the Language Bar	APP 12
Speech Recognition	APP 15
Getting Started with Speech Recognition	APP 16
Using Speech Recognition	APP 18
Handwriting Recognition	APP 19
Writing Pad	APP 19
Write Anywhere	APP 21
Drawing Pad	APP 21
On-Screen Keyboard	APP 22
Speech Playback	APP 22
Customizing Speech Playback	APP 23
Appendix C Publishing Office Web Pages to a Web Server
Using Web Folders to Publish Office Web Pages	APP 24
Using FTP to Publish Office Web Pages	APP 24
Appendix D Changing Screen Resolution and Resetting the Word Toolbars and Menus
Changing Screen Resolution	APP 25
Resetting the Word Toolbars and Menus	APP 27
Resetting the Standard and Formatting Toolbars	APP 27
Resetting the Word Menus	APP 29
Appendix E Microsoft Office Specialist Certification
What Is Microsoft Office Specialist Certification?	APP 31
Why Should You Be Certified?	APP 31
The Microsoft Office Specialist Certification Exams	APP 32
How to Prepare for the Microsoft Office Specialist Certification Exams	APP 32
How to Find an Authorized Testing Center	APP 32
Shelly Cashman Series Microsoft Office Specialist Center	APP 32
Microsoft Office Specialist Certification Maps	APP 33
Microsoft Office Word 2003	APP 33
Microsoft Office Excel 2003	APP 36
Microsoft Office Access 2003	APP 38
Microsoft Office PowerPoint 2003	APP 40
Microsoft Office Outlook 2003	APP 41
Index	IND 1
Quick Reference Summary	QR 1