|
| |
| Computer Course |
Topics Covered |
| MS Word (2 Day Workshop) |
Day 1
Day 2
|
| MS PowerPoint (2 Day Workshop) |
Day 1 BACKGROUNDS>>
 | Choosing a
background design and applying it to all slides. |
|
| Choosing
colors for backgrounds and applying to specific slides. |
|
| Background
fill effects. |
|
| Using pictures
as background.] |
INSERTING>>
|
|
Clip-Art |
|
|
Pictures |
|
|
Pictures from the internet or from a
scanner. |
|
|
Word Art |
|
|
Insert auto shapes and other items |
|
|
Text boxes |
|
|
Diagrams |
SHOW>>
|
|
Setting up the Show |
|
|
Slide transitions |
Day 2
Review Power Point Basics
The difference between linear and
non-linear power point presentations
NONLINEAR ATTRIBUTES>>
|
|
Action buttons |
|
|
Linking to different slides |
|
|
Back buttons |
|
|
Pictures as Links |
|
|
Text as Links |
|
| MS Excel (2 Day Workshop) |
Day 1
|
| Create worksheets, |
|
| Edit, Format, and Arrange |
|
| Quickly organize data using filter and sort
|
|
| Merge
multiple spreadsheets |
|
| Basic calculations |
|
| Budgeting (Predicting) using Excel |
Day 2
|
| Charts,
and graphs |
|
| Integrate Microsoft Excel with
other Microsoft Office programs |
|
| Simplify calculations using formulas,
 | AutoCalculate, Subtotal, and other functions |
|
|
| Special & fun features of Excel |
|
| MS Access (3 Day Workshop) |
Day 1
|
|
Become familiar with screen and toolbar
layouts |
|
|
Use the Microsoft
Office Assistant |
|
|
Determine appropriate
data inputs/outputs for your database |
|
|
Building and Modifying Tables |
|
|
Field properties
|
|
|
Use multiple data
types |
|
|
Switch between object
views |
|
|
Primary key
|
|
|
Adding/ Editing/
Deleting records |
|
|
Resizing rows and
columns |
|
|
Freezing columns
|
|
|
Hiding columns
|
|
|
Finding data in a
table |
|
|
Replace
|
|
|
Check spelling and
AutoCorrect |
|
|
Print a datasheet
|
|
|
Declaring table
relationships |
Day 2
|
|
Enter records using a
datasheet |
|
|
Enter records using a
form |
|
|
Delete records from a
table |
|
|
Find a record
|
|
|
Sort records
|
|
|
Apply and remove
filters (filter by form and filter by selection) |
|
|
Specify criteria in a
query |
|
|
Display related
records in a sub-datasheet |
|
|
Print database
objects (tables, forms, reports, and queries) |
|
|
Introduction to
queries |
|
|
Create a query in
design view |
|
|
Delete a query
|
Day 3
|
|
Building and Modifying Forms |
|
|
Adding records using a
form |
|
|
Editing forms
|
|
|
Modify Format
Properties (font, style, font size, color, caption, etc.) of controls
|
|
|
Use form sections
(headers, footers, and detail) |
|
|
Create a calculated
field |
|
|
Producing Reports |
|
|
Create a report with
the Report Wizard |
|
|
Preview and print a
report |
|
| Email (1 Day Workshop) |
|
| Basic Computer Maintenance (1 Day
Workshop) |
|
| Questions? |
email: Joy Rousseau
joy@arp.sprnet.org
|
BACK
| |
|