|
Your Satisfaction
is Guaranteed! If
you are not completely satisfied after your first
week (7 days) of training, we will refund your money
- No questions asked!
-------------------------------------
|
All of our computer training courses
are approved for CEU's (Continuing Education Units Credit)
through Otterbein College.
--------------------------------
|
|
Expert
Mentoring -
Live Chat 24 hours a day, 7 days a week |
|
Instant Mentoring provides 24/7 support while you are
enrolled in our online courses.
Our experts can clarify concepts, fine-tune solutions,
confirm a process, or simply provide assurance that
you are on the right track.
Instant Mentoring helps to ensure understanding and
synthesis of any of our online courses.
--------------------------------
|
 |
Certificate of
Completion |
When you have scored 80% or better
on the actual course, you will have the opportunity
to print out a certificate of completion.
If you would like to become a Microsoft Office Specialist
(MOS), our courses will help you prepare for the MOS
exams.
--------------------------------
|
 |
Smart-Tips
Weekly
e-Newsletter |
When you enroll,
you will also receive our weekly "Smart Tips"
E-Newsletter, which is designed
to update your skills even faster!
It's jam-packed with quick tips, short-cuts,
and timesaving guide-lines so you'll become more efficient
and more productive faster than you would have imagined!
--------------------------------
|
|
"By the way, I am very pleased
with the on-line courses you offer. I also gave a gift
subscription to a nephew, so that he could take some
courses on-line."
- Kris A.
|
| |
|
 |
|
 |
| Home
> Online Courses >
Microsoft
Access 2003 |
 |
|
Estimated time to Complete:
22 hours
Continuing Education Units:
Yes
Self Assessment Tests:
Yes
24 / 7 Mentoring Service:
Optional
Training Method:
Online, Self-Paced
Subscription Term:
8 Weeks
Cost: $59 >>
Enroll Now
Summary:
The Access 2003 series of courses starts off with an
overview of both database concepts in general and Access
in particular. Learners then find out how to design,
build, and use Access tables. Further topics include
using queries, find, filter, and sort to unearth answers
from data. Learners finally move on to the Access report
system and delve into wizards, timesaving tips, and
even a bit of programming.
Audience:
This series is for anyone who wants to get the most
out of using Access 2003.
Features:
- Exercises that allow users to practice the application
- Files containing the text of the exercises
- Simulations that allow users to practice course
skills, even if they don't have access to the application
- Glossary
- Skill Assessment Tests
Course Outline:
|
|
 |
| Introduction
to Access |
 |
| •
Start Access |
|
| •
Modify reporting results |
|
| •
Save, close and back up a database |
|
| •
Use the toolbar and menus |
|
|
 |
|
|
|
| Advanced
Queries and Calculations |
|
| •
Use Boolean operators in queries |
|
| •
Create advanced queries and calculations
|
|
| •
Replace, delete, and update data |
|
| •Performing
complex calculations |
|
| •
Using the expression builder |
|
|
|
|
|
|
| Designing
and Building Tables |
|
| •
Build a simple database |
|
| •
Create and open a table |
|
| •
Set up a primary key |
|
| •
Build relationships between tables |
|
| •Create
an index |
|
| •Add,
modify and delete records |
|
|
|
|
|
|
| Access
Report System |
|
| •
Use AutoReport |
|
| •
Print reports and labels |
|
| •
Use the report wizard |
|
| •
Modify the report printing features
|
|
|
|
|
|
|
| Enhanced
Tables and Datasheets |
|
| •Format
a table |
|
| •
Use masks and validations |
|
| •
Work with columns and rows |
|
| •
Change fonts on the datasheet |
|
| •
Add and remove table fields |
|
•
Change field names
|
|
|
|
|
|
|
| The
Internet, Forms, and the Analyzer |
|
| •
Build and use hyperlinks |
|
| •
Publish Access data to the Web |
|
| •
Build a form with the AutoForm Wizard |
|
•
Use the Table Analyzer
|
|
|
|
|
|
|
| Searches
and Queries |
|
| •
Sort and filter records in a database
|
|
| •
Build a simple query |
|
| •
Set up multiple-table queries |
|
| •
Build a multiple-table query by hand |
|
|
|
|
|
|
|
|
|
|
 |
|
| And, with all our online courses, your Satisfaction
is Guaranteed! If you are not completely satisfied after
your first week (7 days) of training, we will refund your
money - No questions asked! |
|
|
|
