Microsoft®
Office 2000

 

Michael Halvorson
and Michael Young

 

Chapters at a Glance

Introduction xxxiii

Part I

Getting Started with Microsoft Office 1

Chapter 1 A Quick Tour of Microsoft Office 3

Chapter 2 Learning the Basics:
Windows, Toolbars, and Printing 27

Chapter 3 Managing Documents:
From Your Hard Disk to the Internet 59

Chapter 4 For Power Users:
Installing and Maintaining Office 2000 97

Part II

Microsoft Word 109

Chapter 5 Getting Started Using Word 111

Chapter 6 Entering and Editing Text in a Word Document 129

Chapter 7 Formatting a Word Document 171

Chapter 8 Customizing Styles and Templates 209

Chapter 9 Arranging Text in Columns and Lists 235

Chapter 10 Using Word’s Proofing Tools 281

Chapter 11 Designing Pages 307

Chapter 12 Working with Word in Workgroups 353

Chapter 13 Writing Long Documents 373

Chapter 14 Using Word to Automate Mailing 397

Part III

Microsoft Excel 417

Chapter 15 Building a Worksheet 419

Chapter 16 Editing a Worksheet 445

Chapter 17 Formatting a Worksheet 461

Chapter 18 Using Workbooks to Organize Information 495

Chapter 19 Customizing Excel to Work the Way You Do 521

Chapter 20 Using Formulas and
Functions to Crunch Numbers 541

Chapter 21 Creating Worksheet Charts 563

Chapter 22 Working with Lists, Databases, and Pivot Tables 585

Chapter 23 Analyzing Business Data 615

Chapter 24 Using Excel to Publish to the Web 635

Part IV

Microsoft PowerPoint 647

Chapter 25 Getting Started Using PowerPoint 649

Chapter 26 Entering and Editing Text 667

Chapter 27 Formatting Text 693

Chapter 28 Inserting Tables, Graphics, and Drawings 713

Chapter 29 Adding Special Effects and Internet Links 731

Chapter 30 Perfecting Your Presentation 751

Chapter 31 Setting Up and Publishing the Slide Show 765

Chapter 32 Running the Slide Show 781

Part V

Microsoft Access 791

Chapter 33 Understanding Data Basics 793

Chapter 34 Creating Tables and Relationships 813

Chapter 35 Using Datasheets to Enter and View Data 843

Chapter 36 Using Forms to Enter and View Data 863

Chapter 37 Using Queries to Get Answers 889

Chapter 38 Using Wizards to Generate Reports 917

Chapter 39 Formatting Forms and Reports 943

Part VI

Microsoft Outlook 957

Chapter 40 Getting Started Using Outlook 959

Chapter 41 Learning Basic Outlook Techniques 977

Chapter 42 Using Outlook to Manage
Messages and Appointments 1001

Chapter 43 Using Outlook to Manage Contacts,
Tasks, and Other Types of Information 1033

Part VII

Microsoft Publisher 1057

Chapter 44 Getting Started with Publisher 1059

Chapter 45 Creating Brochures and Newsletters 1085

Chapter 46 Adding Graphics and Special Effects 1103

Chapter 47 Designing a Web Publication 1119

Part VIII

Microsoft FrontPage 1135

Chapter 48 Getting Started Using FrontPage 1137

Chapter 49 Managing Your Web Site 1147

Chapter 50 Creating and Modifying Web Pages 1169

Chapter 51 Formatting Your Web Pages 1199

Chapter 52 Adding Advanced Features to Your Web Pages 1227

Part IX

Small Business Tools 1241

Chapter 53 Analyzing Business Performance Using
Microsoft Small Business Financial Manager 1243

Chapter 54 Managing Customers,
Direct Mail, and Business Plans 1259

Part X

Integrating Microsoft Office Applications 1283

Chapter 55 Sharing Data Among Office Applications 1285

Chapter 56 Using the Office Binder Program 1313

Chapter 57 Using Microsoft PhotoDraw 2000 1333

Part XI

Using Visual Basic to Supercharge Office 1363

Chapter 58 Building Your First Office Macro 1365

Chapter 59 Using Variables, Operators, and
Functions to Manage Information 1385

Chapter 60 Using Office Control Structures 1409

Chapter 61 Using Toolbox Controls
to Create a User Interface 1427

Chapter 62 Working with Office Application Objects 1445

Index 1461

 

Table of Contents

Acknowledgments xxxi

Introduction xxxiii

How This Book Is Organized xxxiv

Who This Book Is For xxxvii

Conventions Used in This Book xxxvii

Visiting Our Web Site xxxviii

Using the Book’s Sample Files xxxviii

Office 2000 and the Y2K Problem xxxix

