Cover image for Office 2003 all-in-one desk reference for dummies
Office 2003 all-in-one desk reference for dummies
Weverka, Peter.
Personal Author:
Publication Information:
New York : Hungry Minds ; Chichester : John Wiley, [2003]

Physical Description:
xxvi, 762 pages : illustrations ; 24 cm.
General Note:
"9 books in 1" -- Cover.

Includes index.
Word 2003 -- Outlook 2003 -- Powerpoint 2003 -- Excel 2003 -- FrontPage 2003 -- Access 2003 -- Publisher 2003 -- Office 2003, One step beyond -- Windows XP.
Format :


Call Number
Material Type
Home Location
Item Holds
HF5548.4.M525 M52476 2003 Adult Non-Fiction Central Closed Stacks

On Order



Are you overwhelmed by the complexities of Microsoft Office? Are you feeling as if you're not getting the most out of your applications? Have you not the slightest idea what FrontPage is for? With Office2003 All-in-One Desk Reference For Dummies , you'll find all the answers you need to take advantage of this popular software suite and utilize its maximum potential. This one-stop reference provides easy-to-understand solutions arranged in an easy-to-understand format, all in the classic down-to-earth Dummies lingo.

This incredibly popular software includes everything you need for work, school, or just organization, including:

Word processing (Word) Spreadsheets (Excel) Slideshow presentations (Power Point) Messaging and contact management (Outlook) Database management (Access) Web building tools (FrontPage) Tools for creating publications (Publisher) Application development (Visual Basic for Applications)

This complete and reliable guide to Office will aid you through all the programs and provide expert advice on:

Formatting, editing, and general tools of Word, including table construction and word styles Using Outlook to handle e-mail, maintain contact folders, and manage time and schedule Beginning and advanced techniques with Power Point, including how to make your show livelier Creating, refining, and organizing spreadsheets with Excel Designing, editing, and maintaining a Web page with FrontPage Building data-base tables, entering, filtering, and sorting data on Access Customizing, automating tasks, and including art and graphics on your Office programs

Written by one of the leading experts on Microsoft programs, this book helps you create documents, slideshows, Web pages, and spreadsheets, as well as organize your databases, e-mails, and contact information. Stop sitting in front of your computer wondering what all of those multi-colored icons do! Office2003 All-in-One Desk Reference For Dummies will show you how to use Office like a pro.

Author Notes

Peter Weverka is the author of computer books. His humorous nontechnology articles have also delighted readers of Harper's

Table of Contents

