GO! with Microsoft Office 2007 Introductory

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois   University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.   Robert L. Ferret recently retired as the director of the Center for Instructional Computing at Eastern Michigan University, where he provided computer training and support to faculty.  He has authored or co-authored more than 70 books on Access, PowerPoint, Excel, Publisher, WordPerfect, and Word.  Before writing the GO! Series, Bob was a series editor and author for the Learn Series.  He has a bachelor’s degree in psychology, a master’s degree in geography, and a master’s degree in interdisciplinary technology from Eastern Michigan University.  Bob’s doctoral studies were in instructional technology at Wayne State University.  For fun, Bob teaches a four-week computers and genealogy class and has written genealogy and local history books.   Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College.  She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.   Suzanne Marks is a faculty member in Business Technology Systems at Bellevue Community College, Bellevue, Washington.  She holds a bachelor’s degree in business education from Washington State University, and was project manager for the first IT Skills Standards in the United States.

Windows XP

Chapter 1 Getting Started with Windows XP

    PROJECT 1A Start Windows XP and Work with Windows, Folders, and Files

        Objective 1 Get Started with Windows XP

            Activity 1.1 Getting Started with Windows XP

        Objective 2 Resize, Move, and Scroll Windows

            Activity 1.2 Resizing, Moving, and Scrolling Windows

        Objective 3 Maximize, Restore, Minimize, and Close Windows

            Activity 1.3 Maximizing, Restoring, Minimizing, and Closing a Window

        Objective 4 Create a New Folder

            Activity 1.4 Creating a New Folder

        Objective 5 Copy, Move, Rename, and Delete Files

            Activity 1.5 Copying Files and Folders

            Activity 1.6 Moving, Renaming, and Deleting Files

            Activity 1.7 Capturing an Image of a Screen

        Objective 6 Find Files and Folders

            Activity 1.8 Finding Files and Folders

        Objective 7 Compress Files

            Activity 1.9 Compressing Files

        Outlook 2007

 

Chapter 2 Getting Started with Outlook 2007

 

    PROJECT 2A Read and Respond to E-mail Using Outlook 2007

        Objective 1 Start and Navigate Outlook

            Activity 2.1 Starting Outlook

            Activity 2.2 Exploring Outlook Using the Navigation Pane and Folder List

            Activity 2.3 Using Menus, Toolbars, and ScreenTips

        Objective 2 Read and Respond to E-mail

            Activity 2.4 Importing Messages into the Inbox

            Activity 2.5 Opening, Navigating, and Closing an E-mail Message

            Activity 2.6 Configuring Outlook and Replying to a Message

            Activity 2.7 Printing the Inbox and a Message

        Objective 3 Delete Outlook Information and Close Outlook

            Activity 2.8 Deleting Outlook Messages

            Activity 2.9 Resetting Outlook Defaults and Closing Outlook

 

    PROJECT 2B Manage Personal Information Using Outlook 2007

        Objective 4 Store Contact Information

            Activity 2.10 Creating Contacts

            Activity 2.11 Editing Contacts and Printing the Contacts List

        Objective 5 Manage Tasks

            Activity 2.12 Creating and Printing a To-Do List

        Objective 6 Work with the Calendar

            Activity 2.13 Exploring the Calendar

            Activity 2.14 Scheduling Appointments and Tasks

            Activity 2.15 Printing a Calendar

 

Internet Explorer

Chapter 3 Getting Started with Internet Explorer 7.0

 

    PROJECT 3A Use Internet Explorer 7.0 to Navigate and Search the Internet, Create and Manage Your Favorite Internet Sites, and Save and Print Web Pages

        Objective 1 Start Internet Explorer 7.0 and Identify Screen Elements

            Activity 3.1 Starting Internet Explorer

        Objective 2 Navigate the Internet

            Activity 3.2 Performing Commands Using the Toolbar

            Activity 3.3 Accessing Web Sites from the Address Bar

            Activity 3.4 Opening a Second Web Site

            Activity 3.5 Displaying Web Pages with Hyperlinks

            Activity 3.6 Using Internet Explorer History

        Objective 3 Create and Manage Favorites

            Activity 3.7 Adding an Address to the Favorites List

            Activity 3.8 Displaying a Favorite Web Site

            Activity 3.9 Deleting a Web Address from Favorites

        Objective 4 Search the Internet

            Activity 3.10 Adding a Search Engine and Searching the Internet

        Objective 5 Save and Print Web Pages

            Activity 3.11 Downloading and Saving a Web Page

            Activity 3.12 Downloading and Saving Graphics from a Web Page

            Activity 3.13 Printing Web Pages

            Activity 3.14 Printing Web Graphics

            Activity 3.15 Printing Selected Text from Web Pages

 

