Beskeen/Cram/duffy/friedrichsen/reding's Microsoft Office 2007-illustrated Introductory Premium Video, Enhanced Vista Edition

Give your students a comprehensive, hands-on, and engaging learning experience with the MICROSOFT OFFICE 2007-ILLUSTRATED INTRODUCTORY PREMIUM VIDEO EDITION. This Premium Video Edition includes a Video Companion containing approximately 150 videos each based on a two-page lesson in the book, 10 Capstone Projects and SAM Projects instruction files to help "Bring Learning To Life" For both the computer "rookies" and the computer "hotshots" - MICROSOFT OFFICE 2007-ILLUSTRATED INTRODUCTORY PREMIUM VIDEO EDITION appeals to all the learners, covering the essential information that users need to know now. Our signature two-page spread design has been updated and refreshed to take full advantage of the new features of the Office 2007 software. This practical, easy-to-navigate book provides readers with the essential knowledge they need to succeed in both the classroom and beyond. 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

now Available In Spanish! This Microsoft Office 2007 Illustrated Series Book Covers The Essential Information That You Need To Know About How To Use Office 2007 Applications. Our Signature Two-page Spread Design Has Been Updated And Refreshed To Take Full Advantage Of The New Features Of The Office 2007 Software. This Practical, Easy To Navigate Book Provides You With The Essential Knowledge You Need To Succeed At Both Work And Beyond.