The Nature of the Y2K Problem xl

Planning for the Year 2000 xli

Resources for the Y2K Problem xlii

Microsoft Office 2000 Support xliii

Contacting the Authors xliii

Part I

Getting Started with Microsoft Office 1

Chapter 1 A Quick Tour of Microsoft Office 3

Introducing Microsoft Office 4

What’s New in the Software? 5

Microsoft Office 2000 5

Microsoft Word 7

Microsoft Excel 8

Microsoft PowerPoint 8

Microsoft Access 9

Microsoft Outlook 9

Choosing an Office Application 10

Running Office Applications 11

Clicking the Start Button 11

Clicking a Program Icon on the Office
Shortcut Bar 12

Creating Files Using a Document Template 13

Opening Documents Using Microsoft
Outlook 16

Switching Between Office Applications 17

Using the Help System 19

The Microsoft Help Command 20

The Office Assistant Feature 22

The What’s This? Feature 24

Fixing Problems Using Detect And Repair 24

Exiting Office Applications 25

Chapter 2 Learning the Basics:
Windows, Toolbars, and Printing 27

Working with Application Windows 28

Understanding the Workplace 29

Navigating Document Windows 31

Using Menus and Dialog Boxes 35

Menu Conventions 35

Dialog Box Options 36

Using Toolbars 39

What If I See Something Different? 40

Moving Toolbars 41

Adding and Removing Toolbars 43

Customizing Toolbars 44

Customizing Menus 50

Printing Documents 52

Using Print Preview 52

Using the Print Command 52

Troubleshooting Your Printer 57

Chapter 3 Managing Documents:
From Your Hard Disk to the Internet 59

Opening an Existing Document 60

Browsing Through Folders 62

Previewing Files Using the Open
Dialog Box 63

Performing an Automated Search for a File 64

Using the Find Command 66

Deleting Files, Renaming Files, and
Creating New Folders 68

Saving Documents and Web Pages 69

Using the Save Command 70

Using the Save As Command 70

Saving Documents as Web Pages 75

Creating a New Document 77

Closing a Document 78

Working with Property Sheets 79

Sharing Documents in a Workgroup 82

Saving and Retrieving Files on a Network 82

Routing Files Using Microsoft Exchange 83

Sending Files by Electronic Mail 84

Using Online Collaboration 86

Browsing Documents on the Web 89

Linking Up with the World Wide Web 90

Using the Web Toolbar 91

Using Internet Explorer 5 93

Chapter 4 For Power Users:
Installing and Maintaining Office 2000 97

Installing Microsoft Office 2000 98

Making Room for the Tools You Need 98

Running Setup 99

Reinstalling or Repairing Office 103

Removing Office 104

Additional Setup Resources:
The Office 2000 Resource Kit 106

Part II

Microsoft Word 109

Chapter 5 Getting Started Using Word 111

Touring the Word Workplace 112

Creating and Printing a Document from
Start to Finish 117

Changing the Way Documents Are Displayed 126

Chapter 6 Entering and Editing Text in a Word Document 129

Entering Text 130

Inserting Special Characters 131

Automatic Writing 132

Moving the Insertion Point 142

Editing Text 144

Selecting Text 145

Editing the Selection 150

Finding and Replacing Text 155

Navigating Through a Document Using
Other Methods 160

Marking and Retrieving Text Using
Bookmarks 161

Using the Go To Command 162

Using the Browse Buttons 166

Inserting and Navigating Using Hyperlinks 167

Chapter 7 Formatting a Word Document 171

Formatting Documents Automatically 172

Using the AutoFormat As You Type
Feature 177

Applying a Theme 180

Using the Style Gallery 181

Using Click and Type 183

Applying Styles 184

Applying Paragraph Styles 185

Applying Character Styles 189

Applying Character Formatting Directly 190

Using the Font Dialog Box 193

Using Shortcut Keys to Apply Character
Formatting 196

Using the Formatting Toolbar to Apply
Character Formatting 198

Applying Paragraph Formatting Directly 199

Using the Paragraph Dialog Box 201

Using Shortcut Keys to Apply Paragraph
Formatting 203

Using the Formatting Toolbar and Ruler
to Apply Paragraph Formatting 205

Copying Formatting 206

Chapter 8 Customizing Styles and Templates 209

Modifying Styles 210

Modifying Styles by Example 212

Modifying Styles Using the Style Dialog Box 213

Creating New Styles 221

Creating Paragraph Styles by Example 221

Creating Styles Using the Style Dialog Box 222

Copying Styles 224

Copying Styles from a Template to a
Document 224

Copying Styles from a Document to a
Template 225

Modifying and Creating Document Templates 226