Chapter 4 Basic Computer Concepts

 

        Objective 1 Define Computer and Identify the Four Basic Computing Functions

        Objective 2 Identify the Different Types of Computers

            Microcomputers

            Servers

            Mainframe Computers

            Supercomputers

            Embedded Computers

        Objective 3 Describe Hardware Devices and Their Uses

            System Unit

            Storage Devices

            Evaluating Your System

            Ports

            Input Devices

            Output Devices

        Objective 4 Identify Types of Software and Their Uses

             System Software

            Application Software

        Objective 5 Describe Networks and Define Network Terms

        Objective 6 Identify Safe Computing Practices

            Computer Maintenance

            Viruses

            Spyware

            Protecting Yourself and Your Computer

 

Word 2007

Chapter 5 Creating Documents with Microsoft Word 2007

 



    PROJECT 5A Create, Edit, Save, and Print a Document

        Objective 1 Create and Save a New Document

            Activity 5.1 Starting Word and Identifying Parts of the Word Window

            Activity 5.2 Beginning a New Document and Displaying Formatting Marks

            Activity 5.3 Entering Text and Inserting Blank Lines

            Activity 5.4 Creating Folders for Document Storage and Saving a Document

        Objective 2 Edit Text

            Activity 5.5 Editing Text with the Delete and Backspace Keys

            Activity 5.6 Inserting New Text

        Objective 3 Select, Delete, and Format Text

            Activity 5.7 Selecting and Deleting Text

            Activity 5.8 Changing Font and Font Size

            Activity 5.9 Adding Emphasis to Text

    Objective 4 Print a Document

            Activity 5.10 Accessing Headers and Footers

            Activity 5.11 Printing a Document

 

    PROJECT 5B Navigate the Word Window and Check Your Work

        Objective 5 Navigate the Word Window

            Activity 5.12 Opening and Closing an Existing Document

            Activity 5.13 Inserting Existing Text into a New Document

            Activity 5.14 Navigating a Document

            Activity 5.15 Changing Document Views

            Activity 5.16 Using the Zoom Slider

            Activity 5.17 Splitting Windows and Arranging Panes

    Objective 6 Add a Graphic to a Document

            Activity 5.18 Inserting Clip Art

    Objective 7 Use the Spelling and Grammar Checker

            Activity 5.19 Checking Individual Spelling and Grammar Errors

            Activity 5.20 Checking Spelling and Grammar in an Entire Document

    Objective 8 Preview and Print Documents, Close a Document, and Close Word

            Activity 5.21 Previewing and Printing a Document

            Activity 5.22 Closing a Document and Closing Word

    Objective 9 Use the Microsoft Help System

            Activity 5.23 Getting Help

 

Chapter 6 Formatting and Organizing Text

 

    PROJECT 6A Format Text and Use Lists

        Objective 1 Change Document and Paragraph Layout

            Activity 6.1 Setting Margins

            Activity 6.2 Aligning Text

            Activity 6.3 Changing Line Spacing

            Activity 6.4 Adding Space After Paragraphs

            Activity 6.5 Using the Format Painter

        Objective 2 Change and Reorganize Text

            Activity 6.6 Finding and Replacing Text

            Activity 6.7 Cutting, Copying, and Pasting Text

            Activity 6.8 Moving Text to a New Location

            Activity 6.9 Undoing and Redoing Changes

            Activity 6.10 Inserting a Nonbreaking Spaces and Hyphens

            Activity 6.11 Entering a Line Break

        Objective 3 Create and Modify Lists

            Activity 6.12 Creating a Bulleted List

            Activity 6.13 Using AutoFormat to Create a Numbered List

            Activity 6.14 Formatting Lists

            Activity 6.15 Customizing Bullets

 

    PROJECT 6B Create a Research Paper

        Objective 4 Insert and Format Headers and Footers

            Activity 6.16 Inserting and Formatting Page Numbers

            Activity 6.17 Inserting the Current Date and Time

        Objective 5 Insert Frequently Used Text

            Activity 6.18 Recording AutoCorrect Entries

            Activity 6.19 Inserting Symbols

        Objective 6 Insert and Format References

            Activity 6.20 Inserting Footnotes

            Activity 6.21 Modifying a Footnote Style

            Activity 6.22 Adding Citations

            Activity 6.23 Creating a Reference Page

            Activity 6.24 Managing Document Properties

 

