New Perspectives on Microsoft Office 2010, First Course

Cover Page
......Page 1
Copyright Page
......Page 4
Title Page
......Page 7
Preface
......Page 8
BRIEF CONTENTS
......Page 13
TABLE OF CONTENTS
......Page 15
ESSENTIAL COMPUTER CONCEPTS Learning About the Components of Computer Systems
......Page 28
Types of Computers
......Page 31
Computer Systems
......Page 33
Data Representation
......Page 34
Motherboard
......Page 35
Memory
......Page 36
Storage Media
......Page 38
Input Devices
......Page 42
Output Devices
......Page 44
Data Bus
......Page 46
Networks
......Page 48
The Internet
......Page 49
Security Threats on Your Computer
......Page 50
System Software
......Page 53
Application Software
......Page 54
Computing in the Cloud
......Page 59
Putting It All Together
......Page 60
Proskills: Decision Making
......Page 65
EXPLORING THE BASICS OF MICROSOFT WINDOWS 7 Investigating the Windows 7 Operating System
......Page 68
Session 1
......Page 69
Starting Windows 7.
......Page 71
Interacting with the Desktop
......Page 72
Exploring the Start Menu
......Page 76
Running Multiple Programs
......Page 79
Switching Between Programs
......Page 80
Closing Programs from the Taskbar
......Page 81
Using Windows and Dialog Boxes
......Page 82
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
Navigating with the Computer Window
......Page 91
Changing the View
......Page 93
Navigating with Windows Explorer
......Page 94
Getting Help
......Page 96
Viewing Windows Basics Topics
......Page 97
Searching the Help Pages
......Page 98
Turning Off Windows 7
......Page 99
Session 2 Quick Check
......Page 100
Practice: Review Assignments
......Page 101
Apply: Case Problem 1
......Page 102
Proskills: Problem Solving
......Page 106
Apply: Case Problem 2
......Page 103
Challenge: Case Problem 3
......Page 104
Assess: SAM: Skills Assessment Manager
......Page 105
MANAGING YOUR FILES Organizing Files and Folders with Windows 7
......Page 108
Understanding the Need for 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
Navigating to Your Data Files
......Page 116
Creating Folders
......Page 118
Moving and Copying Files and Folders
......Page 119
Naming and Renaming Files
......Page 122
Working with Compressed Files
......Page 124
Quick Check
......Page 126
Case Problems.
......Page 127
ProSkills Exercise: Decision Making
......Page 130
BROWSER AND EMAIL BASICS Introduction to Microsoft Internet Explorer and Microsoft Windows Live Mail
......Page 132
Starting Microsoft Internet Explorer
......Page 135
Using a Search Engine
......Page 136
Tabbed Browsing
......Page 137
Using the History List
......Page 139
Using the Favorites List
......Page 140
Saving Web Slices
......Page 141
Printing and Saving a Web Page
......Page 142
Session 1 Quick Check
......Page 144
Addressing Email
......Page 147
Sending and Receiving Email Using Windows Live Mail
......Page 148
Replying to 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
Managing Your Schedule with Windows Live Calendar
......Page 155
Session 2 Quick Check
......Page 156
Review Assignments
......Page 157
Case Problems
......Page 158
ProSkills Exercise: Written Communication
......Page 162
GETTING STARTED WITH MICROSOFT OFFICE 2010 Preparing a Meeting Agenda
......Page 164
Exploring Microsoft Office 2010
......Page 167
Starting Office Programs
......Page 168
Switching Between Open Programs and Files
......Page 170
Resizing the Program Window and Workspace
......Page 171
Zooming and Scrolling
......Page 172
Using the Ribbon
......Page 174
Clicking Buttons
......Page 175
Opening Dialog Boxes and Task Panes
......Page 177
Accessing the Mini Toolbar
......Page 179
Opening Shortcut Menus
......Page 180
Working with Files
......Page 181
Saving a File
......Page 182
Opening a File
......Page 185
Sharing Files Using Windows Live SkyDrive
......Page 187
Viewing ScreenTips
......Page 188
Using the Help Window
......Page 189
Printing a File
......Page 191
Quick Check
......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
Starting Word
......Page 199
Creating a Block Style Business Letter
......Page 200
Inserting a Date with AutoComplete
......Page 201
Entering the Inside Address
......Page 202
Using the Undo and Redo Buttons
......Page 205
Correcting Errors as You Type
......Page 206
Adjusting Paragraph and Line Spacing
......Page 210
Adjusting the Margins
......Page 214
Previewing and Printing a Document
......Page 216
Opening a Blank Document and Creating an Envelope
......Page 218
Session 1.1 Quick Check
......Page 220
Session 1.2
......Page 221
Opening an Existing Document
......Page 223
Changing Page Orientation
......Page 225
Changing the Font and Font Size
......Page 226
Applying Text Effects, Font Colors, and Font Styles
......Page 228
Aligning Text
......Page 231
Adding a Paragraph Border and Shading
......Page 233
Inserting, Deleting and Resizing a Photo
......Page 235
Session 1.2 Quick Check
......Page 238
Review Assignments
......Page 239
Case Problems
......Page 241
Tutorial 2 Editing and Formatting a Document Editing an Academic Document According to MLA Style
......Page 248
Session 2.1
......Page 249
Revising a Document
......Page 251
Creating Bulleted and Numbered Lists
......Page 253
Moving Text in a Document
......Page 255
Dragging and Dropping Text
......Page 256
Cutting or Copying and Pasting Text using the Clipboard
......Page 257
Finding and Replacing Text
......Page 262
Using the Spelling and Grammar Checker
......Page 266
Working with Styles
......Page 268
Working with Heading Levels
......Page 270
Working with Themes
......Page 271
Session 2.1 Quick Check
......Page 274
Session 2.2
......Page 275
Reviewing the MLA Style
......Page 277
Indenting a Paragraph
......Page 278
Inserting and Modifying Page Numbers
......Page 281
Creating Citations and a Bibliography
......Page 283
Creating Citations
......Page 284
Generating a Bibliography
......Page 290
Modifying an Existing Source
......Page 292
Finalizing an MLA Works Cited List
......Page 293
Session 2.2 Quick Check
......Page 295
Review Assignments
......Page 296
Case Problems
......Page 298
Tutorial 3 Creating a Multiple-Page Report Writing a Recommendation
......Page 304
Session 3.1
......Page 305
Working with Headings in the Navigation Pane
......Page 307
Inserting a Blank Table
......Page 311
Entering Data in a Table
......Page 313
Selecting Part of a Table
......Page 315
Sorting Rows in a Table
......Page 316
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
Session 3.1 Quick Check
......Page 324
Session 3.2
......Page 325
Setting Tab Stops
......Page 327
Creating Footnotes and Endnotes
......Page 330
Formatting a Document in Sections
......Page 333
Creating SmartArt
......Page 335
Adding Headers and Footers
......Page 339
Inserting a Cover Page
......Page 345
Session 3.2 Quick Check
......Page 348
Review Assignments
......Page 349
Case Problems......Page 350
Tutorial 4 Desktop Publishing and Mail Merge Creating a Newsletter and Cover Letter
......Page 356
Session 4.1
......Page 357
Formatting Text in Columns
......Page 359
Inserting Drop Caps
......Page 361
Inserting Symbols and Special Characters
......Page 362
Using WordArt to Create a Headline
......Page 364
Wrapping Text Around a Graphic
......Page 366
Moving WordArt
......Page 368
Applying WordArt Styles
......Page 370
Inserting Clip Art
......Page 18
Cropping a Graphic
......Page 375
Moving and Aligning a Graphic
......Page 379
Session 4.1 Quick Check
......Page 380
Session 4.2
......Page 381
Rotating a Photo
......Page 383
Removing a Photo’s Background
......Page 385
Applying a Picture Style
......Page 388
Balancing Columns
......Page 390
Inserting a Border Around a Page......Page 391
Performing a Simple Mail Merge
......Page 393
Selecting a Data Source
......Page 395
Inserting Merge Fields
......Page 396
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
ProSkills Exercise: Written Communication
......Page 409
EXCEL LEVEL I TUTORIALS Tutorial 1 Getting Started with Excel Creating an Order Report
......Page 412
Session 1.1
......Page 413
Understanding Spreadsheets
......Page 415
Navigating Between Worksheets
......Page 416
Navigating Within a Worksheet
......Page 417
Planning a Workbook
......Page 419
Entering Text
......Page 420
Entering Multiple Lines of Text Within a Cell
......Page 422
Entering Dates
......Page 423
Entering Numbers
......Page 424
Setting Column Widths
......Page 426
Setting Row Heights
......Page 428
Inserting a Column or Row
......Page 429
Deleting and Clearing a Row or Column
......Page 431
Session 1.1 Quick Check
......Page 432
Session 1.2
......Page 433
Selecting a Range
......Page 435
Moving and Copying a Range
......Page 437
Inserting and Deleting a Range
......Page 439
Entering a Formula
......Page 441
Copying and Pasting Formulas
......Page 444
Entering a Function
......Page 445
Entering Functions with the AutoSum Feature
......Page 446
Inserting or Deleting a Worksheet
......Page 448
Editing Worksheet Content
......Page 449
Using Find and Replace
......Page 451
Using the Spelling Checker
......Page 452
Changing Worksheet Views
......Page 454
Working with Portrait and Landscape Orientation
......Page 455
Printing the Workbook
......Page 456
Viewing and Printing Worksheet Formulas
......Page 457
Session 1.2 Quick Check
......Page 459
Review Assignments
......Page 460
Case Problems
......Page 461
Tutorial 2 Formatting a Workbook Designing a Financial Report
......Page 468
Session 2.1
......Page 469
Formatting Cell Text
......Page 471
Applying Fonts and Font Styles
......Page 472
Applying a Font Color
......Page 473
Formatting Text Selections
......Page 474
Applying a Fill Color......Page 475
Adding a Background Image
......Page 476
Creating Formulas to Add, Subtract, and Divide Values
......Page 477
Applying Number Formats
......Page 479
Formatting Dates and Times
......Page 482
Aligning Cell Content
......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
Copying Formats with the Format Painter
......Page 490
Copying Formats with the Paste Options Button
......Page 491
Session 2.1 Quick Check
......Page 492
Session 2.2
......Page 493
Applying Cell Styles
......Page 495
Working with Themes
......Page 497
Creating Formulas to Calculate Totals
......Page 499
Creating Formulas to Subtract Values
......Page 500
Working with Table Styles
......Page 502
Selecting Table Style Options
......Page 504
Highlighting Cells with Conditional Formats
......Page 506
Formatting the Worksheet for Printing
......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
Session 2.2 Quick Check
......Page 518
Review Assignments
......Page 519
Case Problems.
......Page 520
Tutorial 3 Working with Formulas and Functions Developing a Family Budget
......Page 526
Session 3.1
......Page 527
Understanding Cell References.
......Page 529
Using Relative References
......Page 531
Using Absolute References
......Page 532
Using Mixed References
......Page 536
Understanding Function Syntax
......Page 538
Inserting a Function
......Page 542
Typing a Function
......Page 545
Session 3.1 Quick Check
......Page 548
Session 3.2
......Page 549
Entering Data and Formulas with AutoFill
......Page 551
Using the Fill Handle
......Page 552
Filling a Series
......Page 554
Developing a Savings Plan
......Page 558
Using the IF Function
......Page 562
Working with Date Functions
......Page 566
Working with Financial Functions
......Page 567
Using the PMT Function
......Page 569
Session 3.2 Quick Check
......Page 573
Review Assignments
......Page 574
Case Problems
......Page 575
Tutorial 4 Enhancing a Workbook with Charts and Graphs Charting Financial Data
......Page 580
Session 4.1
......Page 581
Creating an Excel Chart
......Page 583
Selecting a Chart Type
......Page 584
Moving a Chart to a Different Worksheet
......Page 586
Moving and Resizing Charts
......Page 587
Choosing a Chart Style
......Page 588
Choosing a Chart Layout
......Page 589
Formatting the Chart Title
......Page 590
Formatting the Chart Legend
......Page 591
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
Formatting the Chart Columns
......Page 600
Session 4.1 Quick Check
......Page 602
Session 4.2
......Page 603
Creating a Line Chart
......Page 605
Formatting Date Labels
......Page 606
Setting Label Units
......Page 609
Overlaying a Chart Legend
......Page 610
Adding an Axis Title
......Page 612
Changing a Data Value
......Page 613
Adding a Data Series to an Existing Chart
......Page 614
Creating a Combination Chart
......Page 616
Creating a 3-D Chart
......Page 620
Creating Sparklines
......Page 622
Adding and Formatting Sparkline Markers
......Page 625
Creating Data Bars
......Page 627
Modifying a Data Bar Rule
......Page 628
Creating a Chart Sheet
......Page 630
Session 4.2 Quick Check
......Page 633
Review Assignments
......Page 634
Case Problems
......Page 635
ProSkills Exercise: Decision Making
......Page 640
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
Databases and Relationships
......Page 647
Relational Database Management Systems
......Page 649
Creating a Database
......Page 650
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
Entering Records
......Page 657
Saving a Table
......Page 659
Opening a Table
......Page 662
Session 1.1 Quick Check
......Page 664
Session 1.2
......Page 665
Copying Records from Another Access Database
......Page 667
Navigating a Datasheet
......Page 669
Creating a Simple Query
......Page 670
Creating a Simple Form
......Page 673
Creating a Simple Report
......Page 675
Viewing Objects in the Navigation Pane
......Page 680
Compacting and Repairing a Database
......Page 681
Backing Up and Restoring a Database
......Page 683
Session 1.2 Quick Check
......Page 684
Review Assignments
......Page 685
Case Problems
......Page 686
Tutorial 2 Building a Database and Defining Table Relationships Creating the Invoice and Customer Tables
......Page 692
Session 2.1
......Page 693
Guidelines for Designing Databases
......Page 695
Assigning Field Data Types
......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
Creating a Table in Design View
......Page 702
Defining Fields
......Page 703
Specifying the Primary Key
......Page 709
Saving the Table Structure
......Page 710
Adding a Field
......Page 711
Changing Field Properties
......Page 713
Session 2.1 Quick Check
......Page 714
Session 2.2
......Page 715
Adding Records to a New Table
......Page 717
Importing Data from an Excel Worksheet
......Page 719
Creating a Table by Importing an Existing Table Structure
......Page 722
Adding Fields to a Table Using the Data Type Gallery
......Page 725
Deleting Fields from a Table Structure
......Page 726
Changing the Data Type for a Field in Design View
......Page 728
Adding Data to a Table by Importing a Text File
......Page 732
Defining Table Relationships
......Page 734
One-to-Many Relationships
......Page 735
Defining a Relationship Between Two Tables
......Page 736
Session 2.2 Quick Check
......Page 740
Review Assignments
......Page 741
Case Problems
......Page 742
Tutorial 3 Maintaining and Querying a Database Updating and Retrieving Information About Customers, Contracts, and Invoices
......Page 752
Session 3.1
......Page 753
Modifying Records
......Page 755
Finding Data in a Table
......Page 756
Deleting Records
......Page 757
Introduction to Queries.
......Page 759
Creating and Running a Query
......Page 761
Updating Data Using a Query.
......Page 763
Creating a Multitable Query
......Page 764
Using an AutoFilter to Sort Data
......Page 766
Sorting Multiple Fields in Design View
......Page 767
Filtering Data
......Page 770
Session 3.1 Quick Check
......Page 772
Session 3.2
......Page 773
Specifying an Exact Match
......Page 775
Modifying a Query
......Page 777
Changing the Alternate Row Color in a Datasheet
......Page 780
Using a Comparison Operator to Match a Range of Values
......Page 782
Defining Multiple Selection Criteria for Queries
......Page 784
The And Logical Operator
......Page 785
The Or Logical Operator
......Page 786
Creating a Calculated Field
......Page 788
Formatting a Calculated Field
......Page 792
Working with Aggregate Functions Using the Total Row
......Page 794
Creating Queries with Aggregate Functions
......Page 795
Using Record Group Calculations
......Page 797
Working with the Navigation Pane
......Page 798
Session 3.2 Quick Check
......Page 800
Review Assignments
......Page 801
Case Problems
......Page 802
Tutorial 4 Creating Forms and Reports Using Forms and Reports to Display Customer and Contract Data
......Page 808
Session 4.1
......Page 809
Creating a Form Using the Form Wizard
......Page 811
Modifying a Form’s Design in Layout View
......Page 813
Applying a Theme to a Form
......Page 814
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
Navigating a Form
......Page 821
Finding Data Using a Form
......Page 822
Maintaining Table Data Using a Form
......Page 825
Previewing and Printing Selected Form Records
......Page 827
Session 4.1 Quick Check
......Page 828
Session 4.2
......Page 829
Creating a Form with a Main Form and a Subform
......Page 831
Creating a Report Using the Report Wizard
......Page 835
Resizing a Field on a Report in Layout View
......Page 840
Changing the Title Font Color and Inserting a Picture in a Report
......Page 842
Using Conditional Formatting in a Report
......Page 844
Session 4.2 Quick Check
......Page 847
Review Assignments
......Page 848
Case Problems
......Page 849
Proskils Exercise: Teamwork
......Page 856
POWERPOINT LEVEL I TUTORIALS Tutorial 1 Creating a Presentation Presenting Information About a Recreational Timeshare Company
......Page 860
Session 1.1
......Page 861
Creating a New Presentation
......Page 863
Creating a Title Slide
......Page 864
Adding a New Slide and Choosing a Layout
......Page 866
Creating a Bulleted List
......Page 868
Using Themes
......Page 871
Selecting and Formatting Text
......Page 873
Editing Text in the Slide Pane
......Page 875
Undoing Actions
......Page 876
Using AutoCorrect
......Page 879
Editing Text in the Outline Tab
......Page 880
Rearranging Slides
......Page 884
Deleting Slides
......Page 886
Running a Slide Show
......Page 887
Session 1.1 Quick Check
......Page 890
Session 1.2
......Page 891
Creating a Presentation Based on an Existing Presentation
......Page 893
Animating Text
......Page 894
Animating Slide Titles and Bulleted Lists
......Page 895
Modifying the Start Timing of an Animation
......Page 897
Adding Transitions
......Page 899
Inserting Footers, Slide Numbers, and the Date
......Page 901
Using Speaker Notes
......Page 903
Checking the Spelling in a Presentation
......Page 904
Previewing and Printing a Presentation
......Page 909
Session 1.2 Quick Check
......Page 913
Review Assignments
......Page 914
Case Problems
......Page 915
Tutorial 2 Adding and Modifying Text and Graphic Objects: Preparing a Presentation About a Travel Company
......Page 922
Session 2.1
......Page 923
Understanding Graphics
......Page 925
Adding a Graphic from a File
......Page 926
Inserting Clip Art
......Page 927
Resizing and Repositioning a Graphic
......Page 930
Adjusting the Color of a Picture
......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
Inserting and Formatting Text Boxes
......Page 938
Flipping and Rotating Objects
......Page 939
Session 2.1 Quick Check
......Page 942
Session 2.2
......Page 943
Modifying the Slide Master.
......Page 945
Modifying Text Placeholders
......Page 946
Modifying the Font Style in the Slide Master
......Page 949
Creating a SmartArt Diagram
......Page 951
Converting a Bulleted List into a SmartArt Diagram
......Page 955
Modifying a SmartArt Diagram
......Page 956
Changing the Sequence of an Animation
......Page 959
Customizing the Direction of an Animation
......Page 960
Inserting Headers and Footers on Handouts and Notes Pages
......Page 961
Broadcasting a Presentation
......Page 963
Session 2.2 Quick Check
......Page 968
Review Assignments
......Page 969
Case Problems
......Page 970
ProSkills Exercise: Verbal Communication
......Page 977
INTEGRATING WORD, EXCEL,  ACCESS, AND POWERPOINT Creating Documents for a Home Care Company......Page 980
Session 1
......Page 981
Object Linking and Embedding
......Page 983
Embedding an Excel Chart in a Word Document
......Page 985
Modifying an Embedded Object
......Page 988
Linking Excel Worksheet Data to Word
......Page 991
Updating Linked Objects
......Page 994
Session 1 Quick Check
......Page 998
Session 2
......Page 999
Preparing an Excel List for Import
......Page 1001
Importing an Excel List into an Access Table
......Page 1002
Querying Data in an Access Database
......Page 1006
Exporting Query Results from Access to Word
......Page 1008
Session 2 Quick Check
......Page 1014
Session 3
......Page 1015
Creating a Word Outline
......Page 1017
Creating PowerPoint Slides from a Word Outline
......Page 1018
Copying and Pasting Access Query Results into a PowerPoint Presentation
......Page 1020
Linking an Excel Chart to a PowerPoint Presentation
......Page 1022
Session 3 Quick Check
......Page 1025
Review Assignments
......Page 1026
Case Problems
......Page 1029
ProSkills Exercise: Verbal Communication
......Page 1033
APPENDIX A INTRODUCTION TO SKYDRIVE AND OFFICE WEB APPS Sharing Files and Collaborating with Others Online
......Page 1036
Obtaining a Windows Live ID
......Page 1037
Uploading Files to SkyDrive
......Page 1038
Using Office Web Apps
......Page 1042
Creating Folders and Organizing Files on SkyDrive
......Page 1046
Giving Permission for Access to a Folder on Your SkyDrive
......Page 1047
Co-Authoring with the Excel Web App
......Page 1049
Proskills Teamwork: Working with Others
......Page 1051
GLOSSARY/INDEX
......Page 1052
TASK REFERENCE
......Page 1077