Modifying Templates 229

Creating New Templates 231

Changing the Template Attached to a
Document and Loading Global Templates 232

Chapter 9 Arranging Text in Columns and Lists 235

Using Tabs 236

Defining Custom Tab Stops Using the Ruler 238

Defining Custom Tab Stops Using the
Tabs Dialog Box 240

Using Tables 241

Inserting a Table 241

Entering Text into a Table 242

Inserting and Deleting Rows, Columns,
and Cells 243

Adjusting the Size of Table Cells 246

Moving and Copying Rows, Columns,
and Cells 249

Using the Table Menu Commands 251

Drawing Tables 253

Creating Newspaper-Style Columns 255

Setting Up Columns Using the Columns
Button 256

Setting up Columns Using the Columns
Dialog Box 257

Adjusting Columns 259

Creating Bulleted and Numbered Lists 260

Adding Bullets and Numbering Using the
Formatting Toolbar 261

Adding Bullets and Numbering Using the
Bullets And Numbering Dialog Box 262

Sorting Lists and Tables 265

Using Borders and Shading 268

Adding Borders and Shading Using the
Tables And Borders Toolbar 269

Adding Borders and Shading Using the
Borders And Shading Dialog Box 272

Adding Page Borders 276

Inserting Horizontal Dividing Lines 277

Chapter 10 Using Word’s Proofing Tools 281

Marking the Language 282

Using Automatic Language Detection 283

Checking Your Spelling 285

Checking Your Spelling Automatically
as You Type 285

Running the Spelling Checker Manually 287

Customizing the Spelling Checker 290

Using Custom Dictionaries 291

Checking Your Grammar 294

Checking Your Grammar Automatically
as You Type 295

Running the Grammar Checker Manually 296

Customizing the Grammar Checker 299

Using the Thesaurus to Find Synonyms 300

Hyphenating Your Documents 303

Hyphenating Your Document Automatically 303

Hyphenating Your Document Using
Confirmation 304

Inserting Hyphen Characters Manually 306

Chapter 11 Designing Pages 307

Adding Page Numbering 308

Adding Headers and Footers 311

Sizing and Moving Headers or Footers 314

Varying Headers or Footers Within the
Document 316

Adjusting the Page Setup 318

Adjusting the Margins 320

Adjusting the Paper Size and Orientation 324

Adjusting the Paper Source 325

Adjusting the Page Layout 326

Using Text Boxes to Position Text on the Page 328

Adding Graphics 332

Importing Pictures 332

Creating Drawings in Word 335

Formatting Text Boxes, Pictures, and Drawing
Objects 343

Using the Format Dialog Box 343

Using the Picture Toolbar 345

Adding Movie Clips, Scrolling Text, and
Backgrounds 347

Previewing and Printing Documents 349

Chapter 12 Working with Word in Workgroups 353

Adding Comments to Your Documents 354

Tracking Document Changes 358

Reviewing Changes 361

Customizing Revision Marking 362

Working with Different Document Versions 363

Using Other Workgroup Techniques 365

Protecting Documents 365

Merging Tracked Changes 369

Highlighting Text 370

Sharing Fonts 371

Online Collaboration 372

Chapter 13 Writing Long Documents 373

Using Outline View 374

Switching to Outline View 374

Changing Heading Levels 376

Moving Blocks of Text 379

Collapsing and Expanding Text 380

Browsing Through Outline Headings 383

Printing an Outline 385

Adding Footnotes and Endnotes 386

Creating Indexes and Tables of Contents 390

Creating an Index 390

Creating a Table of Contents 394

Chapter 14 Using Word to Automate Mailing 397

Printing Individual Envelopes and Labels 398

Printing Individual Envelopes 398

Printing Individual Labels 401

Using Mail Merge for Large Mailings 404

Printing Form Letters 404

Printing Sets of Envelopes 411

Printing Sets of Mailing Labels 414

Part III

Microsoft Excel 417

Chapter 15 Building a Worksheet 419

Starting Excel and Getting Comfortable 420

Navigating a Worksheet 422

Entering Information 425

Entering Numeric Values 425

Entering Text Values 427

Entering Dates and Times 428

Entering Comments 430

Entering Formulas 431

Adding Artwork 434

Inserting Hyperlinks 437

Creating a Hyperlink in Your Worksheet 437

Activating a Hyperlink 439

Editing and Removing Hyperlinks 441

Saving the Workbook 441

Exiting Excel (A Few Points to Remember) 442

Chapter 16 Editing a Worksheet 445

Essential Editing Techniques 446

Selecting Cells and Ranges 446

Clearing Cells and Deleting Cells 448

Undoing Commands 449

