Napier & Judd |
|
v | |
Preface |
|
vi | |
Office Unit |
|
1 | (1) |
|
Getting Started with Microsoft Office 2000 |
|
|
2 | (18) |
|
What Is Microsoft Office 2000? |
|
|
3 | (1) |
|
Hardware and Software Requirements |
|
|
4 | (1) |
|
Identifying Common Office Elements |
|
|
4 | (3) |
|
Starting Office Applications |
|
|
7 | (4) |
|
Getting Help in Office Applications |
|
|
11 | (5) |
|
Closing Office Applications |
|
|
16 | (4) |
|
Working with Menus and Toolbars |
|
|
20 | (15) |
|
Working with Personalized Menus and Toolbars |
|
|
21 | (4) |
|
Viewing, Hiding, Docking, and Floating Toolbars |
|
|
25 | (2) |
|
Customizing the Menu Bar and Toolbars |
|
|
27 | (1) |
|
Viewing and Customizing the Office Shortcut Bar |
|
|
28 | (7) |
|
Working With Others Using Online Collaboration Tools |
|
|
35 | (15) |
|
Scheduling an Online Meeting |
|
|
36 | (6) |
|
Participating in Web Discussions |
|
|
42 | (8) |
|
Introduction to the Internet and the World Wide Web |
|
|
50 | (1) |
|
|
51 | (1) |
|
Connecting to the Internet |
|
|
52 | (3) |
|
Challenges to Using the Internet |
|
|
55 | (1) |
|
|
56 | (3) |
|
Using Directories and Search Engines |
|
|
59 | |
Outlook Unit |
|
1 | (1) |
|
|
1 | (1) |
|
Identifying the Components of the Outlook Window |
|
|
2 | (2) |
|
|
4 | (2) |
|
Using Outlook as an E-mail Client |
|
|
6 | (5) |
|
Using the Outlook Calendar |
|
|
11 | (5) |
|
Using the Outlook Contact Manager |
|
|
16 | (2) |
|
Using the Outlook Task Manager |
|
|
18 | (4) |
|
Using the Outlook Journal |
|
|
22 | (2) |
|
Using the Outlook Notes Manager |
|
|
24 | (2) |
|
Using Advanced Outlook Features |
|
|
26 | |
Word Unit |
|
1 | (1) |
|
|
2 | (26) |
|
Identifying the Components of the Word |
|
|
3 | (3) |
|
Composing a Simple Document |
|
|
6 | (1) |
|
|
7 | (1) |
|
|
8 | (2) |
|
Previewing and Printing a Document |
|
|
10 | (1) |
|
|
11 | (1) |
|
Locating and Opening an Existing Document |
|
|
11 | (7) |
|
|
18 | (1) |
|
|
19 | (1) |
|
Sending a Word Document via E-mail |
|
|
19 | (9) |
|
Creating and Editing a Word Document |
|
|
28 | (24) |
|
|
29 | (4) |
|
|
33 | (3) |
|
Cutting, Copying, Inserting, Moving, and Pasting Text |
|
|
36 | (4) |
|
|
40 | (1) |
|
Using the Undo, Redo, and Repeat Commands |
|
|
40 | (1) |
|
|
41 | (1) |
|
Switching Between Different Editing Views |
|
|
42 | (10) |
|
|
52 | (23) |
|
Using the Spelling and Grammar Features |
|
|
53 | (3) |
|
|
56 | (1) |
|
|
57 | (5) |
|
|
62 | (4) |
|
Inserting Dates with AutoComplete |
|
|
66 | (9) |
|
|
75 | (29) |
|
|
76 | (2) |
|
Selecting and Changing Fonts and Font Sizes |
|
|
78 | (2) |
|
|
80 | (3) |
|
Applying Character Effects |
|
|
83 | (4) |
|
Applying Character Spacing and Animation Effects |
|
|
87 | (1) |
|
Duplicating Character Formats |
|
|
88 | (2) |
|
Changing the Case of Text |
|
|
90 | (1) |
|
Adding Bullets and Numbering |
|
|
91 | (2) |
|
Highlighting Text in a Document |
|
|
93 | (1) |
|
Inserting Symbols and Special Characters |
|
|
94 | (10) |
|
|
104 | (19) |
|
|
105 | (3) |
|
|
108 | (2) |
|
|
110 | (1) |
|
|
111 | (1) |
|
|
112 | (2) |
|
Setting Tabs with Leaders |
|
|
114 | (9) |
|
Setting Spacing, Aligning Text, and Using |
|
|
123 | (21) |
|
|
|
Setting Character, Line, and Paragraph Spacing |
|
|
124 | (3) |
|
|
127 | (2) |
|
Aligning Text in Paragraphs |
|
|
129 | (2) |
|
Using Indentation Options |
|
|
131 | (13) |
|
Previewing and Printing a Document |
|
|
144 | (15) |
|
|
145 | (5) |
|
|
150 | (9) |
|
Preparing and Printing Envelopes and Labels |
|
|
159 | (1) |
|
Preparing and Printing Envelopes |
|
|
160 | (6) |
|
Preparing and Printing Labels |
|
|
166 | |
|
|
1 | (31) |
|
|
2 | (7) |
|
|
9 | (2) |
|
Creating Sections with Different Formatting |
|
|
11 | (3) |
|
Creating and Modifying Headers and Footers |
|
|
14 | (5) |
|
|
19 | (4) |
|
|
23 | (9) |
|
Working with Columns and Drawing Objects |
|
|
32 | (21) |
|
Creating and Using Newspaper-Style |
|
|
33 | (5) |
|
Using the Drawing Toolbar |
|
|
38 | (15) |
|
Using Tables to Organize Information |
|
|
53 | (38) |
|
Creating and Formatting Tables |
|
|
54 | (6) |
|
Revising Tables and Modifying Table Structure |
|
|
60 | (7) |
|
Using Special Table Features |
|
|
67 | (10) |
|
|
77 | (14) |
|
Using Styles and Templates |
|
|
91 | (23) |
|
|
92 | (6) |
|
|
98 | (3) |
|
Using Templates and Wizards to Create Documents |
|
|
101 | (13) |
|
|
114 | (23) |
|
Organizing a Document in Outline View |
|
|
115 | (4) |
|
|
119 | (6) |
|
Using Outline Numbered Formats to Create Outlines |
|
|
125 | (12) |
|
Creating Documents for the Internet or an Intranet |
|
|
137 | (1) |
|
|
138 | (2) |
|
|
140 | (11) |
|
Testing and Publishing Web Pages |
|
|
151 | |
Excel Unit |
|
1 | (1) |
|
|
2 | (26) |
|
Exploring the Excel Components |
|
|
3 | (2) |
|
Locating and Opening an Existing Workbook |
|
|
5 | (1) |
|
|
6 | (1) |
|
Entering Text, Dates, and Numbers |
|
|
7 | (2) |
|
|
9 | (2) |
|
|
11 | (2) |
|
Clearing Contents and Formatting of Cells |
|
|
13 | (1) |
|
|
13 | (1) |
|
Entering Formulas and Functions |
|
|
14 | (4) |
|
|
18 | (2) |
|
Closing Workbooks and Exiting Excel |
|
|
20 | (8) |
|
|
28 | (24) |
|
Merging Cells to Create a Worksheet Title |
|
|
29 | (1) |
|
Working with a Series to Add Labels |
|
|
30 | (2) |
|
Modifying the Size of Columns and Rows |
|
|
32 | (1) |
|
Changing Fonts and Font Styles |
|
|
33 | (2) |
|
Modifying the Alignment of Cell Contents |
|
|
35 | (1) |
|
Rotating Text and Changing Indents |
|
|
36 | (1) |
|
|
37 | (3) |
|
Applying Cell Borders and Shading |
|
|
40 | (12) |
|
Organizing Worksheets Effectively |
|
|
52 | (28) |
|
Performing Single and Multi-level Sorts |
|
|
53 | (1) |
|
Copying and Moving Data Using Drag and Drop |
|
|
54 | (2) |
|
|
56 | (1) |
|
Inserting, Moving, Copying, and Deleting Worksheets |
|
|
56 | (2) |
|
Copy and Move Data Using Cut, Copy, and Paste |
|
|
58 | (3) |
|
Inserting and Deleting Cells, Rows, and Columns |
|
|
61 | (1) |
|
Using Absolute, Relative, and Mixed References in Formulas |
|
|
62 | (3) |
|
Creating and Using Named Ranges |
|
|
65 | (2) |
|
Freezing and Unfreezing Rows and Columns |
|
|
67 | (1) |
|
Using Grouping and Outlines |
|
|
68 | (3) |
|
Check Spelling in a Worksheet |
|
|
71 | (9) |
|
Previewing and Printing Worksheets |
|
|
80 | (18) |
|
Previewing and Modifying Page Setup Options |
|
|
81 | (7) |
|
Inserting and Removing Page Breaks |
|
|
88 | (2) |
|
Printing an Entire Workbook |
|
|
90 | (8) |
|
|
98 | (1) |
|
Using Chart Wizard to Create a Chart |
|
|
99 | (3) |
|
Formatting and Modifying a Chart |
|
|
102 | (3) |
|
Previewing and Printing Charts |
|
|
105 | (1) |
|
Working with Embedded Charts |
|
|
106 | |
|
Integrating Excel with Office Applications and the Internet |
|
|
1 | (1) |
|
Integrating Excel with Word and PowerPoint |
|
|
2 | (7) |
|
Integrating Excel with Access |
|
|
9 | (6) |
|
Importing Data from Other Applications |
|
|
15 | (1) |
|
Sending a Workbook via E-mail |
|
|
16 | (4) |
|
Integrating Excel with the Internet |
|
|
20 | |
PowerPoint Unit |
|
1 | (1) |
|
Quick Start for PowerPoint |
|
|
2 | (23) |
|
|
3 | (1) |
|
Exploring the PowerPoint Window |
|
|
4 | (3) |
|
Navigating through a Presentation |
|
|
7 | (1) |
|
Navigating Among the PowerPoint Views |
|
|
7 | (4) |
|
|
11 | (1) |
|
Applying a Design Template |
|
|
11 | (3) |
|
|
14 | (1) |
|
|
15 | (1) |
|
Changing the Presentation Design |
|
|
16 | (1) |
|
|
17 | (1) |
|
|
17 | (8) |
|
Editing and Formatting Slides |
|
|
25 | (24) |
|
Opening a Presentation and Adding a Bullet Slide |
|
|
26 | (1) |
|
Working with Second-Level Bullets |
|
|
26 | (2) |
|
|
28 | (2) |
|
|
30 | (2) |
|
Moving a Slide in Outline View |
|
|
32 | (1) |
|
Editing and Formatting Slides |
|
|
32 | (6) |
|
Formatting the Slide Master |
|
|
38 | (3) |
|
Printing an Individual Slide |
|
|
41 | (8) |
|
Using Clip Art and WordArt |
|
|
49 | (24) |
|
Using the Microsoft Clip Gallery |
|
|
50 | (4) |
|
|
54 | (5) |
|
Inserting Images from Another Source |
|
|
59 | (1) |
|
Adding an Image to the Slide Master |
|
|
59 | (2) |
|
Using the Clipboard Toolbar |
|
|
61 | (1) |
|
Adding WordArt to a Slide |
|
|
62 | (11) |
|
Using Drawing Tools and AutoShapes |
|
|
73 | (1) |
|
|
74 | (3) |
|
Using the AutoShapes Tool |
|
|
77 | (1) |
|
Editing and Formatting Shapes |
|
|
77 | (3) |
|
|
80 | (1) |
|
Working with Multiple Objects |
|
|
80 | (4) |
|
|
84 | |
|
Integrating Word and Excel with PowerPoint |
|
|
1 | (1) |
|
Sending a PowerPoint Presentation to Word |
|
|
2 | (5) |
|
Sending a Word Outline to a PowerPoint Presentation |
|
|
7 | (4) |
|
Inserting Slides from a Word Outline |
|
|
11 | (1) |
|
Inserting Slides from one PowerPoint Presentation to Another |
|
|
12 | (2) |
|
Adding a Word Table to a PowerPoint Slide |
|
|
14 | (2) |
|
Embedding an Excel Worksheet in a PowerPoint Slide |
|
|
16 | (3) |
|
Linking an Excel Chart to a PowerPoint Slide |
|
|
19 | |
Access Unit |
|
1 | (1) |
|
|
2 | (22) |
|
|
3 | (1) |
|
Opening the Access Application |
|
|
3 | (2) |
|
Viewing the Access Window |
|
|
5 | (2) |
|
|
7 | (1) |
|
Identifying Access Objects |
|
|
8 | (9) |
|
|
17 | (7) |
|
Designing and Creating a Database |
|
|
24 | (28) |
|
|
25 | (1) |
|
|
26 | (1) |
|
|
27 | (2) |
|
Creating a Table by Using the Table Wizard |
|
|
29 | (2) |
|
Creating a Table in Design View |
|
|
31 | (9) |
|
Modifying Tables Using Design View |
|
|
40 | (4) |
|
|
44 | (8) |
|
Entering and Editing Data into Tables |
|
|
52 | (18) |
|
Entering Records Using a Datasheet |
|
|
53 | (2) |
|
Navigating Through Records |
|
|
55 | (1) |
|
Modifying Data in a Table |
|
|
55 | (6) |
|
Adding Pictures to Records |
|
|
61 | (9) |
|
Designing and Using Basic Forms |
|
|
70 | (1) |
|
|
71 | (1) |
|
Creating a Form with the Form Wizard |
|
|
71 | (6) |
|
|
77 | (3) |
|
|
80 | (3) |
|
Using the Control Toolbox to Add and Modify Controls |
|
|
83 | (4) |
|
Modifying Format Properties |
|
|
87 | (3) |
|
|
90 | |
|
Integrating Access with Other Office Applications and the Internet |
|
|
1 | (1) |
|
Exporting Database Objects |
|
|
2 | (8) |
|
Exporting Database Records to Excel |
|
|
10 | (2) |
|
Using Excel Data with Access |
|
|
12 | (9) |
|
Integrating Access with the Internet |
|
|
21 | |
Appendix |
|
1 | (34) |
|
A Working with Windows 2000 |
|
|
1 | (12) |
|
a. Reviewing the Windows 2000 Desktop |
|
|
2 | (2) |
|
b. Accessing Your Computer System Resources |
|
|
4 | (2) |
|
c. Using Menu Commands and Toolbar Buttons |
|
|
6 | (1) |
|
|
7 | (1) |
|
e. Reviewing Dialog Box Options |
|
|
8 | (1) |
|
f. Using Windows 2000 Shortcuts |
|
|
9 | (2) |
|
g. Understanding the Recycle Bin |
|
|
11 | (1) |
|
h. Shutting Down Windows 2000 |
|
|
11 | (2) |
|
B Managing Your Folders and Files Using Windows Explorer |
|
|
13 | (6) |
|
a. Opening Windows Explorer |
|
|
14 | (1) |
|
b. Reviewing Windows Explorer Options |
|
|
15 | (1) |
|
|
16 | (1) |
|
d. Moving and Copying Folders and Files |
|
|
17 | (1) |
|
e. Renaming Folders and Files |
|
|
17 | (1) |
|
f. Creating Desktop Shortcuts |
|
|
18 | (1) |
|
g. Deleting Folders and Files |
|
|
18 | (1) |
|
C Formatting Tips for Business Documents |
|
|
19 | (16) |
|
|
20 | (4) |
|
b. Inserting Mailing Notations |
|
|
24 | (2) |
|
|
26 | (2) |
|
d. Formatting Interoffice Memorandums |
|
|
28 | (2) |
|
e. Formatting Formal Outlines |
|
|
30 | (2) |
|
f. Using Proofreader's Marks |
|
|
32 | (1) |
|
|
33 | (2) |
Core MOUS Grid |
|
35 | |
Index |
|
1 | |