Chapter 7 Using Graphics and Tables

 

    PROJECT 7A Insert and Modify Graphics and Set Tab Stops

        Objective 1 Insert and Format Graphics

            Activity 7.1 Formatting Text Using WordArt

            Activity 7.2 Inserting Pictures from Files

            Activity 7.3 Resizing a Graphic

            Activity 7.4 Wrapping Text Around a Graphic

            Activity 7.5 Moving a Graphic

            Activity 7.6 Applying Picture Styles

            Activity 7.7 Adding a Page Border

        Objective 2 Set Tab Stops

            Activity 7.8 Setting Tab Stops and Using Click and Type

            Activity 7.9 Formatting and Removing Tab Stops

            Activity 7.10 Using Tab Stops to Enter Text

            Activity 7.11 Moving Tab Stops

        Objective 3 Insert and Modify Text Boxes and Shapes

            Activity 7.12 Inserting a Text Box

            Activity 7.13 Moving, Resizing, and Formatting a Text Box

            Activity 7.14 Inserting a Predefined Shape

 

    PROJECT 7B Create and Format a Table

        Objective 4 Create a Table

            Activity 7.15 Creating and Entering Text into a Table

            Activity 7.16 Adding a Row to a Table

            Activity 7.17 Changing the Width of a Table Column

            Activity 7.18 Adding a Column to a Table

            Activity 7.19 Converting Text to Tables

        Objective 5 Format a Table

            Activity 7.20 Formatting Text in Cells and Shading Cells

            Activity 7.21 Changing the Table Border

            Activity 7.22 Centering a Table

            Activity 7.23 Merging Cells

            Activity 7.24 Applying a Predefined Format to a Table

 

Chapter 8 Special Document Formats, Columns, and Mail Merge

 

    PROJECT 8A Create a Multicolumn Newsletter and Print Mailing Labels

        Objective 1 Collect and Paste Text and Graphics

            Activity 8.1 Using Collect and Paste to Gather Images and Text

            Activity 8.2 Pasting Information from the Clipboard Task Pane

        Objective 2 Create and Format Columns

            Activity 8.3 Changing One Column Text to Two Columns

            Activity 8.4 Formatting Multiple Columns

            Activity 8.5 Inserting a Column Break

            Activity 8.6 Adding Graphics to Columns

        Objective 3 Use Special Character and Paragraph Formatting

            Activity 8.7 Using Small Caps and Changing Font Color

            Activity 8.8 Adding a Border and Shading to a Paragraph

        Objective 4 Create Mailing Labels Using Mail Merge

            Activity 8.9 Opening the Mail Merge Wizard Template

            Activity 8.10 Completing the Mail Merge Wizard

            Activity 8.11 Previewing and Printing the Mail Merge Document

 

    PROJECT 8B Create and Preview a Web Page

        Objective 5 Insert Hyperlinks

            Activity 8.12 Inserting Text Hyperlinks

            Activity 8.13 Adding a Hyperlink to a Graphic

            Activity 8.14 Testing and Modifying Hyperlinks

        Objective 6 Insert a SmartArt Graphic

            Activity 8.15 Inserting a SmartArt Graphic

            Activity 8.16 Adding Text to a SmartArt Graphic

        Objective 7 Preview and Save a Document as a Web Page

            Activity 8.17 Previewing a Document as a Web Page

            Activity 8.18 Saving a Document as a Web Page

 

Excel 2007