Using Cut and Paste to Move Data 452

Using the New Office Clipboard Toolbar 453

Using Copy and Paste to Duplicate Data 454

Moving Cells by Dragging 455

Adding Rows and Columns to the
Worksheet 456

Entering a Series of Labels, Numbers, and Dates 457

Using AutoFill to Create a Series 458

Using the Fill Commands 459

Chapter 17 Formatting a Worksheet 461

Formatting Cells 462

Changing Alignment 462

Changing Number Formats 466

Changing Text Font and Text Color 470

Adding Borders to Cells 472

Adding Shading to Cells 474

Copying Formatting Using the Format
Painter Button 475

Changing Column Widths and Row Heights 476

Adjusting the Height or Width Manually 477

Using the AutoFit Command 479

Applying a Combination of Effects Using AutoFormat 480

Creating Conditional Formatting 481

Using Styles 484

Creating Your Own Styles 484

Applying Existing Styles 486

Merging Styles from Other Workbooks 487

Creating Templates 488

Opening and Modifying an Existing
Template File 489

Creating a New Template File 491

Changing Page Breaks 491

Using Page Break Preview 492

Chapter 18 Using Workbooks to Organize Information 495

Managing Worksheets 496

Switching Between Worksheets 496

Naming Worksheets 497

Deleting Worksheets 497

Inserting Worksheets 499

Moving Worksheets 500

Linking Information Between Worksheets 501

Using More Than One Workbook 503

Switching Between Workbooks 504

Linking Information Between Workbooks 505

Managing Shared Workbooks 508

Creating a Shared Workbook 509

Monitoring a Shared Workbook 510

Accepting or Rejecting Revisions 511

Merging Workbooks 514

Protecting Worksheets and Workbooks 515

Protecting Worksheets 515

Protecting Workbook Structure 517

Requiring a Password for File Access 518

Chapter 19 Customizing Excel to Work the Way You Do 521

Adjusting Views 522

Using the Zoom Command 522

Saving Views Using the Custom Views
Command 524

Setting Printing Options 525

Controlling Page Orientation 526

Adjusting the Margins 527

Adding Headers and Footers 527

Adding Gridlines and Other Options 531

Setting AutoCorrect Options 533

Customizing Excel Usingthe Options Dialog Box 535

Controlling Calculation 535

Customizing Worksheet Appearance 537

Customizing Editing Options 538

Installing Add-in Commands and Wizards 539

Chapter 20 Using Formulas and
Functions to Crunch Numbers 541

Building a Formula 542

Multiplying Numbers 542

Replicating a Formula 544

Using Arithmetic Operators 546

Parentheses and Order of Evaluation 546

Using Built-in Functions 548

The Versatile SUM Function 549

The Insert Function Command 550

Using Functions to Analyze Finances 552

Using PMT to Determine Loan Payments 553

Using FV to Compute Future Value 554

Using RATE to Evaluate Rate of Return 555

Using Function Error Values 557

Using Range Names in Functions 558

Creating Range Names 558

Putting Range Names to Work 559

Modifying Ranges 560

Deleting Range Names 561

Chapter 21 Creating Worksheet Charts 563

Planning a Chart 564

Creating a Chart 566

Creating an Embedded Chart 569

Formatting a Chart 573

Exploring the Chart Menu 573

Using the Charting Toolbar 574

Changing the Chart Type 574

Changing Titles and Labels 575

Adjusting Gridlines 578

Modifying the Chart Legend 579

Adding Labels and Arrows 581

Printing a Chart 583

Chapter 22 Working with Lists, Databases, and Pivot Tables 585

Using a List of Cells as a Database 586

Using a Form for Data Entry 587

Validating Data as You Enter It 588

Sorting Rows and Columns 591

Sorting on More Than One Column 592

Creating Your Own Custom Sort Order 594

Using a Custom Sort Order 594

Using AutoFilter to Find Records 596

Creating a Custom AutoFilter 597

Using the Subtotals Command to Organize a List 598

Working in Outline View 601

Converting an Excel List into an Access Database 602

Creating Pivot Tables and Pivot Charts 603

Using the PivotTable And PivotChart Wizard 603

Evaluating a Pivot Table 607

Rearranging Fields in a Pivot Table 608

Changing the Function in a Pivot Table 609

Adjusting the Formatting in a Pivot Table 610

Displaying Pivot Charts 611

Using External Data Sources in Pivot Tables 613

Chapter 23 Analyzing Business Data 615

Using the Goal Seek Command to Forecast 616

Using the Solver to Set Quantity and Pricing 619

Setting Up the Problem 620

Running the Solver 621

Editing Your Solver Forecast 625

Using the Scenario Manager to Evaluate What-If Questions 627