Introductionp. 1
What's in This Book, Anyway?p. 1
What Makes This Book Specialp. 2
Foolish Assumptionsp. 3
Conventions Used in This Bookp. 3
Icons Used in This Bookp. 4
Good Luck, Reader!p. 4
Book I Wordp. 5
Chapter 1 Entering, Editing, and Formatting Textp. 7
Getting Acquainted with Wordp. 7
Creating a New Documentp. 9
Speedy Ways to Open Documentsp. 10
All about Saving Documentsp. 11
Changing the Font and Size of Textp. 13
Changing lowercase to UPPERCASE and Vice Versap. 14
Spell-Checking a Documentp. 15
Chapter 2 Speed Techniques for Using Wordp. 19
Getting a Better Look at Your Documentsp. 19
Selecting Text in Speedy Waysp. 24
Tricks for Editing Textp. 24
Moving Around Quickly in Documentsp. 26
Inserting a Whole File in a Documentp. 30
Making Fewer Typing Errorsp. 30
Finding and Replacingp. 34
Entering Information Quickly with Formsp. 40
Chapter 3 Laying Out Text and Pagesp. 45
Paragraphs and Formattingp. 45
Inserting a Section Break for Formatting Purposesp. 46
Breaking a Linep. 47
Starting a New Pagep. 48
Setting Up and Changing the Marginsp. 48
Indenting Paragraphs and First Linesp. 51
Numbering the Pagesp. 52
Putting Headers and Footers on Pagesp. 52
Adjusting the Space Between Linesp. 54
Creating Numbered and Bulleted Listsp. 55
Working with Tabsp. 56
Hyphenating a Documentp. 58
Chapter 4 Word Stylesp. 61
All about Stylesp. 61
Applying a Style to Text and Paragraphsp. 62
Creating a New Stylep. 63
Modifying a Stylep. 66
Creating and Managing Templatesp. 67
Chapter 5 Constructing the Perfect Tablep. 73
Talking Table Jargonp. 73
Creating a Tablep. 74
Entering the Text and Numbersp. 75
Aligning Text in Columns and Cellsp. 76
Merging and Splitting Cells and Tablesp. 77
Modifying the Table Layoutp. 77
Repeating Heading Rows on Subsequent Pagesp. 80
Sorting, or Reordering, a Tablep. 81
Sprucing Up Your Tablep. 82
Using Math Formulas in Tablesp. 84
Chapter 6 Desktop Publishing with Wordp. 87
Putting Newspaper-Style Columns in a Documentp. 87
Working with Text Boxesp. 89
Decorating a Page with a Borderp. 92
Dropping In a Drop Capp. 93
Watermarking for the Elegant Effectp. 94
Fixing Spacing Problems in Headingsp. 96
Landscape Documentsp. 96
Printing on Different-Size Paperp. 97
Chapter 7 Getting Word's Help with Office Choresp. 99
Highlighting Parts of a Documentp. 99
Commenting on a Documentp. 100
Showing Revisions to Documentsp. 102
Printing an Address on an Envelopep. 105
Printing a Single Address Label (or a Page of the Same Label)p. 106
Churning Out Letters, Labels, and Envelopes for Mass Mailingsp. 108
Chapter 8 Tools for Reports and Scholarly Papersp. 117
Finding the Right Word with the Thesaurusp. 117
Outlines for Organizing Your Workp. 118
Generating a Table of Contentsp. 120
Putting Footnotes and Endnotes in Documentsp. 124
Indexing a Documentp. 126
Putting Cross-References in a Documentp. 131
Numbering the Headings in a Documentp. 133
Book II Outlookp. 135
Chapter 1 Getting Acquainted with Outlookp. 137
What Is Outlook, Anyway?p. 137
Navigating the Outlook Windowsp. 138
Getting a Better View of a Folderp. 140
Categorizing Items in a Folderp. 140
Finding Items in Foldersp. 142
Deleting E-Mail Messages, Contacts, Tasks, and Other Itemsp. 144
Finding and Backing Up Your Outlook Filep. 146
Importing E-Mail and Addresses from Another Programp. 147
Cleaning Out Your Foldersp. 148
Chapter 2 Maintaining the Contacts Folderp. 151
Maintaining a Happy and Healthy Contacts Folderp. 151
Finding a Contactp. 155
Printing the Contacts Folderp. 156
Chapter 3 Handling Your E-Mailp. 161
Addressing and Sending E-Mail Messagesp. 161
Being Advised When Someone Has Read Your E-Mailp. 174
All about Message Formatsp. 176
Stationery for Decorating E-Mail Messagesp. 177
Receiving E-Mail Messagesp. 178
Handling Files That Were Sent to Youp. 183
Techniques for Organizing E-Mail Messagesp. 184
All about E-Mail Foldersp. 190
Yes, You Can Prevent Junk Mail (Sort of)p. 191
Chapter 4 Managing Your Time and Schedulep. 193
Introducing the Calendarp. 193
The Different Kinds of Activitiesp. 194
Getting around in the Calendar Windowp. 195
Scheduling an Activityp. 196
Canceling, Rescheduling, and Altering Activitiesp. 199
Getting a better look at your schedulep. 200
Customizing Outlookp. 200
Chapter 5 Tasks, Reminders, and Notesp. 193
Tasks: Seeing What Needs to Get Donep. 203
Reminders for Being Alerted to Activities and Tasksp. 205
Making Notes to Yourselfp. 208
Book III PowerPointp. 211
Chapter 1 Getting Started in PowerPointp. 213
Getting Acquainted with PowerPointp. 213
Creating a New Presentationp. 215
Advice for Building Persuasive Presentationsp. 218
Getting a Better View of Your Workp. 221
Inserting Slides and Choosing Layoutsp. 223
Moving and Deleting Slidesp. 227
Hidden Slides for All Contingenciesp. 227
Chapter 2 Entering the Textp. 229
Entering Text on Slidesp. 229
Making Text Fit in Framesp. 231
Making Your Own Text Framesp. 233
Changing the Look of Textp. 234
All about Speaker Notesp. 234
Making a Numbered or Bulleted Listp. 236
Putting Tables on Slidesp. 237
Chapter 3 Advanced Formatting Techniquesp. 239
Changing or Tweaking a Slide Design or Color Schemep. 239
Overriding the Slide Design or Color Schemep. 240
Slide Masters for Consistent Formattingp. 241
Handling Footersp. 246
Transitions and Animationsp. 247
Chapter 4 Making Your Presentation Livelierp. 253
Putting a Picture or Clip-Art Image on a Slidep. 253
Putting Charts in Slidesp. 256
Action Buttons for Going from Slide to Slidep. 260
Sounding Off on Slidesp. 262
Playing a Movie on a Slidep. 263
Chapter 5 Giving the Presentationp. 267
Getting Ready to Give Your Presentationp. 267
Rehearsing Your Presentationp. 269
Printing Handout Copies of a Presentationp. 270
Showing Your Presentationp. 270
Giving a Self-Playing, Kiosk-Style Presentationp. 272
Customizing Shows for Particular Audiencesp. 273
PowerPoint Presentations as Web Sitesp. 275
Book IV Excelp. 277
Chapter 1 Up and Running with Excelp. 279
Getting Acquainted with Excelp. 279
Entering Data in a Worksheetp. 282
Entering Lists and Serial Data with the AutoFill Commandp. 286
Formatting Numbers, Dates, and Time Valuesp. 288
Formatting Text and Numbersp. 289
Establishing Data-Validation Rulesp. 291
Chapter 2 Refining Your Worksheetp. 295
Editing Worksheet Datap. 295
Moving around in a Worksheetp. 296
Getting a Better Look at the Worksheetp. 297
Comments for Documenting Your Worksheetp. 300
Selecting Cells in a Worksheetp. 302
Deleting, Copying, and Moving Datap. 302
Finding the Missing Datap. 303
Finding and Replacing Datap. 304
Handling the Worksheets in a Workbookp. 304
Chapter 3 Formulas and Functions for Crunching Numbersp. 307
How Formulas Workp. 307
The Basics of Entering a Formulap. 311
Speed Techniques for Entering Formulasp. 312
Copying Formulas from Cell to Cellp. 315
Tracing Cell Referencesp. 317
Working with Functionsp. 318
Chapter 4 Making a Worksheet Easier to Read and Understandp. 323
Laying Out a Worksheetp. 323
Decorating a Worksheet with Borders and Colorsp. 327
Styles for Quickly Formatting a Worksheetp. 330
Printing a Worksheetp. 331
Chapter 5 Seeing Data in Chartsp. 337
Building Charts from Your Datap. 337
Editing a Chartp. 342
Putting Pizzazz in Your Chartsp. 344
Chapter 6 Analyzing Datap. 351
Managing Information in Listsp. 351
Forecasting with the Goal Seek Commandp. 354
Performing What-If Analyses with Data Tablesp. 357
Book V FrontPagep. 361
Chapter 1 Introducing FrontPagep. 363
What Is FrontPage, Anyway?p. 363
What You Should Know Before You Beginp. 364
Designing Web Pages and Web sitesp. 368
Creating and Opening a Web Sitep. 371
All about Web Pagesp. 375
Exploring the Different Viewsp. 378
Tracking and Prioritizing Tasksp. 379
Chapter 2 Laying Out a Web Pagep. 381
Techniques for Laying Out Web Pagesp. 381
Making Sure Your Web Site is Compatible with Different Web Browsersp. 389
Applying Themes and Background Colors to Web Pagesp. 393
Including Hyperlinks in Web Pagesp. 397
Making It Easy for Visitors to E-Mail Youp. 400
Chapter 3 Presenting the Contentp. 403
Formatting and Positioning Textp. 403
Working with Imagesp. 406
Creating Thumbnail Imagesp. 411
Inserting a Ruled Linep. 411
Creating a Navigation Barp. 413
Creating an Image Mapp. 415
Chapter 4 Publishing and Maintaining a Web Sitep. 417
Getting Ready to Publish a Web Sitep. 417
Setting Up FrontPage to Work with Your Web Serverp. 421
Publishing a Web Sitep. 422
Promoting Your Web Sitep. 424
The Hit Parade: Keeping Track of Visitorsp. 428
Chapter 5 Forms and Behaviorsp. 431
Creating User-Input Formsp. 431
Behaviors for More Dynamic Web Pagesp. 433
Book VI Accessp. 439
Chapter 1 Introducing Accessp. 441
What Is a Database, Anyway?p. 442
Tables, Queries, Forms, and Other Objectsp. 442
Creating a Database Filep. 447
Finding Your Way around the Database Windowp. 448
Designing a Databasep. 450
Chapter 2 Building Your Database Tablesp. 457
Creating a Database Tablep. 457
Opening and Viewing Tablesp. 461
Entering and Altering Table Fieldsp. 462
Field Properties for Making Sure That Data Entries Are Accuratep. 467
Indexing for Faster Sorts, Searches, and Queriesp. 474
Establishing Relationships between Database Tablesp. 476
Chapter 3 Entering the Datap. 483
The Two Ways to Enter Datap. 483
Entering the Data in Datasheet Viewp. 484
Entering the Data in a Formp. 487
Finding a Missing Recordp. 489
Finding and Replacing Datap. 491
Chapter 4 Sorting, Querying, and Filtering for Datap. 493
Sorting Records in a Database Tablep. 493
Filtering to Find Informationp. 494
Querying: The Basicsp. 500
Six Kinds of Queriesp. 507
Chapter 5 Presenting Data in a Reportp. 513
Creating a Reportp. 513
Opening and Viewing Reportsp. 515
Tweaking a Reportp. 515
Book VII Publisherp. 519
Chapter 1 Introducing Publisherp. 521
"A Print Shop in a Can"p. 521
Introducing Framesp. 522
Creating a Publicationp. 523
Getting Around in Publisherp. 527
Understanding and Using the Layout Guidesp. 528
Chapter 2 Refining a Publicationp. 533
Entering Text on the Pagesp. 533
Making Text Fit Text Framesp. 534
Making Text Wrap Around a Frame or Graphicp. 537
Replacing the Placeholder Graphicsp. 538
Inserting Frames on the Pagesp. 539
Making Frames Overlapp. 541
Inserting, Removing, and Moving Pagesp. 542
Chapter 3 Putting on the Finishing Touchesp. 543
Decorating the Textp. 543
Techniques for Decorating Pagesp. 546
The Master Page for Handling Page Backgroundsp. 549
Taking Advantage of the Design Galleryp. 549
Running the Design Checkerp. 550
Commercially Printing a Publicationp. 551
Book VIII One Step Beyond Officep. 553
Chapter 1 Customizing an Office Programp. 555
What Can I Customize?p. 556
Creating Your Own Toolbars and Toolbar Buttonsp. 557
Customizing the Menu Commandsp. 564
Changing the Keyboard Shortcuts in Wordp. 568
Smart Tags, Smart Alecksp. 569
Chapter 2 Automating Tasks with Macros and VBAp. 571
What Is a Macro?p. 572
What Is VBA?p. 572
Understanding VBA Componentsp. 573
Recording a Macrop. 576
Running a Macrop. 579
Building Sample Macros for This Chapterp. 580
All about the Visual Basic Editorp. 583
Adding Message Boxes to a Macrop. 592
Organizing Macros in the Visual Basic Editorp. 598
Chapter 3 Embellishing Your Files with Art and Graphicsp. 601
Inserting Clip Art and Graphics in Filesp. 601
Creating and Tweaking Shapes and Linesp. 603
Handling Objects in Filesp. 613
Chapter 4 Managing the Microsoft Clip Organizerp. 621
Opening the Microsoft Clip Organizerp. 621
Locating Media Files in the Clip Organizerp. 624
Inserting a Media Filep. 625
Organizing Files in the Clip Organizerp. 626
Chapter 5 Note Taking with OneNotep. 629
Running OneNotep. 629
Introducing OneNotep. 630
Creating Sections and Pages for Storing Notesp. 631
Opening and Closing Sectionsp. 632
Writing Notesp. 632
Finding and Keeping Track of Notesp. 634
Some Housekeeping Choresp. 636
OneNote and Other Office Programsp. 637
Book IX Windows XPp. 639
Chapter 1 Windows Basicsp. 641
A Short Geography Lessonp. 641
Starting, Closing, and Switching between Programsp. 644
Installing Software Programsp. 648
Uninstalling Software Programsp. 649
Installing and Removing Fonts on Your Computerp. 651
Maintaining Your System and Making It Run Betterp. 653
Chapter 2 Working with Files and Foldersp. 659
Devising a Strategy for Storing Your Workp. 659
Introducing My Computer and Windows Explorerp. 661
Creating a New Folderp. 666
Copying and Moving Files and Foldersp. 667
Deleting Folders and Filesp. 672
The Recycle Bin: Resuscitating Files and Folders You Deletedp. 673
Searching for a Missing Filep. 675
Compressing and Uncompressing Filesp. 678
Handling Read-Only Filesp. 681
Chapter 3 Making Windows XP Work Your Wayp. 683
Creating Your Own Shortcut Iconsp. 683
Managing the Taskbarp. 686
Tackling the Quick Launch Toolbarp. 687
Making the Screen Easier to See and Readp. 688
Preventing Eyestrainp. 695
Making the Mouse Work Betterp. 696
Customizing the Keyboardp. 699
Customizing the Menu Systemp. 700
Sharing Your Computer with Othersp. 702
Chapter 4 Let Me Entertain Youp. 707
Fine-Tuning the Volumep. 707
Windows Media Player: Playing Sound and Videop. 708
Recording Sounds, Voices, and Musicp. 719
Indexp. 721