Chapter 9 Creating a Worksheet and Charting Data

 

    PROJECT 9A Create a Worksheet and Chart Data

        Objective 1 Create, Save, and Navigate an Excel Workbook

            Activity 9.1 Starting Excel and Naming and Saving a Workbook

            Activity 9.2 Navigating a Worksheet and a Workbook

            Activity 9.3 Selecting Parts of a Worksheet

        Objective 2 Enter and Edit Data in a Worksheet

            Activity 9.4 Entering Text, Using AutoComplete, Filling a Series with Auto Fill, and Using Spelling Checker and Undo to Correct Typing Errors

            Activity 9.5 Aligning Text and Adjusting the Size of Columns and Rows

            Activity 9.6 Entering Numbers

            Activity 9.7 Inserting and Deleting Rows and Columns, and Using the Insert Options Button

        Objective 3 Construct and Copy Formulas, Use the Sum Function, and Edit Cells

            Activity 9.8 Constructing a Formula, Using the Sum Function, and Editing Numbers in Cells

            Activity 9.9 Copying a Formula by Using the Fill Handle

        Objective 4 Format Data, Cells, and Worksheets

            Activity 9.10 Formatting Financial Numbers, Using Column AutoFit, and Using Format Painter

            Activity 9.11 Formatting Text and Using Merge and Center

        Objective 5 Close and Reopen a Workbook

            Activity 9.12 Closing and Reopening an Existing Workbook

        Objective 6 Chart Data

            Activity 9.13 Charting Data

        Objective 7 Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel

            Activity 9.14 Changing Views, Creating a Footer, and Using Print Preview

            Activity 9.15 Deleting Unused Sheets in a Workbook

            Activity 9.16 Printing a Worksheet

            Activity 9.17 Displaying, Printing, and Hiding Formulas

 

PROJECT 9B Perform Calculations and Make Comparisons by Using a Pie Chart

        Objective 8 Design a Worksheet

            Activity 9.18 Setting Column Widths and Creating Row and Column Titles

            Activity 9.19 Entering Data by Range

        Objective 9 Construct Formulas for Mathematical Operations

            Activity 9.20 Using Arithmetic Operators

            Activity 9.21 Copying Formulas Containing Absolute Cell References

        Objective 10 Format Percentages and Move Formulas

            Activity 9.22 Formatting Cells with the Percent Style Button

            Activity 9.23 Inserting Rows in a Worksheet Containing Formulas and Wrapping Text in a Cell Objective 11 Create a Pie Chart and a Chart Sheet

            Activity 9.24 Creating a Pie Chart and a Chart Sheet

        Objective 12 Use the Excel Help System

            Activity 9.25 Using the Excel Help System

 

Chapter 10 Managing Workbooks and Analyzing Data

 

    PROJECT 10A Create a Summary Sheet from Multiple Worksheets

        Objective 1 Create and Save a Workbook from an Existing Workbook

            Activity 10.1 Creating and Saving a Workbook from an Existing Workbook

        Objective 2 Navigate a Workbook and Rename Worksheets

            Activity 10.2 Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of a Worksheet

        Objective 3 Enter Dates, Clear Contents, and Clear Formats

            Activity 10.3 Entering and Formatting Dates

            Activity 10.4 Clearing Cell Contents and Formats

        Objective 4 Move, Copy, and Paste Cell Contents

            Activity 10.5 Copying, Pasting, and Moving Cell Contents

        Objective 5 Edit and Format Multiple Worksheets at the Same Time

            Activity 10.6 Wrapping Text in a Cell in Several Worksheets at the Same Time

            Activity 10.7 Entering Data and Constructing Formulas on Multiple Worksheets

        Objective 6 Create a Summary Sheet

            Activity 10.8 Constructing Formulas that Refer to Cells in Another Worksheet

        Objective 7 Format and Print Multiple Worksheets in a Workbook

            Activity 10.9 Moving and Formatting Worksheets in a Workbook

            Activity 10.10 Printing All the Worksheets in a Workbook

 

PROJECT 10B Make Projections Using What-If Analysis

        Objective 8 Design a Worksheet for What-If Analysis

            Activity 10.11 Using Parentheses in a Formula

            Activity 10.12 Formatting as You Type

            Activity 10.13 Calculating a Value After an Increase

        Objective 9 Perform What-If Analysis

            Activity 10.14 Performing What-If Analysis and Using Paste Special

        Objective 10 Compare Data with a Line Chart

            Activity 10.15 Creating a Line Chart

 