Creating a Scenario 627

Viewing a Scenario 630

Creating Scenario Reports 632

Chapter 24 Using Excel to Publish to the Web 635

Designing a Web Page 636

Static Pages vs. Interactive Pages 637

Setting Web Publication Options 637

Running Excel Web Pages on the Internet 641

Using Office Web Toolbars 643

Part IV

Microsoft PowerPoint 647

Chapter 25 Getting Started Using PowerPoint 649

Exploring the PowerPoint Window 651

Understanding PowerPoint Views 653

Getting Started 655

Using the AutoContent Wizard 656

Using a Template 658

Creating a Blank Presentation 661

Working with Toolbars 662

Using the Options Dialog Box to Customize
PowerPoint 665

Chapter 26 Entering and Editing Text 667

Entering Text 668

Entering Text into Placeholders 670

Using Outlines 674

Entering Review Comments 682

Expanding and Duplicating Slides 684

Adding Pizzazz by Using WordArt Objects 685

Revising Text 687

Selecting Text to Revise 687

Making Changes 687

Chapter 27 Formatting Text 693

Changing the Appearance of Slide Text 694

Changing the Font, Font Size, Style,
and Color 694

Embossing Text Using the Font Dialog Box 697

Changing Text Alignment 698

Changing Line Spacing 700

Working with Bullets and Numbering 701

Changing Paragraph Indentations 703

Changing the Template 704

Changing the Background Color and
Shading 706

Creating a New Background 707

Editing the Slide Master and the Title Master 709

Formatting the Slide Master 709

Formatting the Title Master 710

Chapter 28 Inserting Tables, Graphics, and Drawings 713

Inserting a Table 714

Formatting a Table 716

Inserting a Chart 717

Adding Clip Art 720

Drawing a Graphic Object 722

Working with Drawing Objects 722

Working with Layers 724

Formatting Text and Graphics: Advanced
Techniques 725

Using the Colors and Lines Tab 725

Using the Size Tab 726

Using the Position Tab 726

Using the Picture Tab 727

Using the Text Box Tab 728

Using the Web Tab 729

Chapter 29 Adding Special Effects and Internet Links 731

Adding Animation 732

Adding Animation in Slide Sorter View 734

Selecting Transitions 734

Controlling Bulleted List Animation 736

Customizing Your Animation 736

Inserting Video 738

Inserting Sounds 740

Recording Narration 741

Creating Action Buttons 743

Moving to a Slide or File 743

Running Another Program 746

Connecting to the Internet 747

Creating an Internet Hyperlink 747

Using the Web Toolbar 749

Chapter 30 Perfecting Your Presentation 751

Adding Notes 752

Checking Your Spelling 753

Viewing Slides in Grayscale 757

Using Slide Sorter View 759

Adding and Deleting Slides 760

Rearranging Slides 762

Hiding Slides 762

Chapter 31 Setting Up and Publishing the Slide Show 765

Picking a Show Type 766

Rehearsing the Show 767

Setting the Timings 768

Setting Timings Manually 771

Printing Slides, Notes Pages, and Handouts 772

Using Transparencies 774

Ordering 35mm Slides 775

Using Pack And Go 776

Publishing the Show to the Web 776

Chapter 32 Running the Slide Show 781

Preparing Electronic Presentations 782

Using Slide Show View 783

Using Slide Navigator 785

Revealing Hidden Slides 786

Closing the Show 786

Using Action Buttons for Branching 786

Using Meeting Minder 787

Using the Pen to Mark Slides 788

Broadcasting Your Presentation 789

Part V

Microsoft Access 791

Chapter 33 Understanding Data Basics 793

The Database Foundation 794

Fields and Records 794

The Relational in a Relational Database
Management System 795

The Database Window 798

Moving to the Database Window 798

An Alternative—The Switchboard 799

Database Objects 800

Tables 802

Forms and Data Access Pages 802

Reports 803

Queries 804

Programming Tools 805

Saving Data and Objects 806

Creating and Opening Databases 806

Creating a Blank Database 807

Creating a Database Using a Wizard 807

Opening an Existing Database 810

Chapter 34 Creating Tables and Relationships 813

Designing Your Database Foundation 814

Creating a Table Using the Table Wizard 817

Working with the Design of a Table 821

Adding, Removing, and Rearranging
Fields 823

Setting the Field Properties 825

Designating a Primary Key 831

Saving the Table Design 832

Importing Data 832

Relating Your Tables 834

Chapter 35 Using Datasheets to Enter and View Data 843

Viewing a Datasheet 844

Making Changes in Datasheet View 844

Using Subdatasheets 847

Entering and Editing Data in a Datasheet 849

