9780619206574

New Perspectives on Microsoft Office 2003

by
  • ISBN13:

    9780619206574

  • ISBN10:

    0619206578

  • Format: Paperback
  • Copyright: 2004-02-02
  • Publisher: Cengage Learning
  • View Upgraded Edition

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $195.95 Save up to $48.99
  • Buy Used
    $146.96
    Add to Cart Free Shipping

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Summary

A case-based approach to learning all the essentials and new features of Microsoft Office 2003. Includes improved readability and reference features, plus integration tutorials.

Table of Contents

Preface v
Windows WIN 1
Read This Before You Begin
WIN 2
Exploring the Basics of Microsoft Windows XP
WIN 3
Investigating the Windows XP Operating System
WIN 3
Session 1
WIN 4
Starting Windows XP
WIN 4
Touring the Windows XP Desktop
WIN 6
Interacting with the Desktop
WIN 6
Exploring the Start Menu
WIN 10
Running Multiple Programs
WIN 12
Switching Between Programs
WIN 13
Closing Programs from the Taskbar
WIN 14
Using Windows and Dialog Boxes
WIN 14
Manipulating Windows
WIN 16
Selecting Options from a Menu
WIN 18
Using Toolbars
WIN 20
Using List Boxes and Scroll Bars
WIN 21
Working with Dialog Boxes
WIN 22
Session 1 Quick Check
WIN 23
Session 2
WIN 24
Exploring Your Computer
WIN 24
Navigating with My Computer
WIN 24
Changing the View
WIN 27
Navigating with Windows Explorer
WIN 29
Getting Help
WIN 31
Viewing Topics on the Windows XP Help and Support Center Home Page
WIN 32
Selecting a Topic from the Index
WIN 32
Searching the Help Pages
WIN 33
Shutting Down Windows XP
WIN 34
Session 2 Quick Check
WIN 35
Tutorial Summary
WIN 35
Key Terms
WIN 36
Review Assignments
WIN 36
Case Problems
WIN 37
SAM Assessment and Training
WIN 40
Lab Assignments
WIN 40
Quick Check Answers
WIN 40
File Management FM 1
Read This Before You Begin
FM 2
Managing Your Files
FM 3
Creating and Working with Files and Folders in Windows XP
FM 3
Organizing Files and Folders
FM 4
Understanding the Need for Organizing Files and Folders
FM 5
Developing Strategies for Organizing Files and Folders
FM 6
Planning Your Organization
FM 7
Exploring Files and Folders
FM 7
Using Windows Explorer
FM 9
Navigating to Your Data Files
FM 10
Working with Folders and Files
FM 12
Creating Folders
FM 12
Moving and Copying Files and Folders
FM 14
Naming and Renaming Files
FM 16
Deleting Files and Folders
FM 17
Working with Compressed Files
FM 18
Quick Check
FM 20
Tutorial Summary
FM 21
Key Terms
FM 21
Review Assignments
FM 21
Case Problems
FM 22
SAM Assessment and Training
FM 24
Lab Assignments
FM 24
Quick Check Answers
FM 24
Office OFF 1
Read This Before You Begin
OFF 2
Using Common Features of Microsoft Office 2003
OFF 3
Preparing Promotional Materials
OFF 3
Exploring Microsoft Office 2003
OFF 4
Integrating Office Programs
OFF 5
Starting Office Programs
OFF 5
Switching Between Open Programs and Files
OFF 8
Exploring Common Window Elements
OFF 9
Using the Window Sizing Buttons
OFF 9
Using Menus and Toolbars
OFF 11
Viewing Personalized Menus and Toolbars
OFF 11
Using Task Panes
OFF 14
Opening and Closing Task Panes
OFF 14
Navigating Among Task Panes
OFF 15
Using the Research Task Pane
OFF 16
Working with Files
OFF 18
Creating a File
OFF 19
Saving a File
OFF 19
Closing a File
OFF 21
Opening a File
OFF 22
Getting Help
OFF 23
Using ScreenTips
OFF 23
Using the Type a Question for Help Box
OFF 23
Using the Help Task Pane
OFF 25
Using Microsoft Office Online
OFF 27
Printing a File
OFF 29
Exiting Programs
OFF 30
Quick Check
OFF 31
Tutorial Summary
OFF 31
Key Terms
OFF 31
Review Assignments
OFF 31
SAM Assessment and Training
OFF 32
Quick Check Answers
OFF 32
Word
Read This Before You Begin
WD 2
Tutorial I
WD 3
Creating a Document
WD 3
Writing a Business Letter
WD 3
Session 1.1
WD 4
Four Steps to a Professional Document
WD 4
Exploring the Word Window
WD 5
Setting Up the Window Before You Begin Each Tutorial
WD 6
Setting the Document View to Normal
WD 6
Displaying the Toolbars, Task Pane, and Ruler
WD 7
Setting Up Other Screen Elements
WD 8
Displaying Nonprinting Characters
WD 9
Beginning a Letter WD 10
Entering Text
WD 13
Session 1.1 Quick Check
WD 16
Session 1.2
WD 16
Continuing Work on the Letter
WD 16
Scrolling a Document
WD 17
Correcting Errors
WD 20
Working with AutoCorrect
WD 21
Correcting Spelling and Grammar Errors
WD 22
Proofreading the Letter
WD 23
Inserting a Date with AutoComplete
WD 24
Moving the Insertion Point Around a Document
WD 26
Using the Undo and Redo Commands
WD 27
Removing Smart Tags
WD 28
Previewing and Printing a Document
WD 29
Creating an Envelope
WD 30
Session 1.2 Quick Check WD 32
Tutorial Summary
WD 32
Key Terms
WD 32
Review Assignments
WD 33
Case Problems
WD 34
Internet Assignments
WD 39
SAM Assessment and Training
WD 39
Lab Assignments
WD 39
Quick Check Answers
WD 39
Tutorial 2
WD 41
Editing and Formatting a Document
WD 41
Preparing an FAQ Document
WD 41
Session 2.1
WD 42
Reviewing the Document
WD 42
Using the Spelling and Grammar Checker
WD 46
Selecting Parts of a Document
WD 49
Deleting Text
WD 50
Moving Text within a Document
WD 51
Dragging and Dropping Text
WD 51
Cutting or Copying and Pasting Text
WD 54
Finding and Replacing Text
WD 58
Session 2.1 Quick Check
WD 60
Session 2.2
WD 60
Changing Margins and Page Orientation
WD 60
Changing Line Spacing
WD 62
Aligning Text
WD 64
Indenting a Paragraph
WD 65
Using the Format Painter
WD 66
Adding Bullets and Numbers
WD 68
Changing the Font and Font Size
WD 70
Emphasizing Text Using Bold, Underline, and Italic Styles
WD 72
Bolding Text
WD 72
Underlining Text
WD 73
Italicizing Text
WD 73
Previewing Formatted Text
WD 74
Adding Comments
WD 75
Using the Research Task Pane
WD 76
Session 2.2 Quick Check
WD 78
Tutorial Summary
WD 79
Key Terms
WD 79
Review Assignments
WD 79
Case Problems
WD 81
Internet Assignments
WD 87
SAM Assessment and Training
WD 87
Quick Check Answers
WD 88
Previewing the Merged Document
WD 170
Merging the Main Document and Data Source
WD 171
Session 4.2 Quick Check
WD 173
Tutorial Summary
WD 173
Key Terms
WD 173
Review Assignments
WD 174
Case Problems
WD 175
Internet Assignments
WD 182
SAM Assessment and Training
WD 183
Quick Check Answers
WD 183
Excel
Read This Before You Begin
EX 2
Tutorial 1
EX 3
Using Excel to Manage Data
EX 3
Creating a Sales Order Report
EX 3
Session 1.1
EX 4
Introducing Excel
EX 4
Understanding Spreadsheets
EX 4
Parts of the Excel Window
EX 5
Navigating a Worksheet
EX 7
Navigating Between Worksheets
EX 9
Developing a Worksheet
EX 9
Entering Data into a Worksheet
EX 11
Entering Text
EX 11
Entering Several Lines of Text Within a Cell
EX 12
Entering Dates
EX13
Entering Values
EX 14
Entering Formulas
EX 14
Using AutoComplete
EX 17
Changing the Size of a Column or Row
EX 19
Session 1.1 Quick Check
EX 23
Session 1.2
EX 23
Working with Ranges
EX 23
Selecting Ranges
EX 24
Other Selection Techniques
EX 25
Moving a Selection of Cells
EX 26
Calculating Sums with AutoSum
EX 28
Working with Rows and Columns
EX 30
Inserting a Row or Column
EX 30
Deleting a Row or Column
EX 32
Editing Your Worksheet
EX 33
Undoing an Action
EX 34
Working with Worksheets
EX 35
Adding and Removing Worksheets
EX 35
Renaming a Worksheet
EX 36
Moving a Worksheet
EX 37
Using the Spell Checker
EX 37
Previewing and Printing a Worksheet
EX 38
Working with Portrait and Landscape Orientation
EX 40
Printing the Worksheet Formulas
EX 41
Session 1.2 Quick Check
EX 43
Tutorial Summary
EX 43
Key Terms
EX 44
Review Assignments
EX 44
Case Problems
EX 46
Internet Assignments
EX 49
SAM Assessment and Training
EX 50
Lab Assignments
EX 50
Quick Check Answers
EX 50
Tutorial 2
EX 51
Working with Formulas and Functions
EX 51
Developing a Family Budget
EX 51
Session 2.1
EX 52
Working with Excel Functions
EX 52
Copying and Pasting Formulas
EX 56
Using Relative and Absolute References
EX 58
Working with Other Paste Options
EX 61
Changing the Magnification of a Worksheet
EX 62
Using the Insert Function Dialog Box
EX 65
Filling in Formulas and Series
EX 68
Auto Fill Options
EX 70
Filling a Series
EX 70
Working with Date Functions
EX 72
Session 2.1 Quick Check
EX 73
Session 2.2 (Optional)
EX 74
Working with Financial Functions
EX 74
Using the PMT Function
EX 77
Working with Logical Functions
EX 82
Using the IF Function
EX 82
Session 2.2 Quick Check
EX 84
Tutorial Summary
EX 84
Key Terms
EX 85
Review Assignments
EX 85
Case Problems
EX 87
Internet Assignments
EX 93
SAM Assessment and Training
EX 93
Quick Check Answers
EX 94
Tutorial 3
EX 95
Developing a Professional-Looking Worksheet
EX 95
Formatting a Sales Report
EX 95
Session 3.1
EX 96
Formatting Worksheet Data
EX 96
Using the Formatting Toolbar
EX 97
Copying Formats
EX 99
Using the Format Cells Dialog Box
EX 100
Changing Font Type, Size, Style, and Color
EX 102
Aligning Cell Contents
EX 105
Indenting and Wrapping Text
EX 106
Other Formatting Options
EX 108
Working with Cell Borders and Backgrounds
EX 108
Adding a Cell Border
EX 108
Applying Background Colors and Patterns
EX 111
Session 3.1 Quick Check
EX 114
Session 3.2
EX 114
Formatting the Worksheet
EX 114
Merging Cells into One Cell
EX 115
Hiding Rows, Columns and Worksheets
EX 116
Adding a Background Image
EX 117
Formatting Sheet Tabs
EX 119
Clearing and Replacing Formats
EX 119
Using Styles
EX 122
Creating a Style
EX 122
Applying a Style
EX 123
Using AutoFormat
EX 124
Formatting the Printed Worksheet
EX 126
Defining the Page Setup
EX 126
Working with Headers and Footers
EX 128
Working with the Print Area and Page Breaks
EX 131
Session 3.2 Quick Check
EX 135
Tutorial Summary
EX 135
Key Terms
EX 135
Review Assignments EX 135
Case Problems
EX 137
Internet Assignments
EX 142
SAM Assessment and Training
EX 142
Quick Check Answers
EX 143
Access
Read This Before You Begin
AC 2
Tutorial 1
AC 3
Introduction to Microsoft Access 2003
AC 3
Viewing and Working with a Table Containing Employer Data
AC 3
Session 1.1
AC 4
Introduction to Database Concepts
AC 4
Organizing Data
AC 4
Databases and Relationships
AC 5
Relational Database Management Systems
AC 6
Opening an Existing Database
AC 7
Exploring the Access and Database Windows
AC 9
Opening an Access Table
AC 10
Navigating an Access Datasheet
AC 11
Printing a Datasheet
AC 12
Saving a Database
AC 12
Session 1.1 Quick Check
AC 13
Session 1.2
AC 13
Working with Queries
AC 13
Opening an Existing Query
AC 14
Creating, Sorting, and Navigating a Query
AC 15
Creating and Navigating a Form
AC 18
Creating, Previewing, and Navigating a Report
AC 20
Printing Specific Pages of a Report
AC 23
Managing a Database
AC 24
Backing up and Restoring a Database
AC 24
Compacting and Repairing a Database
AC 25
Compacting a Database Automatically
AC 26
Converting an Access 2000 Database
AC 27
Session 1.2 Quick Check
AC 28
Tutorial Summary
AC 29
Key Terms
AC 29
Review Assignments
AC 29
Case Problems
AC 30
Internet Assignments
AC 33
SAM Assessment and Training
AC 33
Lab Assignments
AC 34
Quick Check Answers
AC 34
Tutorial 2
AC 35
Creating and Maintaining a Database
AC 35
Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table
AC 35
Session 2.1
AC 36
Guidelines for Designing Databases
AC 36
Guidelines for Setting Field Properties
AC 38
Naming Fields and Objects
AC 38
Assigning Field Data Types
AC 38
Setting Field Sizes
AC 39
Setting Field Captions
AC 40
Creating a New Database
AC 41
Creating a Table
AC 42
Defining Fields
AC 43
Specifying the Primary Key
AC 50
Saving the Table Structure
AC 52
Session 2.1 Quick Check
AC 53
Session 2.2
AC 53
Adding Records to a Table
AC 53
Modifying the Structure of an Access Table
AC 56
Deleting a Field
AC 57
Moving a Field
AC 58
Adding a Field
AC 59
Changing Field Properties
AC 60
Updating Field Property Changes
AC 61
Obtaining Data from Another Access Database
AC 65
Copying Records from Another Access Database
AC 65
Importing a Table from Another Access Database
AC 67
Updating a Database
AC 68
Deleting Records
AC 68
Changing Records
AC 69
Session 2.2 Quick Check
AC 71
Tutorial Summary
AC 71
Key Terms
AC 72
Review Assignments
AC 72
Case Problems
AC 74
Internet Assignments
AC 79
SAM Assessment and Training
AC 80
Quick Check Answers
AC 80
Tutorial 3
AC 81
Querying a Database
AC 81
Retrieving Information About Employers and Their Positions
AC 81
Session 3.1
AC 82
Introduction to Queries
AC 82
Query Window
AC 82
Creating and Running a Query
AC 84
Updating Data Using a Query
AC 87
Defining Table Relationships
AC 87
One-to-Many Relationships
AC 88
Referential Integrity
AC 89
Defining a Relationship Between Two Tables
AC 89
Creating a Multi-table Query
AC 93
Sorting Data in a Query
AC 95
Using a Toolbar Button to Sort Data
AC 95
Sorting Multiple Fields in Design View
AC 96
Filtering Data
AC 100
Session 3.1 Quick Check
AC 102
Session 3.2
AC 102
Defining Record Selection Criteria for Queries
AC 102
Specifying an Exact Match
AC 103
Changing a Datasheet's Appearance
AC 105
Using a Comparison Operator to Match a Range of Values
AC 106
Defining Multiple Selection Criteria for Queries
AC 107
The And Logical Operator
AC 108
Using Multiple Undo and Redo
AC 109
The Or Logical Operator
AC 111
Performing Calculations
AC 112
Creating a Calculated Field
AC 113
Using Aggregate Functions
AC 117
Using Record Group Calculations
AC 119
Session 3.2 Quick Check
AC 121
Tutorial Summary
AC 121
Key Terms
AC 121
Review Assignments
AC 122
Case Problems
AC 123
Internet Assignments
AC 127
SAM Assessment and Training
AC 128
Quick Check Answers
AC 128
PowerPoint
Read This Before You Begin
PPT 2
Tutorial 1
PPT 3
Creating a Presentation
PPT 3
Presenting Information About Humantrian Projects
PPT 3
Session 1.1
PPT 4
What Is PowerPoint
PPT 4
Opening an Existing PowerPoint Presentation
PPT 5
Switching Views and Navigating a Presentation
PPT 6
Viewing a Presentation in Slide Show View
PPT 7
Planning a Presentation
PPT 10
Using the AutoContent Wizard
PPT 10
Session 1.1 Quick Check
PPT 13
Session 1.2
PPT 13
Modifying a Presentation
PPT 13
Editing Slides
PPT 14
Deleting Slides
PPT 17
Adding a New Slide and Choosing a Layout
PPT 19
Promoting, Demoting, and Moving Outline Text
PPT 21
Moving Slides in Slide Sorter View
PPT 23
Checking the Spelling and Style in a Presentation
PPT 24
Checking the Spelling
PPT 24
Using the Style Checker
PPT 25
Using the Research Task Pane
PPT 27
Creating Speaker Notes
PPT 29
Previewing and Printing a Presentation
PPT 30
Session 1.2 Quick Check
PPT 33
Tutorial Summary
PPT 33
Key Terms
PPT 33
Review Assignments
PPT 33
Case Problems
PPT 34
Internet Assignments
PPT 40
SAM Assessment and Training
PPT 40
Quick Check Answers
PPT 40
Outlook
Read This Before You Begin
OUT 2
Tutorial 1
OUT 3
Communicating with Outlook 2003
OUT 3
Sending and Receiving E-mail Messages
OUT 3
Session 1.1
OUT 4
Exploring Outlook
OUT 4
Starting Outlook
OUT 4
Navigating Between Outlook Components
OUT 5
Creating and Sending E-mail Messages
OUT 7
Choosing a Message Format
OUT 8
Adding a Signature
OUT 9
Using Stationery
OUT 10
Creating an E-mail Message
OUT 10
Setting the Importance and Sensitivity Levels
OUT 12
Sending E-mail
OUT 13
Organizing Contact Information
OUT 14
Creating Contacts
OUT 15
Editing Contacts
OUT 19
Sending Contact Information by E-mail
OUT 20
Creating and Modifying Distribution Lists
OUT 20
Modifying a Distribution List
OUT 23
Session 1.1 Quick Check
OUT 23
Session 1.2
OUT 23
Receiving E-mail
OUT 23
Replying to and Forwarding Messages
OUT 25
Printing Messages
OUT 26
Working with Attachments
OUT 27
Flagging Messages
OUT 29
Organizing/Managing Messages
OUT 30
Creating a Folder
OUT 30
Filing Messages
OUT 31
Creating Rules
OUT 33
Rearranging Messages
OUT 34
Finding Messages
OUT 34
Using Search Folders
OUT 35
Switching Views and Arrangements
OUT 37
Sorting Messages
OUT 38
Coloring Messages
OUT 39
Storing Messages
OUT 40
Saving Messages
OUT 40
Archiving Mail Messages
OUT 41
Deleting Items and Exiting Outlook
OUT 42
Session 1.2 Quick Check
OUT 43
Tutorial Summary
OUT 44
Key Terms
OUT 44
Review Assignments
OUT 44
Case Problems
OUT 46
Quick Check Answers
OUT 48
Glossary/Index REF 1
Task Reference REF 13

Rewards Program

Write a Review