Microsoft Office 2007: Introductory Premium Video Edition

Front Cover......Page 1
Title Page......Page 3
Copyright......Page 4
Contents......Page 11
Preface......Page 6
Unit A: Understanding Essential Computer Concepts......Page 27
Investigating Types of Computers......Page 28
Examining Computer Systems......Page 30
Examining Input Devices......Page 32
Examining Output Devices......Page 34
Investigating Data Processing......Page 36
Understanding Memory......Page 38
Understanding Storage Media......Page 40
Exploring Data Communications......Page 42
Learning about Networks......Page 44
Learning about Security Threats......Page 46
Understanding System Software......Page 48
Understanding Application Software......Page 50
Concepts Review......Page 52
Independent Challenges......Page 55
Unit A: Getting Started with Windows Vista......Page 59
Starting Windows Vista......Page 60
Using a Pointing Device......Page 62
Starting a Program......Page 64
Moving and Resizing Windows......Page 66
Using Menus, Toolbars, and Keyboard Shortcuts......Page 68
Using Dialog Boxes......Page 70
Using Scroll Bars......Page 72
Using Windows Help and Support......Page 74
Ending a Windows Vista Session......Page 76
Concepts Review......Page 78
Skills Review......Page 79
Independent Challenges......Page 80
Visual Workshop......Page 82
Unit B: Understanding File Management......Page 83
Managing Folders and Files......Page 84
Opening the Computer Window......Page 86
Creating and Saving Documents......Page 88
Opening the Documents Folder......Page 90
Copying Files......Page 92
Opening, Editing, and Printing Files......Page 94
Moving and Renaming Files......Page 96
Searching for Files......Page 98
Deleting and Restoring Files......Page 100
Concepts Review......Page 102
Skills Review......Page 103
Independent Challenges......Page 104
Visual Workshop......Page 106
Unit A: Getting Started with Internet Explorer 7......Page 107
Understanding Web Browsers......Page 108
Exploring the Browser......Page 110
Viewing and Navigating Web Pages......Page 112
Using Tabbed Browsing......Page 114
Saving Favorite Web Pages......Page 116
Printing a Web Page......Page 118
Searching for Information......Page 120
Getting Help and Exiting Internet Explorer......Page 122
Concepts Review......Page 124
Skills Review......Page 125
Independent Challenges......Page 127
Visual Workshop......Page 130
Unit A: Getting Started with Microsoft Office 2007......Page 131
Understanding the Office 2007 Suite......Page 132
Starting and Exiting an Office Program......Page 134
Viewing the Office 2007 User Interface......Page 136
Creating and Saving a File......Page 138
Opening a File and Saving it with a New Name......Page 140
Viewing and Printing Your Work......Page 142
Getting Help and Closing a File......Page 144
Independent Challenge......Page 146
Unit A: Creating Documents with Word 2007......Page 147
Understanding Word Processing Software......Page 148
Exploring the Word Program Window......Page 150
Starting a Document......Page 152
Saving a Document......Page 154
Selecting Text......Page 156
Formatting Text Using the Mini Toolbar......Page 158
Creating a Document Using a Template......Page 160
Viewing and Navigating a Document......Page 162
Concepts Review......Page 164
Skills Review......Page 165
Independent Challenges......Page 167
Visual Workshop......Page 170
Unit B: Editing Documents......Page 171
Cutting and Pasting Text......Page 172
Copying and Pasting Text......Page 174
Using the Office Clipboard......Page 176
Finding and Replacing Text......Page 178
Checking Spelling and Grammar......Page 180
Researching Information......Page 182
Adding Hyperlinks......Page 184
Preparing a Document for Distribution......Page 186
Concepts Review......Page 188
Skills Review......Page 189
Independent Challenges......Page 191
Visual Workshop......Page 194
Unit C: Formatting Text and Paragraphs......Page 195
Formatting with Fonts......Page 196
Copying Formats Using the Format Painter......Page 198
Changing Line and Paragraph Spacing......Page 200
Aligning Paragraphs......Page 202
Working with Tabs......Page 204
Working with Indents......Page 206
Adding Bullets and Numbering......Page 208
Adding Borders and Shading......Page 210
Adding Footnotes and Endnotes......Page 212
Concepts Review......Page 214
Skills Review......Page 215
Independent Challenges......Page 218
Visual Workshop......Page 222
Unit D: Formatting Documents......Page 223
Setting Document Margins......Page 224
Dividing a Document into Sections......Page 226
Inserting Page Breaks......Page 228
Formatting Columns......Page 230
Inserting Page Numbers......Page 232
Adding Headers and Footers......Page 234
Editing Headers and Footers......Page 236
Inserting a Table......Page 238
Inserting Clip Art......Page 240
Concepts Review......Page 242
Skills Review......Page 243
Independent Challenges......Page 246
Visual Workshop......Page 250
Unit A: Getting Started with Excel 2007......Page 251
Understanding Spreadsheet Software......Page 252
Touring the Excel 2007 Window......Page 254
Understanding Formulas......Page 256
Entering Labels and Values and Using AutoSum......Page 258
Editing Cell Entries......Page 260
Entering and Editing a Simple Formula......Page 262
Switching Worksheet Views......Page 264
Choosing Print Options......Page 266
Concepts Review......Page 268
Skills Review......Page 269
Independent Challenges......Page 270
Visual Workshop......Page 274
Unit B: Working with Formulas and Functions......Page 275
Creating a Complex Formula......Page 276
Inserting a Function......Page 278
Typing a Function......Page 280
Copying and Moving Cell Entries......Page 282
Understanding Relative and Absolute Cell References......Page 284
Copying Formulas with Relative Cell References......Page 286
Copying Formulas with Absolute Cell References......Page 288
Rounding a Value with a Function......Page 290
Concepts Review......Page 292
Skills Review......Page 294
Independent Challenges......Page 296
Visual Workshop......Page 300
Unit C: Formatting a Worksheet......Page 301
Formatting Values......Page 302
Changing Font and Font Size......Page 304
Changing Attributes and Alignment......Page 306
Adjusting Column Width......Page 308
Inserting and Deleting Rows and Columns......Page 310
Applying Colors, Patterns, and Borders......Page 312
Applying Conditional Formatting......Page 314
Naming and Moving a Sheet......Page 316
Checking Spelling......Page 318
Concepts Review......Page 320
Skills Review......Page 321
Independent Challenges......Page 323
Visual Workshop......Page 328
Unit D: Working with Charts......Page 329
Planning a Chart......Page 330
Creating a Chart......Page 332
Moving and Resizing a Chart......Page 334
Changing the Chart Design......Page 336
Changing the Chart Layout......Page 338
Formatting a Chart......Page 340
Annotating and Drawing on a Chart......Page 342
Create a Pie Chart......Page 344
Concepts Review......Page 346
Skills Review......Page 347
Independent Challenges......Page 349
Visual Workshop......Page 354
Unit A: Integrating Word and Excel......Page 355
Integrating Data Between Word and Excel......Page 356
Copying Data from Excel to Word......Page 358
Copying a Chart from Excel to Word......Page 360
Creating Linked Objects......Page 362
Embedding a Word File in Excel......Page 364
Skills Review......Page 366
Independent Challenges......Page 368
Visual Workshop......Page 370
Unit A: Getting Started with Access 2007......Page 371
Understanding Relational Databases......Page 372
Opening a Database......Page 374
Entering Data......Page 376
Editing Data......Page 378
Creating a Database......Page 380
Creating a Table......Page 382
Creating Primary Keys......Page 384
Relating Two Tables......Page 386
Printing a Datasheet......Page 388
Concepts Review......Page 390
Skills Review......Page 391
Independent Challenges......Page 393
Visual Workshop......Page 396
Unit B: Building and Using Queries......Page 397
Creating a Query......Page 398
Using Query Design View......Page 400
Modifying Queries......Page 402
Sorting and Finding Data......Page 404
Filtering Data......Page 406
Applying AND Criteria......Page 408
Applying OR Criteria......Page 410
Formatting a Datasheet......Page 412
Concepts Review......Page 414
Skills Review......Page 415
Independent Challenges......Page 417
Visual Workshop......Page 420
Unit C: Using Forms......Page 421
Creating a Form......Page 422
Using Form Layout View......Page 424
Using Form Design View......Page 426
Adding Fields to a Form......Page 428
Modifying Form Controls......Page 430
Creating Calculations......Page 432
Modifying Tab Order......Page 434
Inserting an Image......Page 436
Concepts Review......Page 438
Skills Review......Page 440
Independent Challenges......Page 442
Visual Workshop......Page 446
Unit D: Using Reports......Page 447
Previewing a Report......Page 448
Using the Report Wizard......Page 450
Using Report Design View......Page 452
Using Report Sections......Page 454
Adding Subtotals and Counts......Page 456
Resizing and Aligning Controls......Page 458
Formatting a Report......Page 460
Changing Page Layout......Page 462
Concepts Review......Page 464
Skills Review......Page 466
Independent Challenges......Page 469
Visual Workshop......Page 474
Unit B: Integrating Word, Excel, and Access......Page 475
Integrating Data Among Word, Excel, and Access......Page 476
Importing an Excel Worksheet into Access......Page 478
Copying a Word Table to Access......Page 480
Linking an Access Table to Excel and Word......Page 482
Linking an Access Table to Word......Page 484
Skills Review......Page 486
Independent Challenge......Page 488
Visual Workshop......Page 490
Unit A: Creating a Presentation in PowerPoint 2007......Page 491
Defining Presentation Software......Page 492
Planning an Effective Presentation......Page 494
Examining the PowerPoint Window......Page 496
Entering Slide Text......Page 498
Adding a New Slide......Page 500
Applying a Design Theme......Page 502
Comparing Presentation Views......Page 504
Printing a PowerPoint Presentation......Page 506
Concepts Review......Page 508
Skills Review......Page 509
Independent Challenges......Page 511
Visual Workshop......Page 514
Unit B: Modifying a Presentation......Page 515
Entering Text in the Outline Tab......Page 516
Formatting Text......Page 518
Converting Text to SmartArt......Page 520
Inserting and Modifying Shapes......Page 522
Editing and Duplicating Shapes......Page 524
Aligning and Grouping Objects......Page 526
Adding Slide Headers and Footers......Page 528
Checking Spelling in a Presentation......Page 530
Concepts Review......Page 532
Skills Review......Page 533
Independent Challenges......Page 535
Visual Workshop......Page 538
Unit C: Inserting Objects into a Presentation......Page 539
Inserting Text from Microsoft Word......Page 540
Inserting Clip Art......Page 542
Inserting and Styling a Picture......Page 544
Inserting a Text Box......Page 546
Inserting a Chart......Page 548
Entering and Editing Chart Data......Page 550
Inserting a Table......Page 552
Insert and Format WordArt......Page 554
Concepts Review......Page 556
Skills Review......Page 557
Independent Challenges......Page 559
Visual Workshop......Page 562
Unit D: Finishing a Presentation......Page 563
Understanding Masters......Page 564
Customizing the Background Style......Page 566
Using Slide Show Commands......Page 568
Setting Slide Show Transitions and Timings......Page 570
Setting Slide Animation Effects......Page 572
Inspecting a Presentation......Page 574
Evaluating a Presentation......Page 576
Creating a Design Template......Page 578
Concepts Review......Page 580
Skills Review......Page 581
Independent Challenges......Page 583
Visual Workshop......Page 586
Unit C: Integrating Word, Excel, Access, and PowerPoint......Page 587
Integrating Data Among Word, Excel, Access, and PowerPoint......Page 588
Importing a Word Outline into PowerPoint......Page 590
Embedding an Excel Worksheet in PowerPoint......Page 592
Linking Access and Excel Objects to PowerPoint......Page 594
Managing Links......Page 596
Skills Review......Page 598
Independent Challenges......Page 600
Visual Workshop......Page 602
Unit A: Getting Started with E-Mail......Page 603
Communicating with E-Mail......Page 604
Compiling an E-Mail Address Book......Page 606
Creating and Sending a Message......Page 608
Manage E-Mail Folders......Page 610
Receiving and Replying to a Message......Page 612
Forwarding a Message......Page 614
Sending a Message with an Attachment......Page 616
Employing Good E-Mail Practices......Page 618
Concepts Review......Page 620
Skills Review......Page 622
Independent Challenges......Page 624
Visual Workshop......Page 626
Unit B: Managing Information Using Outlook......Page 627
Starting Outlook......Page 628
Organizing E-Mail......Page 630
Organizing Contacts......Page 632
Managing Appointments......Page 634
Managing Tasks......Page 636
Creating Notes......Page 638
Using the Journal......Page 640
Applying Categories......Page 642
Concepts Review......Page 644
Skills Review......Page 646
Independent Challenges......Page 649
Visual Workshop......Page 650
Unit A: Getting Started with Windows XP......Page 651
Starting Windows and Viewing the Desktop......Page 652
Using the Mouse......Page 654
Starting a Program......Page 656
Moving and Resizing Windows......Page 658
Using Menus, Keyboard Shortcuts, and Toolbars......Page 660
Using Dialog Boxes......Page 662
Using Scroll Bars......Page 664
Using Windows Help and Support Center......Page 666
Closing a Program and Shutting Down Windows......Page 668
Concepts Review......Page 670
Skills Review......Page 671
Independent Challenges......Page 673
Visual Workshop......Page 674
Unit B: Understanding File Management......Page 675
Creating and Saving a WordPad Document......Page 676
Opening, Editing, and Saving an Existing Paint File......Page 678
Working with Multiple Programs......Page 680
Defining File Management......Page 682
Working with a USB Drive......Page 684
Viewing Files and Creating Folders with My Computer......Page 686
Moving and Copying Files with My Computer......Page 688
Managing Files with Windows Explorer......Page 690
Searching for Files......Page 692
Deleting and Restoring Files......Page 694
Concepts Review......Page 696
Skills Review......Page 698
Independent Challenges......Page 700
Visual Workshop......Page 702
Capstone Projects......Page 703
Word 2007 Capstone Projects......Page 704
Excel 2007 Capstone Projects......Page 708
Access 2007 Capstone Projects......Page 712
PowerPoint 2007 Capstone Projects......Page 716
Integration Office 2007 Capstone Projects......Page 720
Using SAM Projects......Page 725
Creating a SAM User Profile......Page 726
Joining a Section (Class)......Page 728
Understanding the Process of Using SAM Projects......Page 730
Understanding SAM Projects Reports......Page 732
SAM Projects Independent Challenges......Page 734
Glossary......Page 759
Index......Page 779