Microsoft Office 2010

ESSENTIAL COMPUTER CONCEPTS Learning About the Components of Computer Systems - Page 28
ESSENTIAL COMPUTER CONCEPTS Learning About the Components of Computer Systems - Page 29
ESSENTIAL COMPUTER CONCEPTS Learning About the Components of Computer Systems - Page 30
What Is a Computer? - Page 31
What Is a Computer? - Page 32
Computer Systems - Page 33
Data Representation - Page 34
Processing Hardware - Page 35
Microprocessor - Page 36
Microprocessor - Page 37
Storage Media - Page 38
Storage Media - Page 39
Storage Media - Page 40
Storage Media - Page 41
Input and Output - Page 42
Input and Output - Page 43
Output Devices - Page 44
Output Devices - Page 45
Data Communications - Page 46
Data Communications - Page 47
Networks - Page 48
Telecommunications - Page 49
Security Threats on Your Computer - Page 50
Security Threats on Your Computer - Page 51
Security Threats on Your Computer - Page 52
Computer Software - Page 53
Application Software - Page 54
Application Software - Page 55
Application Software - Page 56
Application Software - Page 57
Application Software - Page 58
Computing in the Cloud - Page 59
Putting It All Together - Page 60
Putting It All Together - Page 61
Putting It All Together - Page 62
Putting It All Together - Page 63
Putting It All Together - Page 64
Proskills: Decision Making - Page 65
Proskills: Decision Making - Page 66
Proskills: Decision Making - Page 67
EXPLORING THE BASICS OF MICROSOFT WINDOWS 7 Investigating the Windows 7 Operating System - Page 68
Session 1 - Page 69
Session 1 - Page 70
Starting Windows 7. - Page 71
Touring the Windows 7 Desktop - Page 72
Touring the Windows 7 Desktop - Page 73
Touring the Windows 7 Desktop - Page 74
Touring the Windows 7 Desktop - Page 75
Exploring the Start Menu - Page 76
Exploring the Start Menu - Page 77
Exploring the Start Menu - Page 78
Running Multiple Programs - Page 79
Switching Between Programs - Page 80
Closing Programs from the Taskbar - Page 81
Using Windows and Dialog Boxes - Page 82
Using Windows and Dialog Boxes - Page 83
Manipulating Windows - Page 84
Using the Ribbon - Page 85
Using List Boxes - Page 86
Working with Dialog Boxes - Page 87
Session 1 Quick Check - Page 88
Session 2 - Page 89
Session 2 - Page 90
Exploring Your Computer - Page 91
Exploring Your Computer - Page 92
Changing the View - Page 93
Navigating with Windows Explorer - Page 94
Navigating with Windows Explorer - Page 95
Getting Help - Page 96
Viewing Windows Basics Topics - Page 97
Selecting a Topic from the Contents List - Page 98
Turning Off Windows 7 - Page 99
Session 2 Quick Check - Page 100
Review Assignments - Page 101
Case Problems - Page 102
Apply: Case Problem 2 - Page 103
Challenge: Case Problem 3 - Page 104
Research: Case Problem 4 - Page 105
ProSkills Exercise: Problem Solving - Page 106
ProSkills Exercise: Problem Solving - Page 107
MANAGING YOUR FILES Organizing Files and Folders with Windows 7 - Page 108
MANAGING YOUR FILES Organizing Files and Folders with Windows 7 - Page 109
MANAGING YOUR FILES Organizing Files and Folders with Windows 7 - Page 110
Organizing Files and Folders - Page 111
Developing Strategies for Organizing Files and Folders - Page 112
Exploring Files, Folders, and Libraries - Page 113
Using Libraries and Folders - Page 114
Using Libraries and Folders - Page 115
Navigating to Your Data Files - Page 116
Navigating to Your Data Files - Page 117
Managing Folders and Files - Page 118
Moving and Copying Files and Folders - Page 119
Moving and Copying Files and Folders - Page 120
Moving and Copying Files and Folders - Page 121
Naming and Renaming Files - Page 122
Naming and Renaming Files - Page 123
Deleting Files and Folders - Page 124
Deleting Files and Folders - Page 125
Quick Check - Page 126
Review Assignments - Page 127
Review Assignments - Page 128
Review Assignments - Page 129
ProSkills Exercise: Decision Making - Page 130
ProSkills Exercise: Decision Making - Page 131
BROWSER AND EMAIL BASICS Introduction to Microsoft Internet Explorer and Microsoft Windows Live Mail - Page 132
BROWSER AND EMAIL BASICS Introduction to Microsoft Internet Explorer and Microsoft Windows Live Mail - Page 133
BROWSER AND EMAIL BASICS Introduction to Microsoft Internet Explorer and Microsoft Windows Live Mail - Page 134
The Internet and the Web - Page 135
Search Engines and Uniform Resource Locators - Page 136
Entering a URL in the Address Bar - Page 137
Entering a URL in the Address Bar - Page 138
Using the Favorites Center - Page 139
Using the Favorites List - Page 140
Subscribing to an RSS Feed - Page 141
Printing and Saving a Web Page - Page 142
Printing and Saving a Web Page - Page 143
Session 1 Quick Check - Page 144
Session 1 Quick Check - Page 145
Session 1 Quick Check - Page 146
Exploring Email - Page 147
Sending and Receiving Email Using Windows Live Mail - Page 148
Sending and Receiving Email Using Windows Live Mail - Page 149
Working with Email Messages - Page 150
Deleting Email Messages - Page 151
Adding Contacts to Your Contacts Folder - Page 152
Attaching a File to a Message - Page 153
Attaching a File to a Message - Page 154
Managing Your Schedule with Windows Live Calendar - Page 155
Session 2 Quick Check - Page 156
Review Assignments - Page 157
Case Problems - Page 158
Case Problems - Page 159
Case Problems - Page 160
Case Problems - Page 161
ProSkills Exercise: Written Communication - Page 162
ProSkills Exercise: Written Communication - Page 163
GETTING STARTED WITH MICROSOFT OFFICE 2010 Preparing a Meeting Agenda - Page 164
GETTING STARTED WITH MICROSOFT OFFICE 2010 Preparing a Meeting Agenda - Page 165
GETTING STARTED WITH MICROSOFT OFFICE 2010 Preparing a Meeting Agenda - Page 166
Exploring Microsoft Office 2010 - Page 167
Starting Office Programs - Page 168
Starting Office Programs - Page 169
Switching Between Open Programs and Files - Page 170
Exploring Common Window Elements - Page 171
Switching Views - Page 172
Switching Views - Page 173
Using the Ribbon - Page 174
Clicking Buttons - Page 175
Clicking Buttons - Page 176
Using Galleries and Live Preview - Page 177
Using Galleries and Live Preview - Page 178
Using Contextual Tools - Page 179
Opening Shortcut Menus - Page 180
Working with Files - Page 181
Saving a File - Page 182
Saving a File - Page 183
Saving a File - Page 184
Closing a File - Page 185
Closing a File - Page 186
Sharing Files Using Windows Live SkyDrive - Page 187
Getting Help - Page 188
Using the Help Window - Page 189
Using the Help Window - Page 190
Printing a File - Page 191
Printing a File - Page 192
Exiting Programs - Page 193
Review Assignments - Page 194
ProSkills Exercise: Teamwork - Page 195
WORD LEVEL I TUTORIALS Tutorial 1 Creating a Document Writing a Business Letter and Formatting a Flyer - Page 196
Session 1.1 - Page 197
Session 1.1 - Page 198
Starting Word - Page 199
Creating a Block Style Business Letter - Page 200
Entering Text - Page 201
Entering the Inside Address - Page 202
Entering the Inside Address - Page 203
Entering the Inside Address - Page 204
Using the Undo and Redo Buttons - Page 205
Correcting Errors as You Type - Page 206
Correcting Errors as You Type - Page 207
Correcting Errors as You Type - Page 208
Correcting Errors as You Type - Page 209
Proofreading a Finished Document - Page 210
Proofreading a Finished Document - Page 211
Proofreading a Finished Document - Page 212
Proofreading a Finished Document - Page 213
Adjusting the Margins - Page 214
Adjusting the Margins - Page 215
Previewing and Printing a Document - Page 216
Previewing and Printing a Document - Page 217
Opening a Blank Document and Creating an Envelope - Page 218
Opening a Blank Document and Creating an Envelope - Page 219
Session 1.1 Quick Check - Page 220
Session 1.2 - Page 221
Session 1.2 - Page 222
Opening an Existing Document - Page 223
Opening an Existing Document - Page 224
Changing Page Orientation - Page 225
Changing the Font and Font Size - Page 226
Changing the Font and Font Size - Page 227
Applying Text Effects, Font Colors, and Font Styles - Page 228
Applying Text Effects, Font Colors, and Font Styles - Page 229
Applying Text Effects, Font Colors, and Font Styles - Page 230
Aligning Text - Page 231
Aligning Text - Page 232
Adding a Paragraph Border and Shading - Page 233
Adding a Paragraph Border and Shading - Page 234
Inserting, Deleting and Resizing a Photo - Page 235
Inserting, Deleting and Resizing a Photo - Page 236
Inserting, Deleting and Resizing a Photo - Page 237
Session 1.2 Quick Check - Page 238
Review Assignments - Page 239
Review Assignments - Page 240
Case Problems - Page 241
Case Problems - Page 242
Case Problems - Page 243
Case Problems - Page 244
Case Problems - Page 245
Case Problems - Page 246
Case Problems - Page 247
Tutorial 2 Editing and Formatting a Document Editing an Academic Document According to MLA Style - Page 248
Session 2.1 - Page 249
Session 2.1 - Page 250
Revising a Document - Page 251
Revising a Document - Page 252
Creating Bulleted and Numbered Lists - Page 253
Creating Bulleted and Numbered Lists - Page 254
Moving Text in a Document - Page 255
Dragging and Dropping Text - Page 256
Cutting or Copying and Pasting Text using the Clipboard - Page 257
Cutting or Copying and Pasting Text using the Clipboard - Page 258
Cutting or Copying and Pasting Text using the Clipboard - Page 259
Cutting or Copying and Pasting Text using the Clipboard - Page 260
Cutting or Copying and Pasting Text using the Clipboard - Page 261
Finding and Replacing Text - Page 262
Finding and Replacing Text - Page 263
Finding and Replacing Text - Page 264
Finding and Replacing Text - Page 265
Using the Spelling and Grammar Checker - Page 266
Using the Spelling and Grammar Checker - Page 267
Working with Styles - Page 268
Working with Styles - Page 269
Working with Heading Levels - Page 270
Working with Themes - Page 271
Working with Themes - Page 272
Working with Themes - Page 273
Session 2.1 Quick Check - Page 274
Session 2.2 - Page 275
Session 2.2 - Page 276
Reviewing the MLA Style - Page 277
Indenting a Paragraph - Page 278
Indenting a Paragraph - Page 279
Indenting a Paragraph - Page 280
Inserting and Modifying Page Numbers - Page 281
Inserting and Modifying Page Numbers - Page 282
Creating Citations and a Bibliography - Page 283
Creating Citations - Page 284
Creating Citations - Page 285
Creating Citations - Page 286
Creating Citations - Page 287
Creating Citations - Page 288
Creating Citations - Page 289
Generating a Bibliography - Page 290
Generating a Bibliography - Page 291
Modifying an Existing Source - Page 292
Updating a Bibliography - Page 293
Updating a Bibliography - Page 294
Session 2.2 Quick Check - Page 295
Review Assignments - Page 296
Review Assignments - Page 297
Case Problems - Page 298
Case Problems - Page 299
Case Problems - Page 300
Case Problems - Page 301
Case Problems - Page 302
Case Problems - Page 303
Tutorial 3 Creating a Multiple-Page Report Writing a Recommendation - Page 304
Session 3.1 - Page 305
Session 3.1 - Page 306
Working with Headings in the Navigation Pane - Page 307
Working with Headings in the Navigation Pane - Page 308
Working with Headings in the Navigation Pane - Page 309
Working with Headings in the Navigation Pane - Page 310
Inserting a Blank Table - Page 311
Inserting a Blank Table - Page 312
Entering Data in a Table - Page 313
Entering Data in a Table - Page 314
Selecting Part of a Table - Page 315
Sorting Rows in a Table - Page 316
Sorting Rows in a Table - Page 317
Inserting Rows and Columns in a Table - Page 318
Deleting Rows and Columns - Page 319
Changing Column Widths - Page 320
Formatting Tables with Styles - Page 321
Formatting Tables with Styles - Page 322
Formatting Tables with Styles - Page 323
Session 3.1 Quick Check - Page 324
Session 3.2 - Page 325
Session 3.2 - Page 326
Setting Tab Stops - Page 327
Setting Tab Stops - Page 328
Setting Tab Stops - Page 329
Creating Footnotes and Endnotes - Page 330
Creating Footnotes and Endnotes - Page 331
Creating Footnotes and Endnotes - Page 332
Formatting a Document in Sections - Page 333
Formatting a Document in Sections - Page 334
Creating SmartArt - Page 335
Creating SmartArt - Page 336
Creating SmartArt - Page 337
Creating SmartArt - Page 338
Adding Headers and Footers - Page 339
Adding Headers and Footers - Page 340
Adding Headers and Footers - Page 341
Adding Headers and Footers - Page 342
Adding Headers and Footers - Page 343
Adding Headers and Footers - Page 344
Inserting a Cover Page - Page 345
Inserting a Cover Page - Page 346
Inserting a Cover Page - Page 347
Session 3.2 Quick Check - Page 348
Review Assignments - Page 349
Case Problems - Page 350
Case Problems - Page 351
Case Problems - Page 352
Case Problems - Page 353
Case Problems - Page 354
Case Problems - Page 355
Tutorial 4 Desktop Publishing and Mail Merge Creating a Newsletter and Cover Letter - Page 356
Session 4.1 - Page 357
Session 4.1 - Page 358
Formatting Text in Columns - Page 359
Formatting Text in Columns - Page 360
Inserting Drop Caps - Page 361
Inserting Symbols and Special Characters - Page 362
Inserting Symbols and Special Characters - Page 363
Using WordArt to Create a Headline - Page 364
Using WordArt to Create a Headline - Page 365
Wrapping Text Around a Graphic - Page 366
Wrapping Text Around a Graphic - Page 367
Resizing WordArt - Page 368
Resizing WordArt - Page 369
Applying WordArt Styles - Page 370
Applying WordArt Styles - Page 371
Applying WordArt Styles - Page 372
Applying WordArt Styles - Page 373
Applying WordArt Styles - Page 374
Cropping a Graphic - Page 375
Cropping a Graphic - Page 376
Cropping a Graphic - Page 377
Cropping a Graphic - Page 378
Moving and Aligning a Graphic - Page 379
Session 4.1 Quick Check - Page 380
Session 4.2 - Page 381
Session 4.2 - Page 382
Editing Photographs - Page 383
Editing Photographs - Page 384
Removing a Photo’s Background - Page 385
Removing a Photo’s Background - Page 386
Removing a Photo’s Background - Page 387
Applying a Picture Style - Page 388
Applying a Picture Style - Page 389
Balancing Columns - Page 390
Inserting a Border Around a Page - Page 391
Inserting a Border Around a Page - Page 392
Performing a Simple Mail Merge - Page 393
Performing a Simple Mail Merge - Page 394
Selecting a Data Source - Page 395
Inserting Merge Fields - Page 396
Inserting Merge Fields - Page 397
Inserting Merge Fields - Page 398
Previewing the Merged Document - Page 399
Merging the Main Document and Data Source. - Page 400
Session 4.2 Quick Check - Page 401
Review Assignments - Page 402
Case Problems - Page 403
Case Problems - Page 404
Case Problems - Page 405
Case Problems - Page 406
Case Problems - Page 407
Case Problems - Page 408
ProSkills Exercise: Written Communication - Page 409
ProSkills Exercise: Written Communication - Page 410
ProSkills Exercise: Written Communication - Page 411
EXCEL LEVEL I TUTORIALS Tutorial 1 Getting Started with Excel Creating an Order Report - Page 412
Session 1.1 - Page 413
Session 1.1 - Page 414
Introducing Excel - Page 415
Navigating Between Worksheets - Page 416
Navigating Within a Worksheet - Page 417
Navigating Within a Worksheet - Page 418
Planning a Workbook - Page 419
Entering Text, Numbers, and Dates - Page 420
Entering Text, Numbers, and Dates - Page 421
Entering Multiple Lines of Text Within a Cell - Page 422
Entering Dates - Page 423
Entering Numbers - Page 424
Entering Numbers - Page 425
Working with Columns and Rows - Page 426
Working with Columns and Rows - Page 427
Setting Row Heights - Page 428
Inserting a Column or Row - Page 429
Inserting a Column or Row - Page 430
Deleting and Clearing a Row or Column - Page 431
Session 1.1 Quick Check - Page 432
Session 1.2 - Page 433
Session 1.2 - Page 434
Working with Cells and Ranges - Page 435
Working with Cells and Ranges - Page 436
Moving and Copying a Range - Page 437
Moving and Copying a Range - Page 438
Inserting and Deleting a Range - Page 439
Inserting and Deleting a Range - Page 440
Working with Formulas - Page 441
Working with Formulas - Page 442
Working with Formulas - Page 443
Copying and Pasting Formulas - Page 444
Introducing Functions - Page 445
Entering Functions with the AutoSum Feature - Page 446
Entering Functions with the AutoSum Feature - Page 447
Working with Worksheets - Page 448
Renaming a Worksheet - Page 449
Renaming a Worksheet - Page 450
Undoing and Redoing an Action - Page 451
Using the Spelling Checker - Page 452
Using the Spelling Checker - Page 453
Previewing and Printing a Workbook - Page 454
Working with Portrait and Landscape Orientation - Page 455
Printing the Workbook - Page 456
Viewing and Printing Worksheet Formulas - Page 457
Viewing and Printing Worksheet Formulas - Page 458
Session 1.2 Quick Check - Page 459
Review Assignments - Page 460
Case Problems - Page 461
Case Problems - Page 462
Case Problems - Page 463
Case Problems - Page 464
Case Problems - Page 465
Case Problems - Page 466
Case Problems - Page 467
Tutorial 2 Formatting a Workbook Designing a Financial Report - Page 468
Session 2.1 - Page 469
Session 2.1 - Page 470
Formatting Cell Text - Page 471
Applying Fonts and Font Styles - Page 472
Applying a Font Color - Page 473
Formatting Text Selections - Page 474
Working with Colors and Backgrounds - Page 475
Adding a Background Image - Page 476
Formatting Calculated Values - Page 477
Formatting Calculated Values - Page 478
Applying Number Formats - Page 479
Applying Number Formats - Page 480
Applying Number Formats - Page 481
Formatting Dates and Times - Page 482
Formatting Worksheet Cells - Page 483
Indenting Cell Content - Page 484
Merging Cells - Page 485
Rotating Cell Contents - Page 486
Adding Cell Borders - Page 487
Exploring Options in the Format Cells Dialog Box - Page 488
Exploring Options in the Format Cells Dialog Box - Page 489
Copying and Pasting Formats - Page 490
Copying Formats with the Paste Options Button - Page 491
Copying Formats with Paste Special - Page 492
Session 2.2 - Page 493
Session 2.2 - Page 494
Applying Cell Styles - Page 495
Applying Cell Styles - Page 496
Working with Themes - Page 497
Working with Themes - Page 498
Creating Formulas to Add and Subtract Values - Page 499
Creating Formulas to Subtract Values - Page 500
Creating Formulas to Subtract Values - Page 501
Working with Table Styles - Page 502
Working with Table Styles - Page 503
Selecting Table Style Options - Page 504
Selecting Table Style Options - Page 505
Highlighting Cells with Conditional Formats - Page 506
Highlighting Cells with Conditional Formats - Page 507
Highlighting Cells with Conditional Formats - Page 508
Highlighting Cells with Conditional Formats - Page 509
Highlighting Cells with Conditional Formats - Page 510
Highlighting Cells with Conditional Formats - Page 511
Hiding Worksheet Data - Page 512
Defining the Print Area - Page 513
Inserting Page Breaks - Page 514
Adding Print Titles - Page 515
Creating Page Headers and Footers - Page 516
Creating Page Headers and Footers - Page 517
Defining the Page Margins - Page 518
Review Assignments - Page 519
Case Problems. - Page 520
Case Problems. - Page 521
Case Problems. - Page 522
Case Problems. - Page 523
Case Problems. - Page 524
Case Problems. - Page 525
Tutorial 3 Working with Formulas and Functions Developing a Family Budget - Page 526
Session 3.1 - Page 527
Session 3.1 - Page 528
Understanding Cell References. - Page 529
Understanding Cell References. - Page 530
Using Relative References - Page 531
Using Absolute References - Page 532
Using Absolute References - Page 533
Using Absolute References - Page 534
Using Absolute References - Page 535
Using Mixed References - Page 536
Using Mixed References - Page 537
Working with Functions - Page 538
Working with Functions - Page 539
Working with Functions - Page 540
Working with Functions - Page 541
Inserting a Function - Page 542
Inserting a Function - Page 543
Inserting a Function - Page 544
Typing a Function - Page 545
Typing a Function - Page 546
Typing a Function - Page 547
Session 3.1 Quick Check - Page 548
Session 3.2 - Page 549
Session 3.2 - Page 550
Entering Data and Formulas with AutoFill - Page 551
Using the Fill Handle - Page 552
Using the Fill Handle - Page 553
Using the Auto Fill Options Button - Page 554
Using the Auto Fill Options Button - Page 555
Using the Auto Fill Options Button - Page 556
Using the Auto Fill Options Button - Page 557
Developing a Savings Plan - Page 558
Developing a Savings Plan - Page 559
Developing a Savings Plan - Page 560
Developing a Savings Plan - Page 561
Working with Logical Functions - Page 562
Working with Logical Functions - Page 563
Working with Logical Functions - Page 564
Working with Logical Functions - Page 565
Working with Date Functions - Page 566
Working with Financial Functions - Page 567
Working with Financial Functions - Page 568
Using the PMT Function - Page 569
Using the PMT Function - Page 570
Using the PMT Function - Page 571
Using the PMT Function - Page 572
Session 3.2 Quick Check - Page 573
Review Assignments - Page 574
Case Problems - Page 575
Case Problems - Page 576
Case Problems - Page 577
Case Problems - Page 578
Case Problems - Page 579
Tutorial 4 Enhancing a Workbook with Charts and Graphs Charting Financial Data - Page 580
Session 4.1 - Page 581
Session 4.1 - Page 582
Creating an Excel Chart - Page 583
Selecting a Data Source - Page 584
Selecting a Data Source - Page 585
Moving a Chart to a Different Worksheet - Page 586
Moving and Resizing Charts - Page 587
Designing a Pie Chart - Page 588
Choosing a Chart Layout - Page 589
Formatting the Chart Title - Page 590
Formatting the Chart Legend - Page 591
Formatting the Chart Legend - Page 592
Formatting Data Labels - Page 593
Changing Pie Slice Colors - Page 594
Creating a Column Chart - Page 595
Inserting a Column Chart - Page 596
Formatting a Column Chart Title and Legend - Page 597
Editing the Axis Scale and Text - Page 598
Editing the Axis Scale and Text - Page 599
Formatting the Chart Columns - Page 600
Formatting the Chart Columns - Page 601
Session 4.1 Quick Check - Page 602
Session 4.2 - Page 603
Session 4.2 - Page 604
Creating a Line Chart - Page 605
Formatting Date Labels - Page 606
Formatting Date Labels - Page 607
Formatting Date Labels - Page 608
Setting Label Units - Page 609
Overlaying a Chart Legend - Page 610
Overlaying a Chart Legend - Page 611
Adding Gridlines - Page 612
Editing and Revising Chart Data - Page 613
Adding a Data Series to an Existing Chart - Page 614
Adding a Data Series to an Existing Chart - Page 615
Creating a Combination Chart - Page 616
Creating a Combination Chart - Page 617
Creating a Combination Chart - Page 618
Creating a Combination Chart - Page 619
Creating a 3-D Chart - Page 620
Creating a 3-D Chart - Page 621
Adding Sparklines and Data Bars - Page 622
Adding Sparklines and Data Bars - Page 623
Adding Sparklines and Data Bars - Page 624
Adding and Formatting Sparkline Markers - Page 625
Adding and Formatting Sparkline Markers - Page 626
Creating Data Bars - Page 627
Modifying a Data Bar Rule - Page 628
Modifying a Data Bar Rule - Page 629
Creating a Chart Sheet - Page 630
Creating a Chart Sheet - Page 631
Creating a Chart Sheet - Page 632
Session 4.2 Quick Check - Page 633
Review Assignments - Page 634
Case Problems - Page 635
Case Problems - Page 636
Case Problems - Page 637
Case Problems - Page 638
Case Problems - Page 639
ProSkills Exercise: Decision Making - Page 640
ProSkills Exercise: Decision Making - Page 641
ProSkills Exercise: Decision Making - Page 642
ProSkills Exercise: Decision Making - Page 643
ACCESS LEVEL I TUTORIALS Tutorial 1 Creating a Database Creating a Database to Contain Customer, Contract, and Invoice Data - Page 644
Session 1.1 - Page 645
Session 1.1 - Page 646
Introduction to Database Concepts - Page 647
Introduction to Database Concepts - Page 648
Relational Database Management Systems - Page 649
Creating a Database - Page 650
Creating a Database - Page 651
Creating a Table in Datasheet View - Page 652
Renaming the Default Primary Key Field - Page 653
Changing the Data Type of the Default Primary Key Field - Page 654
Adding New Fields - Page 655
Adding New Fields - Page 656
Entering Records - Page 657
Entering Records - Page 658
Saving a Table - Page 659
Saving a Table - Page 660
Saving a Table - Page 661
Opening a Table - Page 662
Opening a Table - Page 663
Session 1.1 Quick Check - Page 664
Session 1.2 - Page 665
Session 1.2 - Page 666
Copying Records from Another Access Database - Page 667
Copying Records from Another Access Database - Page 668
Navigating a Datasheet - Page 669
Creating a Simple Query - Page 670
Creating a Simple Query - Page 671
Creating a Simple Query - Page 672
Creating a Simple Form - Page 673
Creating a Simple Form - Page 674
Creating a Simple Report - Page 675
Creating a Simple Report - Page 676
Creating a Simple Report - Page 677
Creating a Simple Report - Page 678
Creating a Simple Report - Page 679
Printing a Report - Page 680
Managing a Database - Page 681
Managing a Database - Page 682
Backing Up and Restoring a Database - Page 683
Session 1.2 Quick Check - Page 684
Review Assignments - Page 685
Case Problems - Page 686
Case Problems - Page 687
Case Problems - Page 688
Case Problems - Page 689
Case Problems - Page 690
Case Problems - Page 691
Tutorial 2 Building a Database and Defining Table Relationships Creating the Invoice and Customer Tables - Page 692
Session 2.1 - Page 693
Session 2.1 - Page 694
Guidelines for Designing Databases - Page 695
Guidelines for Designing Databases - Page 696
Guidelines for Setting Field Properties - Page 697
Setting Field Sizes - Page 698
Setting the Caption Property for Fields - Page 699
Changing the Format of a Field in Datasheet View - Page 700
Changing the Format of a Field in Datasheet View - Page 701
Creating a Table in Design View - Page 702
Defining Fields - Page 703
Defining Fields - Page 704
Defining Fields - Page 705
Defining Fields - Page 706
Defining Fields - Page 707
Defining Fields - Page 708
Specifying the Primary Key - Page 709
Saving the Table Structure - Page 710
Modifying the Structure of an Access Table - Page 711
Modifying the Structure of an Access Table - Page 712
Changing Field Properties - Page 713
Session 2.1 Quick Check - Page 714
Session 2.2 - Page 715
Session 2.2 - Page 716
Adding Records to a New Table - Page 717
Adding Records to a New Table - Page 718
Importing Data from an Excel Worksheet - Page 719
Importing Data from an Excel Worksheet - Page 720
Importing Data from an Excel Worksheet - Page 721
Creating a Table by Importing an Existing Table Structure - Page 722
Creating a Table by Importing an Existing Table Structure - Page 723
Creating a Table by Importing an Existing Table Structure - Page 724
Adding Fields to a Table Using the Data Type Gallery - Page 725
Modifying the Imported Table - Page 726
Modifying the Imported Table - Page 727
Renaming Fields in Design View - Page 728
Renaming Fields in Design View - Page 729
Renaming Fields in Design View - Page 730
Renaming Fields in Design View - Page 731
Adding Data to a Table by Importing a Text File - Page 732
Adding Data to a Table by Importing a Text File - Page 733
Defining Table Relationships - Page 734
One-to-Many Relationships - Page 735
Referential Integrity - Page 736
Referential Integrity - Page 737
Referential Integrity - Page 738
Referential Integrity - Page 739
Session 2.2 Quick Check - Page 740
Review Assignments - Page 741
Case Problems - Page 742
Case Problems - Page 743
Case Problems - Page 744
Case Problems - Page 745
Case Problems - Page 746
Case Problems - Page 747
Case Problems - Page 748
Case Problems - Page 749
Case Problems - Page 750
Case Problems - Page 751
Tutorial 3 Maintaining and Querying a Database Updating and Retrieving Information About Customers, Contracts, and Invoices - Page 752
Session 3.1 - Page 753
Session 3.1 - Page 754
Updating a Database - Page 755
Finding Data in a Table - Page 756
Deleting Records - Page 757
Deleting Records - Page 758
Introduction to Queries. - Page 759
Introduction to Queries. - Page 760
Creating and Running a Query - Page 761
Creating and Running a Query - Page 762
Updating Data Using a Query. - Page 763
Creating a Multitable Query - Page 764
Creating a Multitable Query - Page 765
Sorting Data in a Query - Page 766
Sorting Multiple Fields in Design View - Page 767
Sorting Multiple Fields in Design View - Page 768
Sorting Multiple Fields in Design View - Page 769
Filtering Data - Page 770
Filtering Data - Page 771
Session 3.1 Quick Check - Page 772
Session 3.2 - Page 773
Session 3.2 - Page 774
Defining Record Selection Criteria for Queries - Page 775
Defining Record Selection Criteria for Queries - Page 776
Modifying a Query - Page 777
Modifying a Query - Page 778
Modifying a Query - Page 779
Changing a Datasheet’s Appearance - Page 780
Changing a Datasheet’s Appearance - Page 781
Using a Comparison Operator to Match a Range of Values - Page 782
Using a Comparison Operator to Match a Range of Values - Page 783
Defining Multiple Selection Criteria for Queries - Page 784
The And Logical Operator - Page 785
The Or Logical Operator - Page 786
The Or Logical Operator - Page 787
Creating a Calculated Field - Page 788
Creating a Calculated Field - Page 789
Creating a Calculated Field - Page 790
Creating a Calculated Field - Page 791
Formatting a Calculated Field - Page 792
Formatting a Calculated Field - Page 793
Using Aggregate Functions - Page 794
Creating Queries with Aggregate Functions - Page 795
Creating Queries with Aggregate Functions - Page 796
Using Record Group Calculations - Page 797
Working with the Navigation Pane - Page 798
Working with the Navigation Pane - Page 799
Session 3.2 Quick Check - Page 800
Review Assignments - Page 801
Case Problems - Page 802
Case Problems - Page 803
Case Problems - Page 804
Case Problems - Page 805
Case Problems - Page 806
Case Problems - Page 807
Tutorial 4 Creating Forms and Reports Using Forms and Reports to Display Customer and Contract Data - Page 808
Session 4.1 - Page 809
Session 4.1 - Page 810
Creating a Form Using the Form Wizard - Page 811
Creating a Form Using the Form Wizard - Page 812
Modifying a Form’s Design in Layout View - Page 813
Applying a Theme to a Form - Page 814
Applying a Theme to a Form - Page 815
Applying a Theme to a Form - Page 816
Adding a Picture to a Form - Page 817
Changing the Color of the Form Title - Page 818
Changing the Type of Line on a Form - Page 819
Changing the Type of Line on a Form - Page 820
Navigating a Form - Page 821
Finding Data Using a Form - Page 822
Finding Data Using a Form - Page 823
Finding Data Using a Form - Page 824
Maintaining Table Data Using a Form - Page 825
Maintaining Table Data Using a Form - Page 826
Previewing and Printing Selected Form Records - Page 827
Session 4.1 Quick Check - Page 828
Session 4.2 - Page 829
Session 4.2 - Page 830
Creating a Form with a Main Form and a Subform - Page 831
Creating a Form with a Main Form and a Subform - Page 832
Creating a Form with a Main Form and a Subform - Page 833
Creating a Form with a Main Form and a Subform - Page 834
Creating a Report Using the Report Wizard - Page 835
Creating a Report Using the Report Wizard - Page 836
Creating a Report Using the Report Wizard - Page 837
Creating a Report Using the Report Wizard - Page 838
Creating a Report Using the Report Wizard - Page 839
Modifying a Report’s Design in Layout View - Page 840
Modifying a Report’s Design in Layout View - Page 841
Changing the Title Font Color and Inserting a Picture in a Report - Page 842
Changing the Title Font Color and Inserting a Picture in a Report - Page 843
Using Conditional Formatting in a Report - Page 844
Using Conditional Formatting in a Report - Page 845
Using Conditional Formatting in a Report - Page 846
Session 4.2 Quick Check - Page 847
Review Assignments - Page 848
Case Problems - Page 849
Case Problems - Page 850
Case Problems - Page 851
Case Problems - Page 852
Case Problems - Page 853
Case Problems - Page 854
Case Problems - Page 855
Proskils Exercise: Teamwork - Page 856
Proskils Exercise: Teamwork - Page 857
Proskils Exercise: Teamwork - Page 858
Proskils Exercise: Teamwork - Page 859
POWERPOINT LEVEL I TUTORIALS Tutorial 1 Creating a Presentation Presenting Information About a Recreational Timeshare Company - Page 860
Session 1.1 - Page 861
Session 1.1 - Page 862
Creating a New Presentation - Page 863
Planning a Presentation - Page 864
Planning a Presentation - Page 865
Adding a New Slide and Choosing a Layout - Page 866
Adding a New Slide and Choosing a Layout - Page 867
Creating a Bulleted List - Page 868
Creating a Bulleted List - Page 869
Creating a Bulleted List - Page 870
Using Themes - Page 871
Using Themes - Page 872
Opening an Existing Presentation - Page 873
Opening an Existing Presentation - Page 874
Editing Text in the Slide Pane - Page 875
Undoing Actions - Page 876
Undoing Actions - Page 877
Undoing Actions - Page 878
Using AutoCorrect - Page 879
Editing Text in the Outline Tab - Page 880
Editing Text in the Outline Tab - Page 881
Editing Text in the Outline Tab - Page 882
Editing Text in the Outline Tab - Page 883
Rearranging Slides - Page 884
Rearranging Slides - Page 885
Deleting Slides - Page 886
Running a Slide Show - Page 887
Running a Slide Show - Page 888
Running a Slide Show - Page 889
Session 1.1 Quick Check - Page 890
Session 1.2 - Page 891
Session 1.2 - Page 892
Creating a Presentation Based on an Existing Presentation - Page 893
Animating Text - Page 894
Animating Slide Titles and Bulleted Lists - Page 895
Animating Slide Titles and Bulleted Lists - Page 896
Modifying the Start Timing of an Animation - Page 897
Modifying the Start Timing of an Animation - Page 898
Adding Transitions - Page 899
Adding Transitions - Page 900
Inserting Footers, Slide Numbers, and the Date - Page 901
Inserting Footers, Slide Numbers, and the Date - Page 902
Using Speaker Notes - Page 903
Checking the Spelling in a Presentation - Page 904
Checking the Spelling in a Presentation - Page 905
Checking the Spelling in a Presentation - Page 906
Checking the Spelling in a Presentation - Page 907
Checking the Spelling in a Presentation - Page 908
Previewing and Printing a Presentation - Page 909
Previewing and Printing a Presentation - Page 910
Previewing and Printing a Presentation - Page 911
Previewing and Printing a Presentation - Page 912
Session 1.2 Quick Check - Page 913
Review Assignments - Page 914
Case Problems - Page 915
Case Problems - Page 916
Case Problems - Page 917
Case Problems - Page 918
Case Problems - Page 919
Case Problems - Page 920
Case Problems - Page 921
Tutorial 2 Adding and Modifying Text and Graphic Objects: Preparing a Presentation About a Travel Company - Page 922
Session 2.1 - Page 923
Session 2.1 - Page 924
Understanding Graphics - Page 925
Adding a Graphic from a File - Page 926
Inserting Clip Art - Page 927
Inserting Clip Art - Page 928
Inserting Clip Art - Page 929
Resizing and Repositioning a Graphic - Page 930
Resizing and Repositioning a Graphic - Page 931
Formatting Objects - Page 932
Modifying a Graphic’s Border Color, Effects, and Shape - Page 933
Applying a Style to a Graphic - Page 934
Drawing and Formatting Shapes - Page 935
Drawing and Formatting Shapes - Page 936
Drawing and Formatting Shapes - Page 937
Adding Text to a Shape - Page 938
Flipping and Rotating Objects - Page 939
Flipping and Rotating Objects - Page 940
Flipping and Rotating Objects - Page 941
Session 2.1 Quick Check - Page 942
Session 2.2 - Page 943
Session 2.2 - Page 944
Modifying the Slide Master. - Page 945
Modifying Text Placeholders - Page 946
Modifying Text Placeholders - Page 947
Modifying Text Placeholders - Page 948
Modifying the Font Style in the Slide Master - Page 949
Modifying the Font Style in the Slide Master - Page 950
Creating SmartArt Diagrams - Page 951
Creating SmartArt Diagrams - Page 952
Creating SmartArt Diagrams - Page 953
Creating SmartArt Diagrams - Page 954
Converting a Bulleted List into a SmartArt Diagram - Page 955
Modifying a SmartArt Diagram - Page 956
Modifying a SmartArt Diagram - Page 957
Modifying a SmartArt Diagram - Page 958
Animating Objects - Page 959
Customizing the Direction of an Animation - Page 960
Inserting Headers and Footers on Handouts and Notes Pages - Page 961
Inserting Headers and Footers on Handouts and Notes Pages - Page 962
Broadcasting a Presentation - Page 963
Broadcasting a Presentation - Page 964
Broadcasting a Presentation - Page 965
Broadcasting a Presentation - Page 966
Broadcasting a Presentation - Page 967
Session 2.2 Quick Check - Page 968
Review Assignments - Page 969
Case Problems - Page 970
Case Problems - Page 971
Case Problems - Page 972
Case Problems - Page 973
Case Problems - Page 974
Case Problems - Page 975
Case Problems - Page 976
ProSkills Exercise: Verbal Communication - Page 977
ProSkills Exercise: Verbal Communication - Page 978
ProSkills Exercise: Verbal Communication - Page 979
INTEGRATING WORD, EXCEL, ACCESS, AND POWERPOINT Creating Documents for a Home Care Company - Page 980
Session 1 - Page 981
Session 1 - Page 982
Object Linking and Embedding - Page 983
Object Linking and Embedding - Page 984
Embedding an Excel Chart in a Word Document - Page 985
Embedding an Excel Chart in a Word Document - Page 986
Embedding an Excel Chart in a Word Document - Page 987
Modifying an Embedded Object - Page 988
Modifying an Embedded Object - Page 989
Modifying an Embedded Object - Page 990
Linking Excel Worksheet Data to Word - Page 991
Linking Excel Worksheet Data to Word - Page 992
Linking Excel Worksheet Data to Word - Page 993
Updating Linked Objects - Page 994
Updating Linked Objects - Page 995
Updating Linked Objects - Page 996
Updating Linked Objects - Page 997
Session 1 Quick Check - Page 998
Session 2 - Page 999
Session 2 - Page 1000
Using Excel Data in Access - Page 1001
Importing an Excel List into an Access Table - Page 1002
Importing an Excel List into an Access Table - Page 1003
Importing an Excel List into an Access Table - Page 1004
Importing an Excel List into an Access Table - Page 1005
Using Access Data in a Word Document - Page 1006
Using Access Data in a Word Document - Page 1007
Exporting Query Results from Access to Word - Page 1008
Exporting Query Results from Access to Word - Page 1009
Exporting Query Results from Access to Word - Page 1010
Exporting Query Results from Access to Word - Page 1011
Exporting Query Results from Access to Word - Page 1012
Exporting Query Results from Access to Word - Page 1013
Session 2 Quick Check - Page 1014
Session 3 - Page 1015
Session 3 - Page 1016
Creating a Word Outline - Page 1017
Creating PowerPoint Slides from a Word Outline - Page 1018
Creating PowerPoint Slides from a Word Outline - Page 1019
Copying and Pasting Access Query Results into a PowerPoint Presentation - Page 1020
Copying and Pasting Access Query Results into a PowerPoint Presentation - Page 1021
Linking an Excel Chart to a PowerPoint Presentation - Page 1022
Linking an Excel Chart to a PowerPoint Presentation - Page 1023
Linking an Excel Chart to a PowerPoint Presentation - Page 1024
Session 3 Quick Check - Page 1025
Review Assignments - Page 1026
Review Assignments - Page 1027
Review Assignments - Page 1028
Case Problems - Page 1029
Case Problems - Page 1030
Case Problems - Page 1031
Case Problems - Page 1032
ProSkills Exercise: Verbal Communication - Page 1033
ProSkills Exercise: Verbal Communication - Page 1034
ProSkills Exercise: Verbal Communication - Page 1035
APPENDIX A INTRODUCTION TO SKYDRIVE AND OFFICE WEB APPS Sharing Files and Collaborating with Others Online - Page 1036
Exploring Windows Live - Page 1037
Uploading Files to SkyDrive - Page 1038
Uploading Files to SkyDrive - Page 1039
Uploading Files to SkyDrive - Page 1040
Uploading Files to SkyDrive - Page 1041
Using Office Web Apps - Page 1042
Using Office Web Apps - Page 1043
Using Office Web Apps - Page 1044
Using Office Web Apps - Page 1045
Creating Folders and Organizing Files on SkyDrive - Page 1046
Giving Permission for Access to a Folder on Your SkyDrive - Page 1047
Giving Permission for Access to a Folder on Your SkyDrive - Page 1048
Co-Authoring with the Excel Web App - Page 1049
Co-Authoring with the Excel Web App - Page 1050
Proskills Teamwork: Working with Others - Page 1051