Chapter 11 Using Functions and Tables

 

    PROJECT 11A Track Inventory by Using Math, Logical, and Statistical Functions and by Creating an Excel Table

        Objective 1 Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

            Activity 11.1 Using the SUM, AVERAGE, and MEDIAN Functions

            Activity 11.2 Using the MIN and MAX Functions

            Activity 11.3 Moving Data, Adding Borders, and Rotating Text

        Objective 2 Use COUNTIF and IF Functions, and Apply Conditional Formatting

            Activity 11.4 Using the COUNTIF Function

            Activity 11.5 Using the IF Function and Applying Conditional Formatting

            Activity 11.6 Applying Conditional Formatting Using Custom Formats and Data Bars

            Activity 11.7 Using Find and Replace

        Objective 3 Use a Date Function

            Activity 11.8 Using the NOW Function

        Objective 4 Freeze Panes and Create an Excel Table

            Activity 11.9 Freezing and Unfreezing Panes

            Activity 11.10 Sorting and Filtering in an Excel Table

            Activity 11.11 Inserting a Second Table in a Worksheet

            Activity 11.12 Converting a Table to a Range of Data

        Objective 5 Format and Print a Large Worksheet

            Activity 11.13 Printing Large Worksheets

 

    PROJECT 11B Make Financial Decisions by Using Financial Functions and What-If Analysis

        Objective 6 Use Financial Functions

            Activity 11.14 Designing a Loan Worksheet

            Activity 11.15 Inserting the PMT Financial Function

        Objective 7 Use Goal Seek

            Activity 11.16 Using Goal Seek to Produce the Desired Result

            Activity 11.17 Using Goal Seek to Find an Increased Period

        Objective 8 Create a Data Table

            Activity 11.18 Designing a Two-Variable Data Table

            Activity 11.19 Using a Data Table to Calculate Options

 

Access 2007

Chapter 12 Getting Started with Access Databases and Tables

 

    PROJECT 12A Create a New Blank Database

        Objective 1 Start Access and Create a New Blank Database

            Activity 12.1 Starting Access, Creating and Naming a Folder, and Creating a Database from a New Blank Database

        Objective 2 Add Records to a Table

            Activity 12.2 Adding Records to a Table

        Objective 3 Rename Table Fields in Datasheet View

            Activity 12.3 Renaming the Fields In a Table in Datasheet View

            Activity 12.4 Changing the Data Type of a Field in Datasheet View

        Objective 4 Modify the Design of a Table

            Activity 12.5 Deleting a Field in Design View

            Activity 12.6 Modifying a Field Size and Description in Design View

            Activity 12.7 Setting a Primary Key and Saving a Table

        Objective 5 Add a Second Table to a Database

            Activity 12.8 Adding a Second Table to a Database

            Activity 12.9 Adding Records to a Second Table

        Objective 6 Print a Table

            Activity 12.10 Adjusting Column Widths and Printing a Table

        Objective 7 Create and Use a Query

            Activity 12.11 Using the Simple Query Wizard to Create a Query

        Objective 8 Create and Use a Form

            Activity 12.12 Creating a Form

        Objective 9 Create and Print a Report

            Activity 12.13 Creating and Printing a Report

        Objective 10 Close and Save a Database

            Activity 12.14 Closing and Saving a Database

 

    PROJECT 12B Create a Database from a Template

        Objective 11 Create a Database Using a Template

            Activity 12.15 Creating a New Database Using a Template

            Activity 12.16 Building a Table by Entering Records in a Multiple Items Form

        Objective 12 Organize Database Objects in the Navigation Pane

            Activity 12.17 Organizing Database Objects in the Navigation Pane

        Objective 13 Create a New Table in a Database Created with a Template

            Activity 12.18 Creating a New Table and Changing Its Design

        Objective 14 View a Report and Print a Table in a Database Created with a Template

            Activity 12.19 Viewing a Report

            Activity 12.20 Printing a Table

        Objective 15 Use the Access Help System

            Activity 12.21 Using the Access Help System

 

