New Perspectives on Microsoft Office 2003

by Shaffer,Ann

• ISBN13: 9780619206574
• ISBN10: 0619206578
• Format: Paperback
• Copyright: 2004-02-02
• Publisher: Cengage Learning

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