search for books and compare prices
Tables of Contents for Office 2000
Chapter/Section Title
Page #
Page Count
Preface
xi
Objectives of the Office 2000 Tutorial
xi
MOUS Certification Program
xi
Organization of the Office 2000 Tutorial
xii
Structure and Format of the Office 2000 Tutorial
xiii
About Peter Norton
xv
Reviewers
xv
SECTION 1: COMPUTER BASICS
1
30
Objectives
2
2
The Multipurpose Tool
4
1
An Overview of the Computer System
5
1
Looking Inside the Machine
6
2
The Computer at a Glance
8
5
Software Brings the Machine to Life
13
2
The Shapes of Computers Today
15
5
What to Expect in the Future
20
1
Self Check
21
1
On the Web: Computer Pricing Online
22
2
Section Summary and Exercises
24
7
SECTION 2: WINDOWS 98 BASICS
31
46
Objectives
32
2
The Windows 98 Operating System
34
1
Starting the Computer with Windows 98
34
2
Using the Windows 98 Desktop
36
1
Using the Mouse
37
3
Working with Windows
40
6
Running Programs
46
2
Choosing Program Options from the Menu Bar
48
1
Using Dialog Boxes
49
2
Printing Your Work
51
1
Getting Help Onscreen
52
3
Using Windows Explorer
55
6
File Attributes
61
2
Shutting Down Your Computer
63
1
Self Check
63
1
On the Web: Getting Online Help
64
2
Section Summary and Exercises
66
11
SECTION 3: EXPLORER 5 BASICS
77
Objectives
78
2
What is Internet Explorer 5?
80
1
Starting the Internet Explorer 5 Browser
81
1
Exploring the Internet Explorer Browser Window
82
4
Navigating the World Wide Web
86
4
Returning to Favorite Places
90
1
Searching the Web
91
2
Using Channels and the Active Desktop
93
1
Using Outlook Express
93
5
Exploring Internet News
98
1
Exiting the Browser
98
1
Self Check
99
1
Section Summary and Exercises
100
INTEGRATION LESSON 1: Introducing Office 2000
1
20
Objectives
4
2
Office Applications
6
3
Starting an Office Program
9
2
Manipulating the Office Shortcut Bar
11
2
Opening a File with the Office Shortcut Bar
13
3
Creating a New File with the Office Shortcut Bar
16
1
Self Check
17
1
Lesson Summary and Exercises
18
Word 2000
Word Basics
4
60
Objectives
4
2
Introducing Microsoft Word
6
1
Using the Mouse
6
2
Starting Microsoft Word
8
1
Exploring the Word Window
9
7
Opening Documents
16
2
Getting Help with Word
18
6
Scrolling Documents
24
2
Viewing Documents
26
3
Inserting Text
29
1
Finding and Editing Text
30
6
Saving Documents
36
3
Previewing Documents
39
3
Printing Documents
42
1
Closing Documents and Exiting Word
43
2
Self Check
45
1
On the Web: Exploring the Web Toolbar
46
4
Lesson Summary and Exercises
50
14
Creating, Editing, and Formatting Documents
64
54
Objectives
64
2
Creating Documents from Templates
66
3
Checking Spelling and Grammar
69
5
Selecting and Deleting Sentences, Lines, and Paragraphs
74
1
Moving and Copying Text
75
6
Reformatting Text
81
11
Enhancing the Appearance of Documents
92
9
Self Check
101
1
On the Web: Inserting Hyperlinks
102
2
Lesson Summary and Exercises
104
14
Inserting Tables, Graphics, and Hyperlinks
118
50
Objectives
118
2
Creating and Formatting Tables
120
18
Inserting and Formatting Graphics
138
4
Creating Objects with Drawing Tools
142
10
Inserting and Editing Graphic Hyperlinks
152
1
Self Check
153
1
On the Web: Navigating and Naming Favorites
154
2
Lesson Summary and Exercises
156
12
Processing Long Documents
168
48
Objectives
168
2
Navigating Long Documents
170
5
Assuring Quality in Long Documents
175
9
Adding Reference Features
184
12
Formatting in Newspaper Columns
196
3
Self Check
199
1
On the Web: Searching the Internet
200
2
Lesson Summary and Exercises
202
14
Creating Web Pages
216
Objectives
216
2
Saving a Word Document as a Web Page
218
1
Planning and Creating a Web Page
219
4
Developing a Personal Web Page
223
10
Using the Web Page Wizard
233
5
Viewing a Web Site in Explorer
238
1
Self Check
239
1
On the Web: Publishing a Web Page
240
2
Lesson Summary and Exercises
242
Case Study
254
INTEGRATION LESSON 2: Integrating Windows 98 Accessories and Word
21
16
Objectives
22
2
Using a Notepad File in a Word Document
24
2
Using Paint
26
5
Copying a Paint Picture into a Word Document
31
2
Self Check
33
1
Lesson Summary and Exercises
34
Excel 2000
Excel Basics
4
42
Objectives
4
2
Introducing Microsoft Excel
6
1
Using the Mouse
7
2
Starting Microsoft Excel
9
2
Exploring the Excel Window
11
5
Opening Workbook Files
16
1
Exploring the Worksheet Area
17
3
Getting Help with Excel
20
8
Printing a Worksheet
28
1
Closing Workbook Files
29
1
Exiting Excel
30
1
Self Check
31
1
On the Web: Exploring the Web Toolbar
32
4
Lesson Summary and Exercises
36
10
Entering and Editing Data
46
52
Objectives
46
2
Entering Data
48
3
Editing Single Cells
51
3
Finding and Replacing Data
54
1
Saving Your Work
55
1
Selecting Groups of Cells
56
5
Erasing Data
61
1
Undoing and Redoing Changes
62
1
Rearranging Your Worksheet
63
8
Filling Ranges with Values
71
4
Self Check
75
1
On the Web: Adding Hyperlinks to a ∼ Worksheet
76
6
Lesson Summary and Exercises
82
16
Performing Calculations and Affecting Multiple Worksheets
98
70
Objectives
98
2
Understanding Formulas
100
6
Using the SUM Function
106
2
Copying Formulas and Understanding Relative References
108
5
Using Absolute and Relative References
113
5
Displaying and Printing Formulas
118
2
Using Statistical Functions
120
3
Using Date and Time Functions
123
2
Making Decisions with the IF Function
125
2
Using Financial Functions
127
4
Using Natural-Language Formulas
131
3
Working with Multiple Worksheets
134
5
Affecting Several Worksheets at Once
139
6
Self Check
145
1
On the Web: Visiting Web Sites and Designating Favorite Places
146
2
Lesson Summary and Exercises
148
20
Formatting and Printing Worksheets
168
66
Objectives
168
2
Aligning Data
170
3
Formatting Numbers and Dates
173
5
Modifying Font Characteristics
178
4
Adding Borders and Color
182
3
Using Auto Formats and Conditional Formatting
185
3
Copying and Clearing Cell Formats
188
2
Using Templates
190
8
Manipulating Columns and Rows
198
6
Learning More about Printing
204
7
Self Check
211
1
On the Web: Searching for Information on the Web
212
2
Lesson Summary and Exercises
214
20
Charting Your Data
234
Objectives
234
2
Using Charts in Excel
236
1
Creating Charts with the Chart Wizard
237
5
Creating a Default Chart
242
2
Modifying Charts
244
12
Inserting, Moving, and Deleting Objects
256
5
Printing Charts
261
2
Self Check
263
1
On the Web: Creating a Web Page from an Excel Workbook
264
4
Lesson Summary and Exercises
268
Case Study
286
INTEGRATION LESSON 3: Integrating Word and Excel Data
37
16
Objectives
38
2
Cutting and Pasting Between Word and Excel
40
2
Copying an Excel Object into a Word Document
42
2
Embedding and Linking Data
44
2
Self Check
46
1
Lesson Summary and Exercises
47
Access 2000
Access Basics
4
52
Objectives
4
2
Introducing Microsoft Access
6
1
Using the Mouse
7
1
Starting Microsoft Access
8
2
Exploring Access
10
8
Opening Databases
18
2
Objects: The Components of Access
20
9
Getting Help with Access
29
7
Printing Objects
36
1
Compacting Databases
37
1
Closing Databases and Exiting Access
38
1
Self Check
39
1
On the Web: Exploring the Web Toolbar
40
4
Lesson Summary and Exercises
44
12
Designing and Creating Databases
56
48
Objectives
56
2
Planning Ahead
58
3
Creating a Database
61
1
Creating Tables
62
17
Saving the Table Design
79
2
Modifying Tables Using Design View
81
6
Self Check
87
1
On the Web: Navigating and Returning to Favorite Sites
88
2
Lesson Summary and Exercises
90
14
Adding and Maintaining Data in Tables
104
58
Objectives
104
2
Entering Records Using a Datasheet
106
4
Retrieving Data from Another Table
110
4
Importing Data
114
2
Editing and Viewing Records in the Datasheet
116
9
Searching for Records Based on their Contents
125
4
Changing the Datasheet Display
129
7
Establishing and Defining Table Relationships
136
5
Self Check
141
1
On the Web: Accessing the Search Page
142
2
Lesson Summary and Exercises
144
18
Retrieving Data
162
44
Objectives
162
2
Sorting and Selecting Data
164
1
Using the Sort Commands
164
2
Filtering Your Data
166
11
Designing Basic Queries
177
6
Querying Multiple Tables
183
4
Self Check
187
1
On the Web: Creating Hyperlinks
188
4
Lesson Summary and Exercises
192
14
Using Forms and Reports
206
Objectives
206
2
When and Why to Use Forms
208
2
Creating an AutoForm
210
2
Creating a Form with the Form Wizard
212
4
Adding and Editing Data by Using Forms and Subforms
216
2
Modifying Controls in Forms
218
5
Using Sections in Forms
223
1
Previewing and Printing Forms
224
1
When and Why to Use Reports
225
1
Creating an AutoReport
225
3
Using the Report Wizard
228
7
Creating Totals in Reports
235
3
Modifying Controls in Reports
238
5
Using Sections in Reports
243
1
Printing Reports
244
1
Self Check
245
1
On the Web: Creating Your Own Web Page
246
4
Lesson Summary and Exercises
250
Case Study
268
INTEGRATION LESSON 4: Integrating Word, Excel, and Access Data
53
17
Objectives
54
2
Defining an Integrated Mail Merge Document
56
2
Adding an Excel Chart
58
2
The Final Integration
60
1
Merging Selected Records
61
1
Integrating Excel and Access Data
62
2
Self Check
64
1
Lesson Summary and Exercises
65
PowerPoint 2000
PowerPoint Basics
4
58
Objectives
4
2
Introducing Microsoft PowerPoint
6
1
Using the Mouse
7
2
Starting Microsoft PowerPoint
9
2
Exploring the PowerPoint Window
11
9
Opening Presentations
20
2
Navigating Among Different PowerPoint Views
22
3
Getting Help with PowerPoint
25
6
Navigating Slides
31
2
Editing Text
33
5
Moving and Deleting Slides
38
1
Previewing Presentations
39
1
Printing Presentations
40
2
Saving Presentations
42
1
Closing Files and Exiting PowerPoint
43
2
Self Check
45
1
On the Web: Exploring the Web Toolbar
46
4
Lesson Summary and Exercises
50
12
Creating a Presentation
62
46
Objectives
62
2
Beginning with a Template
64
2
Adding Slides, Text, and Notes
66
4
Importing and Formatting Text
70
8
Inserting Clip Art
78
4
Drawing and Enhancing Objects
82
2
Inserting Graphs
84
4
Creating and Enhancing Tables
88
5
Self Check
93
1
On the Web: Creating Hyperlinks
94
2
Lesson Summary and Exercises
96
12
Customizing Design Templates with Slide Masters
108
32
Objectives
108
2
Using the Slide Master to Change Formatting
110
4
Repeating An Element on Every Slide
114
4
Working with Labeled Objects
118
3
Overriding the Slide Master
121
4
Self Check
125
1
On the Web: Naming Favorites and Searching the Web
126
2
Lesson Summary and Exercises
128
12
Producing Presentations
140
Objectives
140
2
Developing Presentations
142
10
Delivering Presentations
152
2
Printing Presentations
154
5
Self Check
159
1
On the Web: Previewing, Creating, and Publishing Web Pages
160
2
Lesson Summary and Exercises
162
Case Study
174
INTEGRATION LESSON 5: Integrating Word, Excel, Access, and PowerPoint Data
70
21
Objectives
70
2
Sharing Information Between Word and PowerPoint
72
4
Linking an Excel Chart to a PowerPoint Slide
76
2
Copying an Access Table to a PowerPoint Slide
78
1
Grouping Documents in a Binder
79
6
Self Check
85
1
Lesson Summary and Exercises
86
5
INTEGRATION LESSON 6: Using Outlook
91
40
Objectives
92
2
Starting Outlook and Exploring the Outlook Window
94
2
Using the Inbox
96
5
Scheduling with the Calendar
101
6
Creating Contacts
107
5
Tracking Tasks
112
3
Organizing with Notes
115
5
Using Outlook Today
120
1
Using the Journal
121
4
Self Check
125
1
Lesson Summary and Exercises
126
5
INTEGRATION LESSON 7: Integrating Office 2000
131
34
Objectives
132
2
Integrating Calendar Data into a Worksheet
134
2
Creating a Word Letter from an Outlook Contact Entry
136
3
Integrating Access Data with Outlook
139
1
Sharing Text Between Word and Outlook
140
2
Using Mail Merge Through Outlook
142
3
Self Check
145
1
On the Web: Adding a Web Page Shortcut to Your Outlook Bar
146
2
Lesson Summary and Exercises
148
17
APPENDICES
165
43
Appendix A: Portfolio Builder
166
3
Appendix B: Command Summary
169
16
Appendix C: Toolbar Summary
185
10
Appendix D: Answers to Self Check
195
1
Appendix E: The History of Microcomputers
196
12
Glossary
208
17
Index
225