Chapter 13 Sort and Query a Database

 

    PROJECT 13A Sort and Query a Database

        Objective 1 Open an Existing Database

            Activity 13.1 Renaming and Opening an Existing Database

            Activity 13.2 Opening an Existing Database and Resolving Security Alerts

        Objective 2 Create Table Relationships

            Activity 13.3 Creating Table Relationships and Enforcing Referential Integrity

            Activity 13.4 Printing a Relationship Report

        Objective 3 Sort Records in a Table

            Activity 13.5 Sorting Records in a Table in Ascending or Descending Order

            Activity 13.6 Sorting Records in a Table on Multiple Fields

        Objective 4 Create a Query in Design View

            Activity 13.7 Creating a New Select Query in Design View

            Activity 13.8 Running, Saving, Printing, and Closing a Query

        Objective 5 Create a New Query from an Existing Query

            Activity 13.9 Creating a New Query From an Existing Query

        Objective 6 Sort Query Results

            Activity 13.10 Sorting Query Results

        Objective 7 Specify Criteria in a Query

            Activity 13.11 Specifying Text Criteria in a Query

            Activity 13.12 Specifying Criteria Using a Field Not Displayed in the Query Result

            Activity 13.13 Using Is Null Criteria to Find Empty Fields

 

    PROJECT 13B Create a Database Table from an Excel Spreadsheet and Create Complex Queries

        Objective 8 Create a New Table by Importing an Excel Spreadsheet

            Activity 13.14 Opening an Existing Database and Preparing to Import an Excel Spreadsheet

            Activity 13.15 Creating a New Table by Importing an Excel Spreadsheet

        Objective 9 Specify Numeric Criteria in a Query

            Activity 13.16 Specifying Numeric Criteria in a Query

            Activity 13.17 Using Comparison Operators

            Activity 13.18 Using the Between. . . And Comparison Operator

        Objective 10 Use Compound Criteria

            Activity 13.19 Using AND Criteria in a Query

            Activity 13.20 Using OR Criteria in a Query

        Objective 11 Create a Query Based on More Than One Table

            Activity 13.21 Creating a Query Based on More Than One Table

        Objective 12 Use Wildcards in a Query

            Activity 13.22 Using a Wildcard in a Query

        Objective 13 Use Calculated Fields in a Query

            Activity 13.23 Using Calculated Fields in a Query

        Objective 14 Group Data and Calculate Statistics in a Query

            Activity 13.24 Using the MIN, MAX, AVG and SUM Functions in a Query

            Activity 13.25 Grouping Data in a Query

 

Chapter 14 Forms, Filters, and Reports

 

    PROJECT 14A Create Forms to Enter and Display Data in a Database

        Objective 1 Create a Form

            Activity 14.1 Creating a Form

        Objective 2 Use a Form to Add and Delete Records

            Activity 14.2 Adding Records to a Table by Using a Form

            Activity 14.3 Deleting Records from a Table by Using a Form

            Activity 14.4 Printing a Form

        Objective 3 Create a Form by Using the Form Wizard

            Activity 14.5 Creating a Form Using the Form Wizard

        Objective 4 Modify a Form in Design View and in Layout View

            Activity 14.6 Modifying a Form in Design View

            Activity 14.7 Adding, Resizing, and Moving Controls in Layout View

            Activity 14.8 Formatting and Aligning Controls in Layout View

        Objective 5 Filter Records

            Activity 14.9 Filtering Data by Selection on One Field

            Activity 14.10 Using Filter by Form

 

    PROJECT 14B Create Reports to Display Database Information

        Objective 6 Create a Report by Using the Report Tool

            Activity 14.11 Creating and Modifying a Report by Using the Report Tool and Layout View

        Objective 7 Create a Report by Using the Blank Report Tool

            Activity 14.12 Creating a Report by Using the Blank Report Tool

        Objective 8 Create a Report by Using the Report Wizard

            Activity 14.13 Creating a Report by Using the Report Wizard

        Objective 9 Modify the Design of a Report

            Activity 14.14 Modifying a Report in Layout View

            Activity 14.15 Modifying a Report in Design View

        Objective 10 Print a Report and Keep Data Together

            Activity 14.16 Keeping Data Together and Printing a Report

 