Using Formatted Fields 850

Deleting a Record 850

Sorting Your Information 852

Finding Information 852

Controlling Where Access Searches 853

Controlling What Access Matches 854

Replacing Data 855

Filtering Records 857

Using Filter By Selection 857

Using Filter By Form 859

Using Advanced Filter and Sort 862

Chapter 36 Using Forms to Enter and View Data 863

Using a Form 864

Printing a Form 868

Working with Records 869

Creating a Form 871

Design View Option 872

AutoForm Options 873

Form Wizard Option 873

Modifying a Form 877

Adding a Bound Control 881

Adding a Control Using the Toolbox 882

Changing a Control 883

Putting Forms on the Web Using Data
Access Pages 885

Creating a Data Access Page 887

Modifying a Data Access Page 888

Chapter 37 Using Queries to Get Answers 889

Using the Simplest Grid—Advanced Filter/Sort 890

Defining the Conditions 891

Viewing the Results 892

Combining Conditions 893

Sorting 895

Creating a Simple Query 897

Doing Without the Simple Query Wizard 901

Exploring Features of the Query
Design Grid 903

Viewing the Results of a Query 904

Using Top-Value Queries 905

Summarizing Your Records 906

Calculating New Values 909

Using the Crosstab Query 911

Understanding Queries that Change Data 913

Delete Query 914

Make-Table Query 914

Append Query 915

Update Query 915

Chapter 38 Using Wizards to Generate Reports 917

Creating a Standard Report 918

Grouping Records 922

Sorting Fields 924

Setting Summary Options 925

Selecting a Layout 926

Selecting a Style 927

Wrapping It Up 929

Modifying the Report Design 930

Understanding Report Sections 932

Working with Summary Controls 934

Controlling the Groupings 936

Making Labels 938

Chapter 39 Formatting Forms and Reports 943

Moving Controls 944

Aligning Controls 946

Using the Grid 947

Spacing Controls 948

Changing a Control’s Size 949

Changing a Control’s Color and Effects 950

Changing the Look of the Text 952

Using Control Properties 953

Part VI

Microsoft Outlook 957

Chapter 40 Getting Started Using Outlook 959

What You Can Do with Outlook 960

New Features 960

Setting Up Outlook 962

Information Services and User Profiles 964

Taking an Outlook Tour 969

Accessing Outlook Folders 971

Accessing File Folders 971

Using the Outlook Today Folder 972

Other Ways to Open Folders 973

Where to Go from Here 976

Chapter 41 Learning Basic Outlook Techniques 977

Working with Outlook Items 978

Using Different Views 978

Sorting, Filtering, and Grouping Items
in Outlook Folders 982

Opening, Editing, Creating, and Removing
Outlook Items 984

Using the Organize Tool 988

Working with Outlook Folders 989

Modifying the Outlook Bar 994

Finding Outlook Items or Disk Files 995

Using Advanced Find 996

Printing Information Stored in Outlook Folders 999

Chapter 42 Using Outlook to Manage
Messages and Appointments 1001

Inbox and Other Mail Folders 1002

Reading Messages 1002

Sending Messages 1010

Organizing Messages 1017

Calendar 1020

Scheduling Appointments 1022

Scheduling Events 1027

Scheduling Meetings 1028

Chapter 43 Using Outlook to Manage Contacts,
Tasks, and Other Types of Information 1033

Contacts 1034

Creating Distribution Lists in Your
Contacts Folder 1038

Using Your Contacts Folder to Generate
Form Letters 1040

Tasks 1041

Exchange Server Only: Assigning and
Tracking Tasks 1045

Journal 1047

Notes 1051

Accessing and Managing Files and Opening
Web Sites 1053

Part VII

Microsoft Publisher 1057

Chapter 44 Getting Started with Publisher 1059

Exploring the Publisher Window 1061

Using Wizards and Templates 1064

Using Publications By Wizard 1064

Creating Publications By Design 1066

Starting with Blank Presentations 1068

Creating Templates 1069

Working with Toolbars 1070

Working with Text Frames 1072

Working in Microsoft Word 1073

Formatting a Text Frame 1075

Making Text Flow Between Text Frames 1075

Using AutoFlow 1077

Using Layout Tools 1077

Printing Your Publication 1080

Chapter 45 Creating Brochures and Newsletters 1085

Designing a Flyer 1086

Editing Headers and Headlines 1087

Creating a Three-Fold Brochure 1091

Creating a Newsletter 1096

Creating a Mass Mailing 1101

Chapter 46 Adding Graphics and Special Effects 1103

Inserting Pictures and Clip Art 1104

Inserting Pictures 1104

Resizing Pictures 1106

