Project 1
Database (Data Entry Form, Insert Rows, Query), Spreadsheet (Insert/Copy
Formula, Chart), Word Processing (Formatting)
Project 2
Database (Data Entry Form, Query, Add Records), Spreadsheet (Insert/Copy
Formula), Word Processing (Formatting, Non-Proportional Fonts)
Project 3
Database (Data Entry Form, Query, Add/Delete Records), Spreadsheet (Insert/Copy
Formula), Word Processing (Margins, Copy, Formatting)
Project 4
Database (Data Entry Form, Query, Sort), Spreadsheet (Insert/Copy Formula),
Word Processing (Margins, Sanserif Fonts)
Project 5
Database (Data Entry Form, Query Using AND, OR), Spreadsheet (Insert/Copy
Formula), Word Processing (Margins, Headers, Serif Fonts)
Project 6
Database (Data Entry Form, Query Using AND), Spreadsheet (Insert/Copy Formula,
Charts), Word Processing (Margins, Headers)
Project 7
Database (Data Entry Form, Sort, Query Using AND, OR), Spreadsheet (Insert/Copy
Formula), Word Processing (Superscripts, Bulleted List, Margins, Headers,
Footers)
Project 8
Database (Data Entry Form, Queries, Find/Replace, Sort), Spreadsheet
(Formatting, Alignment), Word Processing (Superscripts, Bulleted List)
Project 9
Database (Data Entry Form, Query Using AND, Copy, Insert a Field), Spreadsheet
(Formatting, Alignment), Word Processing (Margins, Copy, Bullets, Formatting)
Project 10
Database (Data Entry Form, Queries), Spreadsheet (Formatting), Word Processing
(Margins,
Superscripts, Bulleted List)
Project 11
Database (Using Mathematics on Fields, Multilevel Sorting, Queries, Copy),
Spreadsheet (Inserting Rows), Word Processing (Margins, Numbered List)
Project 12
Database (Using Mathematics on Fields, Sorting, Queries), Spreadsheet
(Formatting), Word Processing (Copy, Enhance)
Project 13
Database (Index, Query), Spreadsheet (Formatting), Word Processing (Form Fields)
Project 14
Database (Index, Copying Records, Query), Spreadsheet (Formatting), Word
Processing (Form Fields)
Project 15
Database (Index, Copying Records), Spreadsheet (Formatting, Chart), Word
Processing (Form Fields)
Project 16
Database (Index, Find/Replace), Spreadsheet (Insert Rows/Columns, Formatting,
Chart), Word Processing (Importing Clip Art)
Project 17
Database (Index, Find/Replace), Spreadsheet (IF, Insert Rows, Chart), Word
Processing (Importing Clip Art, Tabulation)
Project 18
Database (Index, Find/Replace), Spreadsheet (Absolute Cell Address), Word
Processing (Importing Clip Art)
Project 19
Database (Copy, Index, Query), Spreadsheet
(Absolute Cell Address), Word Processing (Importing Clip Art, Find/Replace)
Project 20
Database (Copy, Index, Query), Spreadsheet (Absolute Cell Address), Word
Processing (Copy from a Spreadsheet)
Project 21
Database (Copy, Index, Labels), Spreadsheet (Absolute Cell Address), Processing
(Columns, Clip Art)
Project 22
Database (Design, Create, Input), Spreadsheet (Absolute Cell Address, IF with
AND, Copy), Word Processing (Columns, Clip Art)
Project 23
Database (Index, Labels), Spreadsheet (Absolute Cell Address), Word Processing
(Form Fields, Copy)
Project 24
Database (Index, Labels), Spreadsheet (Absolute Cell Address, Linking
Spreadsheets), Word Processing (Linking with a Spreadsheet)
Project 25
Database (SUM), Spreadsheet (Absolute Cell Address, IF), Word Processing
(Linking with a Spreadsheet)
Project 26
Database (Index, Labels), Spreadsheet (Absolute Cell Address, COUNTIF), Word
Processing (Using Mailmerge with a Database)
Project 27
Database (Index, Copy), Spreadsheet (LOOKUP), Word Processing (Using Mailmerge
with a Database)
Project 28
Database (Index), Spreadsheet (LOOKUP), Word Processing (Using Mailmerge with a
Database)
Project 29
Database (Labels), Spreadsheet (LOOKUP), Word Processing (Using Mailmerge with
a Database)
Project 30
Database (Index), Spreadsheet (LOOKUP), Word Processing (Using Mailmerge with a
Database)
Part 2 Concepts
Word Processing
Databases
Spreadsheets
The Internet
The Web