PowerPoint 2007

Chapter 15 Getting Started with Microsoft PowerPoint 2007

 

    PROJECT 15A Open, Edit, Save, and Print a Presentation

        Objective 1 Open, View, and Save a Presentation

            Activity 15.1 Starting PowerPoint and Identifying Parts of the PowerPoint Window

            Activity 15.2 Opening a Presentation

            Activity 15.3 Viewing a Slide Show

            Activity 15.4 Creating Folders and Saving a Presentation

        Objective 2 Edit a Presentation

            Activity 15.5 Editing Slide Text

            Activity 15.6 Inserting a New Slide

            Activity 15.7 Increasing and Decreasing List Levels

            Activity 15.8 Checking Spelling

            Activity 15.9 Editing Text by Using the Thesaurus

            Activity 15.10 Adding Speaker’s Notes to a Presentation

        Objective 3 Format a Presentation

            Activity 15.11 Changing Font and Font Size

            Activity 15.12 Applying Font Styles

            Activity 15.13 Aligning Text and Changing Line Spacing

            Activity 15.14 Modifying Slide Layout

            Activity 15.15 Changing the Presentation Theme

        Objective 4 Create Headers and Footers and Print a Presentation

            Activity 15.16 Creating Headers and Footers

            Activity 15.17 Previewing and Printing a Presentation and Closing PowerPoint

 

    PROJECT 15B Create and Format a Presentation

        Objective 5 Create a New Presentation

            Activity 15.18 Starting a New Presentation

            Activity 15.19 Inserting Slides from an Existing Presentation

        Objective 6 Use Slide Sorter View

            Activity 15.20 Selecting and Deleting Slides

            Activity 15.21 Moving Slides

        Objective 7 Add Pictures to a Presentation

            Activity 15.22 Inserting Clip Art

            Activity 15.23 Moving and Sizing Images

            Activity 15.24 Applying a Style to a Picture

        Objective 8 Use the Microsoft Help System

            Activity 15.25 Accessing PowerPoint Help

 

 

 

Chapter 16 Designing a PowerPoint Presentation

 

    PROJECT 16A Format a Presentation

        Objective 1 Format Slide Elements

            Activity 16.1 Selecting Placeholder Text and Using the Repeat Key

            Activity 16.2 Changing a Bulleted List to a Numbered List

            Activity 16.3 Modifying the Bulleted List Style

            Activity 16.4 Applying WordArt Styles to Text

            Activity 16.5 Using Format Painter

        Objective 2 Insert and Format Pictures and Shapes

            Activity 16.6 Inserting a Picture Using a Content Layout

            Activity 16.7 Changing the Size and Shape of a Picture

            Activity 16.8 Inserting and Positioning a Text Box

            Activity 16.9 Inserting, Sizing, and Positioning Shapes

            Activity 16.10 Adding Text to Shapes

            Activity 16.11 Applying Shape and Picture Styles

            Activity 16.12 Duplicating and Aligning Objects

        Objective 3 Apply Slide Transitions

            Activity 16.13 Applying Slide Transitions to a Presentation

 

    PROJECT 16B Enhance a Presentation with SmartArt Graphics

        Objective 4 Reorganize Presentation Text and Clear Formats

            Activity 16.14 Moving and Copying Text

            Activity 16.15 Copying Multiple Selections by Using the Office Clipboard

            Activity 16.16 Undoing and Redoing Changes

            Activity 16.17 Clearing Formatting from a Selection

        Objective 5 Create and Format a SmartArt Graphic

            Activity 16.18 Creating a SmartArt Diagram by Using a Content Layout

            Activity 16.19 Adding and Removing Shapes in a Diagram

            Activity 16.20 Changing the Diagram Type and Size

            Activity 16.21 Creating a SmartArt Diagram from Bullet Points

            Activity 16.22 Changing the Color and Style of a Diagram

 