Working with Picture Frames 1107

Inserting Clip Art 1110

Creating Color and Fill Effects 1111

Working with Fill Colors 1112

Applying Patterns and Gradients 1113

Using WordArt 1114

Using the Design Gallery 1116

Chapter 47 Designing a Web Publication 1119

Planning for the Web 1120

Creating a Web Site 1122

Using the Publisher Web Site Wizard 1123

Creating a Web Site from an Existing
Publication 1127

Converting a Publication into a Web Site 1128

Starting a Web Site from Scratch 1128

Inserting Hyperlinks 1129

Publishing to the Web 1132

Part VIII

Microsoft FrontPage 1135

Chapter 48 Getting Started Using FrontPage 1137

Running FrontPage and Creating a New Web 1139

Touring FrontPage 1143

Chapter 49 Managing Your Web Site 1147

Working with Folders and Files 1148

Working with Folders 1149

Working with Files 1150

Linking Your Pages 1153

Using Navigation View 1154

Using Hyperlinks View 1157

Managing Your Web Site Projects 1160

Viewing Web Reports 1162

Viewing, Verifying, and Repairing
Hyperlinks 1165

Publishing Your Web 1166

Chapter 50 Creating and Modifying Web Pages 1169

Opening a Page in Page View 1170

Creating a New Page in a Web 1171

Adding and Editing Basic Page Elements 1176

Common Editing Tasks 1176

Adding Text 1180

Adding Images 1186

Adding Horizontal Dividing Lines 1190

Adding Hyperlinks 1190

Adding Tables 1192

Chapter 51 Formatting Your Web Pages 1199

Formatting Text 1200

Formatting Paragraphs 1203

Applying Borders and Shading 1206

Positioning a Paragraph 1208

Creating Dynamic HTML Effects 1210

Formatting Images 1211

Setting the Image Properties 1212

Modifying an Image Using the Pictures
Toolbar 1214

Formatting Other Page Elements 1218

Formatting the Whole Page 1219

Setting the Page Properties 1219

Using Page Themes 1222

Applying Page Transition Effects 1225

Chapter 52 Adding Advanced Features to Your Web Pages 1227

Designing Forms 1228

Using Frames 1231

Adding FrontPage Components 1235

Inserting Advanced Elements 1239

Part IX

Small Business Tools 1241

Chapter 53 Analyzing Business Performance Using
Microsoft Small Business Financial Manager 1243

Getting Started with Financial Manager 1244

Comparing Loan and Lease Payments 1245

Reading a Comparison Report 1249

Building a Financial Database:
The Import Wizard 1250

Creating Financial Reports and Charts 1255

Using the Report Wizard 1255

Using the Chart Wizard 1257

Chapter 54 Managing Customers,
Direct Mail, and Business Plans 1259

Using Microsoft Small Business Customer
Manager 1260

Starting Customer Manager 1260

Using Hot Reports and Business Rules 1262

Searching Datasheets Using Filters and
the Find Command 1263

Using Word and Outlook to Contact
Customers 1263

Tracking Customer Activities in Your
Database 1264

Using Microsoft Direct Mail Manager 1266

Planning Your Mailing 1267

Creating Direct Mail Pieces 1268

Using Microsoft Business Planner 1274

Getting Started with Business Planner:
The Interview Wizard 1275

Picking Commands and Activities 1277

Managing Business Resources 1278

Creating a Business Plan 1279

Creating a Marketing Plan 1280

Part X

Integrating Microsoft
Office Applications 1283

Chapter 55 Sharing Data Among Office Applications 1285

Sharing Data in Different Ways 1286

Copying and Moving Data Statically 1288

Linking Data 1289

A Linking Example 1293

Embedding Data 1295

An Embedding Example 1299

Using the Office Tools 1301

Using the Clip Gallery 1303

Using the Equation Editor 1304

Using Graph 1307

Using Organization Chart 1309

Chapter 56 Using the Office Binder Program 1313

Creating a Binder 1314

Saving a Binder 1318

Closing a Binder 1319

Opening a Binder 1319

Editing Binder Sections 1320

Editing Within the Source Program Window 1323

Managing Binder Sections 1323

Using Binder Templates 1326

Printing a Binder 1328

Printing an Entire Binder or a Group of
Sections Within a Binder 1328

Printing a Single Section 1331

Chapter 57 Using Microsoft PhotoDraw 2000 1333

Exploring the PhotoDraw Workspace 1334

Starting PhotoDraw 1334

Using the Visual Menu 1336

Sizing PhotoDraw Pictures 1338

Saving a Picture 1341

Printing a Picture 1343

Using Templates to Create Illustrations 1345

Creating a Web-Page Button 1347

