|
|
|
|
1 | (2) |
|
Electro-Mechanical Devices |
|
|
3 | (1) |
|
First Generation Computers |
|
|
4 | (1) |
|
The Stored Program Computer |
|
|
5 | (1) |
|
Second Generation Computers |
|
|
6 | (1) |
|
High-Level Programming Languages |
|
|
6 | (1) |
|
Third Generation Computers |
|
|
7 | (1) |
|
|
7 | (1) |
|
Fourth Generation Computers |
|
|
8 | (1) |
|
|
8 | (1) |
|
|
9 | (1) |
|
|
10 | (1) |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
12 | (1) |
|
|
12 | (2) |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
15 | (1) |
|
Internet Service Providers |
|
|
15 | (1) |
|
|
16 | (1) |
|
|
16 | (1) |
|
Computer Use Privacy Issues |
|
|
17 | (1) |
|
|
18 | (1) |
|
|
19 | (2) |
|
|
21 | (1) |
|
|
22 | (3) |
|
|
25 | |
|
|
|
|
1 | (1) |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (2) |
|
Minimizing and Quitting Outlook |
|
|
10 | (2) |
|
|
12 | (1) |
|
Previewing and Printing the Calendar |
|
|
13 | (3) |
|
|
16 | (2) |
|
|
18 | (1) |
|
Outlook Commands and Buttons |
|
|
18 | (1) |
|
|
19 | (1) |
|
|
20 | |
|
Advanced Outlook Features and E-mail |
|
|
|
The Outlook Contacts Tool |
|
|
1 | (1) |
|
|
2 | (1) |
|
|
3 | (2) |
|
|
5 | (2) |
|
|
7 | (2) |
|
|
9 | (1) |
|
|
10 | (1) |
|
Using Outlook to Send E-mail |
|
|
10 | (3) |
|
Organizing E-mail Messages |
|
|
13 | (2) |
|
Adding a Signature to E-mail Messages |
|
|
15 | (3) |
|
Using Contacts to Create a vCard |
|
|
18 | (1) |
|
|
19 | (1) |
|
|
19 | (1) |
|
|
20 | (2) |
|
|
22 | (1) |
|
|
23 | (1) |
|
Outlook Commands and Buttons |
|
|
24 | (1) |
|
|
25 | (1) |
|
|
26 | |
|
Introducing the Word Processor |
|
|
|
What is a Word Processor? |
|
|
1 | (1) |
|
Creating a New Word Document |
|
|
1 | (1) |
|
Using the Keyboard with Word |
|
|
2 | (1) |
|
Editing Text in a Document |
|
|
3 | (1) |
|
|
3 | (1) |
|
|
4 | (3) |
|
|
7 | (1) |
|
Automatic Spelling and Grammar Checking |
|
|
8 | (1) |
|
|
9 | (2) |
|
Displaying Formatting Marks |
|
|
11 | (1) |
|
Closing a Document and Quitting Word |
|
|
12 | (1) |
|
|
12 | (2) |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
16 | (1) |
|
Moving a Document in the Window |
|
|
17 | (2) |
|
|
19 | (2) |
|
|
21 | (1) |
|
Word Commands and Buttons |
|
|
22 | (1) |
|
|
23 | (1) |
|
|
24 | |
|
|
|
|
1 | (1) |
|
The Undo Command and the Repeat Command |
|
|
1 | (1) |
|
|
2 | (2) |
|
Character Formats - Fonts |
|
|
4 | (1) |
|
|
5 | (1) |
|
Character Formats - Style |
|
|
6 | (1) |
|
|
6 | (2) |
|
Character Formats - Superscripts and Subscripts |
|
|
8 | (2) |
|
Paragraph Formats - Alignment |
|
|
10 | (1) |
|
Paragraph Formats - Line Spacing |
|
|
11 | (2) |
|
|
13 | (3) |
|
Page Formats - Headers and Footers |
|
|
16 | (1) |
|
|
17 | (2) |
|
Page Formats - Pagination |
|
|
19 | (1) |
|
|
20 | (2) |
|
Setting Individual Tab Stops |
|
|
22 | (1) |
|
Selecting a Vertical Block of Text |
|
|
23 | (2) |
|
|
25 | (2) |
|
|
27 | (1) |
|
Word Commands and Buttons |
|
|
28 | (1) |
|
|
29 | (1) |
|
|
30 | |
|
|
|
|
1 | (1) |
|
|
2 | (2) |
|
Finding Text in a Document |
|
|
4 | (1) |
|
Finding Special Characters |
|
|
5 | (2) |
|
|
7 | (1) |
|
|
8 | (2) |
|
Paragraph Formats - Indents |
|
|
10 | (1) |
|
Copying and Pasting Paragraph Formats |
|
|
11 | (1) |
|
The Reveal Formatting Task Pane |
|
|
11 | (3) |
|
Paragraph Formats - Hanging and First Line Indents |
|
|
14 | (1) |
|
|
15 | (2) |
|
Creating Footnotes and Endnotes |
|
|
17 | (2) |
|
|
19 | (1) |
|
Displaying Document Information |
|
|
20 | (2) |
|
Adding Clip Art to a Document |
|
|
22 | (2) |
|
Formatting a Document in Columns |
|
|
24 | (2) |
|
|
26 | (1) |
|
|
27 | (1) |
|
Word Commands and Buttons |
|
|
28 | (1) |
|
|
29 | (1) |
|
|
30 | |
|
Advanced Word Processor Features |
|
|
|
|
1 | (1) |
|
|
2 | (2) |
|
|
4 | (1) |
|
|
5 | (1) |
|
|
5 | (1) |
|
|
6 | (3) |
|
|
9 | (2) |
|
Creating a Table of Contents |
|
|
11 | (1) |
|
Creating Sections in a Document |
|
|
12 | (2) |
|
Using Section Headers and Footers |
|
|
14 | (1) |
|
Using Section Page Numbers |
|
|
15 | (2) |
|
Creating a Hyperlink to a Web Page |
|
|
17 | (1) |
|
Creating a Hyperlink to a Heading |
|
|
18 | (1) |
|
|
18 | (2) |
|
|
20 | (1) |
|
|
21 | (1) |
|
|
22 | (2) |
|
Where can you go from here? |
|
|
24 | (1) |
|
|
24 | (2) |
|
|
26 | (1) |
|
Word Commands and Buttons |
|
|
26 | (2) |
|
|
28 | (1) |
|
|
29 | |
|
Introducing the Spreadsheet |
|
|
|
|
1 | (1) |
|
Creating a New Excel Workbook |
|
|
2 | (1) |
|
|
3 | (1) |
|
Entering Data into a Worksheet |
|
|
3 | (1) |
|
|
4 | (2) |
|
Saving, Closing, and Opening a Workbook and Quitting Excel |
|
|
6 | (1) |
|
Previewing and Printing a Worksheet |
|
|
6 | (1) |
|
Adding a Header and Footer |
|
|
7 | (2) |
|
Changing the Width of a Column |
|
|
9 | (1) |
|
|
10 | (1) |
|
|
10 | (2) |
|
|
12 | (2) |
|
Using Formulas to Perform Calculations |
|
|
14 | (3) |
|
Using Cell References in Formulas |
|
|
17 | (2) |
|
Using Functions to Perform Calculations |
|
|
19 | (1) |
|
|
20 | (1) |
|
Entering Formulas - Pointing |
|
|
21 | (1) |
|
|
21 | (2) |
|
|
23 | (1) |
|
|
23 | (1) |
|
|
24 | (2) |
|
|
26 | (2) |
|
|
28 | (1) |
|
Excel Commands and Buttons |
|
|
29 | (1) |
|
|
30 | (2) |
|
|
32 | |
|
|
|
|
1 | (1) |
|
The Find and Replace Commands |
|
|
2 | (1) |
|
|
3 | (1) |
|
The MAX and MIN Functions |
|
|
4 | (1) |
|
Inserting a Function into a Formula |
|
|
5 | (2) |
|
|
7 | (1) |
|
Inserting and Deleting Rows and Columns |
|
|
8 | (2) |
|
Printing a Large Worksheet |
|
|
10 | (1) |
|
|
11 | (3) |
|
Using Text in the IF Function |
|
|
14 | (1) |
|
|
15 | (2) |
|
|
17 | (1) |
|
Excel Commands and Buttons |
|
|
17 | (1) |
|
|
18 | (1) |
|
|
19 | |
|
|
|
|
1 | (1) |
|
Copying and Moving Data Between Sheets |
|
|
2 | (1) |
|
Using Cell References from Different Sheets |
|
|
3 | (1) |
|
|
4 | (1) |
|
|
5 | (2) |
|
|
7 | (1) |
|
|
8 | (5) |
|
Moving, Sizing, and Deleting Charts |
|
|
13 | (1) |
|
|
14 | (1) |
|
Creating Bar and Line Charts |
|
|
15 | (3) |
|
|
18 | (1) |
|
Adding Adjacent Series and Labels |
|
|
19 | (2) |
|
Adding Nonadjacent Series and Labels |
|
|
21 | (2) |
|
|
23 | (5) |
|
|
28 | (1) |
|
|
29 | (1) |
|
Excel Commands and Buttons |
|
|
30 | (1) |
|
|
31 | (1) |
|
|
32 | |
|
Advanced Spreadsheet Techniques |
|
|
|
|
1 | (1) |
|
|
2 | (2) |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (1) |
|
|
8 | (2) |
|
|
10 | (2) |
|
Using Text in the CHOOSE and VLOOKUP Functions |
|
|
12 | (2) |
|
Amortization Tables and the PMT Function |
|
|
14 | (1) |
|
Printing a Selected Worksheet Area |
|
|
14 | (3) |
|
Creating a Hyperlink to a Worksheet Location |
|
|
17 | (2) |
|
|
19 | (1) |
|
Saving Excel Data in HTML Format |
|
|
20 | (1) |
|
|
21 | (1) |
|
|
22 | (1) |
|
Excel Commands and Buttons |
|
|
23 | (1) |
|
|
24 | (1) |
|
|
25 | |
|
Integrating Data Between Word and Excel |
|
|
|
Working with Multiple Files in an Application |
|
|
1 | (1) |
|
Saving and Closing Multiple Files |
|
|
2 | (1) |
|
Copying Text Between Word Documents |
|
|
2 | (2) |
|
Copying Data Between Excel Workbooks |
|
|
4 | (2) |
|
Working with Multiple Applications |
|
|
6 | (1) |
|
Copying Data Between Applications |
|
|
6 | (2) |
|
Using the Office Clipboard to Copy Data |
|
|
8 | (2) |
|
Copying a Chart Object into a Word Document |
|
|
10 | (2) |
|
Creating a Hyperlink to a File |
|
|
12 | (1) |
|
Embedding and Linking a Word Document Object |
|
|
13 | (2) |
|
Embedding and Linking an Excel Worksheet Object |
|
|
15 | (3) |
|
Embedding and Linking an Excel Chart Object |
|
|
18 | (2) |
|
|
20 | (1) |
|
|
21 | (1) |
|
Word and Excel Commands and Buttons |
|
|
21 | (1) |
|
|
22 | (1) |
|
|
23 | |
|
Introducing the Relational Database |
|
|
|
|
1 | (1) |
|
|
2 | (1) |
|
|
3 | (1) |
|
Designing a Relational Database |
|
|
4 | (1) |
|
Creating a New Relational Database |
|
|
5 | (1) |
|
Creating Tables and Fields |
|
|
6 | (2) |
|
Saving and Closing a Table |
|
|
8 | (1) |
|
Closing and Opening a Database and Quitting Access |
|
|
8 | (3) |
|
|
11 | (3) |
|
Using Forms and Entering Records |
|
|
14 | (1) |
|
Viewing Records in Datasheet View |
|
|
15 | (3) |
|
Formatting Datasheet View |
|
|
18 | (1) |
|
|
19 | (2) |
|
|
21 | (1) |
|
|
22 | (1) |
|
|
23 | (2) |
|
|
25 | (2) |
|
|
27 | (1) |
|
Access Commands and Buttons |
|
|
28 | (1) |
|
|
28 | (2) |
|
|
30 | |
|
Relational Database Techniques |
|
|
|
Modifying a Table and Updating a Form |
|
|
1 | (1) |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
4 | (3) |
|
|
7 | (2) |
|
|
9 | (4) |
|
Modifying and Deleting a Select Query |
|
|
13 | (1) |
|
Sorting Select Query Results |
|
|
14 | (2) |
|
|
16 | (2) |
|
Select Queries Involving ``And'' |
|
|
18 | (2) |
|
Select Queries Using ``Or'' |
|
|
20 | (2) |
|
|
22 | (1) |
|
|
23 | (2) |
|
|
25 | (1) |
|
Access Commands and Buttons |
|
|
26 | (1) |
|
|
27 | (1) |
|
|
28 | |
|
Relational Database Reports and Advanced Database Techniques |
|
|
|
|
1 | (1) |
|
|
2 | (6) |
|
|
8 | (2) |
|
Using Fields in Query Criteria |
|
|
10 | (1) |
|
|
11 | (2) |
|
Where can you go from here? |
|
|
13 | (1) |
|
|
13 | (1) |
|
|
14 | (1) |
|
Access Commands and Buttons |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
15 | |
|
Integrating Data Between Access, Word, and Excel |
|
|
|
Copying Data From Access to Word |
|
|
1 | (2) |
|
Inserting and Linking Access Data into a Word Document |
|
|
3 | (3) |
|
Creating a Workbook From Access Data |
|
|
6 | (2) |
|
Using Excel Data to Create an Access Table |
|
|
8 | (2) |
|
Mail Merge - Form Letters |
|
|
10 | (7) |
|
Mail Merge - Mailing Labels |
|
|
17 | (6) |
|
|
23 | (1) |
|
|
24 | (1) |
|
Access and Word Commands and Buttons |
|
|
25 | (1) |
|
|
25 | (1) |
|
|
26 | |
|
|
|
|
1 | (1) |
|
Creating a New PowerPoint Presentation |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
3 | (1) |
|
|
4 | (1) |
|
|
5 | (1) |
|
Adding and Deleting Slides |
|
|
6 | (2) |
|
Adding a Picture to a Slide |
|
|
8 | (1) |
|
Changing the Order of Slides |
|
|
9 | (1) |
|
|
9 | (4) |
|
|
13 | (1) |
|
|
13 | (1) |
|
|
14 | (2) |
|
Adding a Chart to a Slide |
|
|
16 | (1) |
|
|
17 | (1) |
|
|
18 | (2) |
|
Creating and Printing Speaker Notes |
|
|
20 | (1) |
|
Where can you go from here? |
|
|
21 | (1) |
|
|
21 | (1) |
|
|
22 | (1) |
|
PowerPoint Commands and Buttons |
|
|
23 | (1) |
|
|
24 | (1) |
|
|
25 | |
Appendix A Using Microsoft Office Help |
|
|
|
1 | (1) |
|
|
1 | (2) |
|
A.3 Displaying the Contents of a Topic |
|
|
3 | (1) |
|
A.4 Printing a Help Topic |
|
|
4 | (1) |
|
A.5 Displaying Screen Tips |
|
|
4 | (1) |
|
A.6 Where can you go from here? |
|
|
4 | |
Appendix B Functions and Keyboard Shortcuts |
|
|
|
1 | (2) |
|
|
3 | |
Appendix C Creating Customized Forms and Reports |
|
|
C.1 Creating Forms in Design View |
|
|
1 | (1) |
|
C.2 Customizing Forms in Design View |
|
|
2 | (1) |
|
C.3 Creating Reports in Design View |
|
|
3 | (2) |
|
C.4 Customizing Reports in Design View |
|
|
5 | (1) |
|
C.5 Adding Summaries to a Report |
|
|
5 | |