Chapter 17 Enhancing a Presentation with Animation, Tables, and Charts

 

    PROJECT 17A Customize a Presentation

        Objective 1 Customize Slide Backgrounds and Themes

            Activity 17.1 Applying a Background Style

            Activity 17.2 Hiding Background Graphics

            Activity 17.3 Formatting a Slide Background with a Picture

            Activity 17.4 Applying a Background Fill Color and Resetting a Slide Background

            Activity 17.5 Modifying Font Themes

        Objective 2 Animate a Slide Show

            Activity 17.6 Applying Entrance Effects

            Activity 17.7 Setting Effect and Timing Options

            Activity 17.8 Applying Animation to a SmartArt Graphic

 

    PROJECT 17B Present Data with Tables and Charts

        Objective 3 Create and Modify Tables

            Activity 17.9 Creating a Table

            Activity 17.10 Modifying the Layout of a Table

            Activity 17.11 Modifying a Table Design

        Objective 4 Create and Modify Charts

            Activity 17.12 Creating a Column Chart and Applying a Chart Style

            Activity 17.13 Deleting Chart Data and Changing the Chart Type

            Activity 17.14 Animating a Chart

 

Integrated Projects

Chapter 18 Using Access Data with Other Office Programs

 

    PROJECT 18A Use Access Data with Other Office Programs

        Objective 1 Export Access Data to Excel

            Activity 18.1 Exporting Access Data to Excel

        Objective 2 Create a Formula in Excel

            Activity 18.2 Creating a Formula for Calculation in Excel

        Objective 3 Create a Chart in Excel

            Activity 18.3 Creating a Chart in Excel

        Objective 4 Copy Access Data into a Word Document

            Activity 18.4 Copying Access Data to a Word Document

        Objective 5 Copy Excel Data into a Word Document

            Activity 18.5 Copying Excel Data to a Word Document

        Objective 6 Insert an Excel Chart into a PowerPoint Presentation

            Activity 18.6 Adding an Excel Chart to a PowerPoint Presentation

 

Chapter 19 Using Tables in Word and Excel

 

    PROJECT 19A Use Tables in Word and Excel

        Objective 1 Plan a Table in Word

            Activity 19.1 Starting Word and Planning the Table

        Objective 2 Enter Data and Format a Table in Word

            Activity 19.2 Entering Data

            Activity 19.3 Formatting a Table

        Objective 3 Create a Table in Word from Excel Data

            Activity 19.4 Creating a Table in Word from Excel Data

        Objective 4 Create an Excel Worksheet from a Word Table

            Activity 19.5 Creating an Excel Worksheet from a Word Table

 

Chapter 20 Using Excel as a Data Source in a Mail Merge

 

    PROJECT 20A Use Excel as a Data Source in a Mail Merge

        Objective 1 Prepare a Mail Merge Document for Mailing Labels

            Activity 20.1 Setting up Mailing Labels Using the Mailings Tab

        Objective 2 Choose an Excel Worksheet as a Data Source

            Activity 20.2 Selecting the Data Source for the Mailing Labels

        Objective 3 Produce and Save Merged Mailing Labels

            Activity 20.3 Adding Merge Fields to the Mailing Labels

            Activity 20.4 Producing the Mailing Labels

        Objective 4 Open a Saved Main Document for Mail Merge

            Activity 20.5 Opening a Main Document for Mail Merge

 

Chapter 21 Linking Data in Office Documents

 

    PROJECT 21A Link Data in Office Documents

        Objective 1 Insert and Link an Excel Object in Word

            Activity 21.1 Inserting and Linking an Excel Object

        Objective 2 Revise a Linked Excel Worksheet and Update Links in Word

            Activity 21.2 Revising a Linked Worksheet and Updating Links in a Document

        Objective 3 Open a Word Document that Includes a Linked Object and Update Links

            Activity 21.3 Opening a Word Document That Includes a Linked Object

            Activity 21.4 Updating a Linked Object

 

Chapter 22 Creating Presentation Content from Office Documents

 PROJECT 22A Create Presentation Content from Office Documents

        Objective 1 Insert a Word Outline into PowerPoint

            Activity 22.1 Inserting a Word Outline into PowerPoint

        Objective 2 Import Excel Data into a PowerPoint Chart

            Activity 22.2 Importing Excel Data into a Chart in PowerPoint

        Objective 3 Insert a Hyperlink into a PowerPoint Slide

            Activity 22.3 Inserting a Hyperlink into a PowerPoint Slide