Planning a Web Button 1347

Building a Web Button Step by Step 1348

Editing Digital Photographs 1354

Cutting and Cropping Images 1354

Embellishing the Border (Outline) of a
Photograph 1356

Changing a Picture’s Color Values 1357

Touching Up Photos 1359

Adding Special Effects 1360

Part XI

Using Visual Basic
to Supercharge Office 1363

Chapter 58 Building Your First Office Macro 1365

Carpe Datum: Knowing When to Build a Macro 1366

Choosing an Office Application 1366

Recording a Macro 1367

Running a Macro 1369

Using the Macros Dialog Box 1370

Using a Shortcut Key to Run Macros 1371

Using Visual Basic to Edit a Macro 1372

Learning the Visual Basic Programming Tools 1375

Using the Menu Bar 1375

Using the Visual Basic Toolbars 1377

Using Project Explorer 1378

Using the Properties Window 1380

Moving, Docking, and Resizing Tools 1382

Using the Help System 1382

Exiting Visual Basic 1383

Chapter 59 Using Variables, Operators, and
Functions to Manage Information 1385

Reading a Visual Basic Program Statement 1386

What Is an Object? 1386

What Are Properties and Methods? 1387

Learning More About the Office Object
Model 1388

Using Office Constants 1389

Using Constants to Create Custom
Formatting 1390

Declaring Variables 1394

Making Reservations for Variables:
The Dim Statement 1395

Putting Variables to Work 1395

Using Visual Basic Functions 1395

Using a Variable to Store Input 1396

Using a Variable for Output 1399

Using Object Variables to Process Text 1401

Building Formulas 1404

Computing Formulas in Your Documents 1405

Chapter 60 Using Office Control Structures 1409

Writing Conditional Expressions 1410

Writing If...Then Decision Structures 1411

Testing Several Conditions in an If...Then
Decision Structure 1412

Writing Select Case Decision Structures 1416

Writing For...Next Loops 1419

Using a Loop to Manage Tables 1420

Using For...Each Loops 1423

Chapter 61 Using Toolbox Controls
to Create a User Interface 1427

Getting Started with UserForms 1428

Designing the User Interface 1428

Setting Properties 1432

Writing Event Procedures 1435

Using the TextBox Control to Process
Paragraphs 1438

Processing Text in a Word Document 1438

Reviewing the ParaScan Macro Code 1441

Chapter 62 Working with Office Application Objects 1445

Using Automation to Connect Applications 1446

Automating Application Objects Step
by Step 1447

Using Excel Objects 1448

Creating the ExcelPmt Macro 1448

Running the ExcelPmt Macro 1450

Using the Object Browser to Learn
About Objects 1451

Using Outlook Objects 1453

Creating the SendMail Macro 1453

Running the SendMail Macro 1454

Using PowerPoint Objects 1456

Creating the RunPresentation Macro 1456

Running the RunPresentation Macro 1457

Using Internet Explorer Objects 1458

Creating the WebPage Macro 1458

Running the WebPage Macro 1459

Index 1241

 

Acknowledgments

The really interesting thing about writing computer books is that the whole process begins well before the software is actually finished. Authors meet with computer book publishers, learn about new software features, develop a writing plan, and begin testing their ideas with beta versions of the product. This iterative process produces important insights and continues (with mounting fervor) until the software is complete and the final books are shipped to the printer—whew!

Microsoft Press is an awesome place to write a computer book. At each stage in the publishing process, talented team members work together to cultivate valuable technical contacts and resources, build visionary product deployment strategies, and explore the hidden benefits of emerging technologies. Running Microsoft Office 2000, now in its third edition, has benefited handsomely from this dynamic and innovative publishing environment.

In particular, the authors would like to thank Kim Fryer, Casey Doyle, Lucinda Rowley, and Christey Bahn, for their generous support in product planning and book development; Project Editor Saul Candib, at Microsoft Press, who personally handled all of our problems and requests—you saved us, Saul; tireless Project Manager Lisa Labrecque (in lovely San Francisco) and her team of truly dedicated professionals at Labrecque Publishing Services, Inc.; Terrence O’Donnell, our jack-of-all-trades (technical editor, copyeditor, product tester, and all-around Office 2000 guru)—you’re amazing, Terry; and Chrisa Hotchkiss, Curtis Philips, Lisa Bravo, and Andrea Fox, who collectively helped us edit and produce three separate editions of this book—roughly 4,500 pages!

The authors warmly acknowledge the writing contributions of Kathie Werner, who revised the PowerPoint Part and wrote four chapters in the Publisher Part. Kathie has an incredible work ethic and writes like a seasoned professional. Thanks for sharing your many talents with us, Kathie!