How to Do Everything with Microsoft Office 2003

Cover......Page 1
Contents......Page 8
Acknowledgments......Page 20
Introduction......Page 22
PART I Office 2003 Common Elements......Page 24
CHAPTER 1 What's New in Office 2003......Page 26
The New Office "Look"......Page 27
The New Task Pane......Page 30
Office Watson to the Rescue......Page 31
The Picture Library......Page 32
What's New in Word......Page 33
PowerPoint's Enhancements......Page 35
Outlook's New Features......Page 36
Upgrade Considerations......Page 37
CHAPTER 2 Common Office Features......Page 40
Common Workspace Elements......Page 41
Using Toolbar Buttons......Page 44
Moving Toolbars......Page 45
Common Menu Elements......Page 46
Using the Task Pane......Page 47
Turning Off the Task Pane......Page 49
Working with Smart Tags Across the Office Suite......Page 50
Using the Office 2003 Clipboard......Page 51
Sharing Content with the Copy Command......Page 52
Pasting Clipboard Selections......Page 53
Deleting Clipboard Content......Page 55
Customizing the Clipboard Task Pane......Page 56
Using the Paste Special Command to Insert Clipboard Content......Page 57
Creating a Paste Link......Page 58
Embedding Selections and Editing Tools......Page 60
Turning Speech On......Page 62
Training the Speech Tools for Your Voice......Page 63
Giving Commands Verbally......Page 64
Getting the Office 2003 Help You Need......Page 65
CHAPTER 3 Using Images in Documents, Worksheets, and Presentations......Page 68
Adding Images to Word Documents......Page 69
Using the Picture Toolbar......Page 74
Enhancing Presentations with Clip Art and Photos......Page 76
Capturing Images Digitally......Page 77
Taking a Tour of Office 2003's Picture Library......Page 78
Renaming Images......Page 79
Sharing Images via Email......Page 80
Editing Your Digitally Captured Images......Page 83
PART II Creating Documents with Word......Page 86
CHAPTER 4 Building a Basic Document......Page 88
The Not-So-Blank Document......Page 89
Starting with a Template......Page 91
Typing Your Document Content......Page 93
Working with Paragraph and Line Breaks......Page 94
Navigating a Word Document......Page 96
Keyboard Navigation Techniques......Page 97
Using Your Mouse to Select Text......Page 99
Rearranging Words, Sentences, and Paragraphs......Page 101
CHAPTER 5 Proofing, Printing, and Saving Documents......Page 104
Proofing Word Documents......Page 105
Handling Errors as You Type......Page 106
Running the Spelling and Grammar Check......Page 107
Making Automatic Corrections......Page 108
Creating AutoCorrect Entries......Page 110
Editing and Removing AutoCorrect Entries......Page 111
Customizing the Spell-Checking Process......Page 112
Adjusting the Standards for Grammar Checking......Page 113
Viewing Your Document's Readability Statistics......Page 114
Printing Your Document......Page 115
Performing a First-Time Save......Page 117
Saving a Document with a New Name......Page 119
Building Template Content......Page 120
Template Tips and Techniques......Page 122
CHAPTER 6 Effective Document Formatting......Page 124
Changing the Appearance of Text......Page 125
Choosing the Right Font and Size......Page 126
Applying Text Color......Page 127
Applying Special Text Effects......Page 128
Changing Paragraph Alignment......Page 129
Indenting Text......Page 130
Adjusting Line Spacing......Page 132
Understanding Text-Flow Controls......Page 133
Creating Lists......Page 135
Working with Styles......Page 137
Creating Styles......Page 139
Locking Styles and Formatting to Prevent Changes to Your Templates......Page 141
Setting New Page Margins......Page 142
Adjusting Page Orientation......Page 143
Changing Paper Size......Page 144
Using Word's Default Tabs......Page 145
Setting Tabs from the Ruler......Page 146
Using the Tabs Dialog Box......Page 148
Adjusting Tab Positions......Page 149
Changing Tab Stop Alignment......Page 150
CHAPTER 7 Working with Long Documents......Page 152
Inserting and Formatting Page Numbers......Page 153
Working with Headers and Footers......Page 154
Inserting Header and Footer Content......Page 155
Creating a Table of Contents......Page 157
Using Find to Move Through a Document......Page 158
Replacing Special Codes......Page 159
Working with Columns......Page 160
Building a Newsletter Document......Page 161
Applying Columns to Existing Text......Page 162
Setting Up Columns Before Typing......Page 163
Customizing Columns......Page 164
Setting UpMultiple Column Configurations in One Document......Page 165
CHAPTER 8 Structuring Documents with Tables......Page 166
Building a Uniform Grid......Page 167
Entering Table Content......Page 170
Selecting Table Columns, Rows, and Cells......Page 171
Resizing Columns and Rows......Page 172
Adding and Deleting Columns and Rows......Page 174
Splitting and Merging Cells......Page 175
Applying Borders and Shading......Page 176
Drawing Table Cells......Page 178
Erasing Table Cell Walls......Page 179
Working with the Tables and Borders Toolbar......Page 180
Nesting Tables......Page 183
CHAPTER 9 Creating Form Letters, Envelopes, and Labels with Mail Merge......Page 186
Creating a Form Letter......Page 187
Creating Mailing Labels......Page 190
Choosing the Right Label......Page 191
Merging Data with Your Labels......Page 192
Mail Merge Troubleshooting......Page 195
PART III Crunching Numbers and Keeping Lists with Excel......Page 196
CHAPTER 10 Building and Formatting Worksheets......Page 198
Starting a New Workbook......Page 199
Understanding Worksheets......Page 200
Navigating Worksheets......Page 203
Entering Worksheet Content......Page 204
Editing Cell Content......Page 206
Selecting Cells, Blocks, Columns, and Rows......Page 207
Saving Workbook Files......Page 208
Saving a Workbook as a Template......Page 209
Formatting Worksheet Content......Page 211
Applying Numeric Formats......Page 212
Changing Fonts and Sizes......Page 213
Aligning Worksheet Content......Page 214
Shading Worksheet Cells......Page 216
Applying Borders......Page 217
Copying Cell Formats......Page 218
CHAPTER 11 Working with Formulas and Functions......Page 220
Understanding Spreadsheet Calculations......Page 221
Performing Quick Addition with AutoSum......Page 222
Pasting the AutoSum Function......Page 223
Creating Simple Formulas from Scratch......Page 225
Understanding Relative vs Absolute Addressing......Page 226
Controlling the Order of Operations......Page 227
Using 3-D Formula References......Page 228
Using Excel's Built-in Functions......Page 229
CHAPTER 12 Building and Maintaining List Databases......Page 232
Database Terminology......Page 233
Building a List......Page 235
Sorting by Multiple Fields......Page 236
Creating a Subtotal Report......Page 237
Using AutoFilter to Locate and Display Records in a List......Page 240
Setting Up Advanced Filters......Page 241
Building a PivotTable......Page 242
CHAPTER 13 Charting Excel Data......Page 246
Understanding Chart Types......Page 247
Understanding Chart Elements......Page 249
Setting Up a New Chart......Page 251
Updating and Changing Charts......Page 253
Formatting a Chart......Page 255
Deleting Charts......Page 256
CHAPTER 14 Printing and Publishing Worksheets......Page 258
Printing Workbooks and Worksheets......Page 259
Printing an Entire Workbook......Page 260
Controlling Page Breaks and Page Count......Page 261
Working with Print Options......Page 264
Setting Up Headers and Footers......Page 265
Saving Your Worksheet as a Web Page......Page 266
PART IV Creating Presentations with PowerPoint......Page 270
CHAPTER 15 Planning and Building a Presentation......Page 272
Planning Your Presentation......Page 273
The PowerPoint Environment......Page 274
Deciding on a Presentation Template......Page 275
Inserting New Slides......Page 277
Deleting Slides......Page 278
Working with Bulleted Text......Page 279
Typing Paragraphs......Page 281
Formatting Slide Text......Page 282
Repositioning Text Objects......Page 283
Resizing Text Objects......Page 284
Printing Your Slides......Page 286
Printing Color Options......Page 287
Creating Notes and Audience Handouts......Page 288
CHAPTER 16 Enhancing a Presentation with Graphics and Charts......Page 290
Adding Clip Art and Photographs......Page 291
Drawing and Manipulating Shapes and Lines......Page 292
Drawing Lines and Arrows......Page 293
Applying Fills and Outlines......Page 294
Rotating Shapes and Lines......Page 295
Creating a PowerPoint Chart......Page 296
Customizing the Chart......Page 298
Building an Organization Chart......Page 299
Filling in the Chart Boxes......Page 300
Formatting the Organization Chart......Page 301
Creating a Diagram......Page 302
CHAPTER 17 Building an Effective Multimedia Slide Show......Page 304
Rearranging, Duplicating, and Deleting Slides......Page 305
Applying Slide Transitions......Page 307
Animating Text......Page 309
Animating a Bulleted List......Page 311
Setting Up a Slide Show......Page 312
Inserting Links to Files, Presentations, and Web Content......Page 313
Using Slide Elements as Hyperlinks......Page 314
Working with Action Buttons......Page 315
Publishing a Presentation for Use on the Web......Page 317
PART V Managing Data with Access......Page 320
CHAPTER 18 Getting Started with Access Databases......Page 322
Understanding Database Concepts......Page 323
Designing Tables to Store Your Data......Page 324
What You Need to Know about Tables Before You Begin......Page 326
Viewing a Table and Its Data......Page 327
Creating a Table......Page 328
How to Connect Tables with Relationships......Page 336
Creating Relationships......Page 337
CHAPTER 19 Simplifying Data Entry with Forms......Page 340
How to See the Form Design and Data......Page 342
Using the Form Wizard to Create a Form......Page 343
Managing the Controls on Your Form......Page 344
Making a Pick List with the Combo Box Control......Page 346
Changing the Appearance of Controls by Formatting......Page 348
Data-Entry Tips......Page 350
Navigating Through Records......Page 351
CHAPTER 20 Extracting Data with Queries......Page 354
Understanding Query Types......Page 355
Using the Simple Query Wizard to Make a Select Query......Page 356
Designing a Query in the QBE Grid......Page 357
Ordering Your Records with the Sort Row......Page 359
Writing Criteria to Select Specific Records......Page 361
Selecting Data from Multiple Tables......Page 363
CHAPTER 21 Documenting Your Data with Access Reports......Page 366
Simplifying Report Design with the Report Wizard......Page 367
Creating a Report with the Report Wizard......Page 370
Changing the Margins to Fit More Data per Page......Page 375
Printing Your Reports......Page 376
PART VI Keeping in Touch and on Schedule with Outlook......Page 378
CHAPTER 22 Communicating with Email......Page 380
About Email Accounts......Page 381
Touring the Outlook Interface......Page 383
Working with Messages......Page 384
Attaching Files to Messages......Page 386
Working with Message Flags, Levels, and Receipts......Page 387
Sending Your Message......Page 389
Replying to Messages......Page 392
Formatting Email Messages......Page 393
Choosing Stationery......Page 394
Working with Signatures......Page 396
Creating a Signature......Page 397
Establishing Signatures for Different Email Accounts......Page 398
Setting Up Inbox and Sent Items Folders......Page 399
Moving Messages Between Folders......Page 400
Deleting Messages......Page 401
Filtering Junk Email......Page 402
CHAPTER 23 Scheduling Tasks and Appointments......Page 404
A Tour of the Outlook Calendar......Page 405
Understanding Calendar Entries......Page 407
Creating Appointments, Events, and Meetings......Page 408
Scheduling a Meeting......Page 411
Customizing the Calendar......Page 412
Creating a New Task......Page 413
Assigning Tasks......Page 414
Printing Your Schedule......Page 415
CHAPTER 24 Building a Contacts List......Page 418
Working with Contacts......Page 419
Entering a New Contact......Page 420
Editing Contact Information......Page 422
Contact Tracking......Page 424
Printing Your Contacts List......Page 425
PART VII Designing Web Pages with FrontPage......Page 428
CHAPTER 25 Planning a Website......Page 430
What Are Your Online Goals?......Page 431
Sites that Sell......Page 432
Understanding Graphic Requirements......Page 433
Gathering Your Graphic Images......Page 435
Collecting Text Content......Page 436
Building Your Website Blueprint......Page 437
Creating a Site Map......Page 438
Storyboarding Your Individual Page Content......Page 439
CHAPTER 26 Building a Website......Page 442
Starting a New Website......Page 443
Adding Pages to Your Site......Page 445
Rearranging the Site Structure......Page 446
Applying a Theme to Your Website......Page 447
Adding Page Banners......Page 449
Adding Navigation Buttons to the Home Page......Page 450
Building Web Page Content......Page 452
Making Text Links to External Web Pages and Sites......Page 453
Editing Images......Page 455
Structuring Pages with Tables......Page 457
Inserting a Table......Page 458
Modifying Table Properties......Page 459
CHAPTER 27 Posting Pages to the Web......Page 462
Selecting a Preview Browser......Page 463
Checking Your Site for Errors......Page 464
Publishing Your Website......Page 466
Index......Page 470