|
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!
--------------------------------
|
|
"I liked that the system
is designed to record my progress. Despite many interruptions,
I was able to pick up where I left off."
-Matthew L.
|
| |
|
 |
|
 |
| Home
> Online Courses >
Business
Skills Package >
Microsoft Access 2000 |
 |
|
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:
3/6 Months
This course is included
in the Business Office Skills Package
Cost: $99 for 3 Months Access or $149 for 6 Months Access
Summary:
This series is designed to help users prepare for Microsoft
Access 2000 MOS certification. It shows how to create,
plan, and modify databases and tables in Access 2000.
It also covers sorting and filtering, creating queries,
forms and reports, and advanced tasks such as saving
Access objects as Web pages, importing data, and adding
hyperlinks.
Audience:
This series is for anyone who wants to get the most
out of using Access 2000.
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
This course is included
in the Business Office Skills Package
Cost: $99 for 3 Months Access or $149 for 6 Months Access
width="140" height="20" alt="" border="0">
Course Outline and Objectives: |
|
 |
| Creating
Databases |
 |
| •
Identify appropriate input and output
for a database |
|
| •
Plan a database |
|
| •
Create a database with and without the
wizard |
|
| •
Select and print database objects |
|
|
 |
|
|
|
| Relationships
and Queries |
|
| •
Define table relationships |
|
| •
Create calculated fields |
|
| •
Display related records |
|
| •
Specify query criteria |
|
| •
Create and modify multi-table queries
|
|
|
|
|
|
|
| Building
Tables |
|
•
Explain the structure of a table, the
data types used in the table, and the
function of primary keys
|
|
| •
Create a table using the wizard |
|
•
Enter records into the table through
a form or datasheet
|
|
| •
Understanding Table Structure |
|
|
|
|
|
|
| Building
Forms |
|
| •
Create a form |
|
| •
Edit the form in design view |
|
| •
Add and modify controls |
|
•
Create and use calculated controls
|
|
|
|
|
|
|
| Modifying
Tables |
|
| •
Insert and delete records and fields
|
|
| •
Modify the appearance and structure
of the table in Design View |
|
•
Change the size, format, and default
value of fields
|
|
•
Use the Lookup and Input Mask wizards
|
|
|
|
|
|
|
| Producing
Reports |
|
| •
Describe the components of reports |
|
| •
Create a report using the Report Wizard
|
|
| •
Edit the report in design view |
|
| •
Create and use calculated controls in
a report |
|
|
|
|
|
|
| Sorting
and Filtering |
|
| •
Sort records |
|
| •
Create advanced sorts |
|
| •
Search for records |
|
| •
Apply and remove filters |
|
|
|
|
|
|
| Advanced
Tasks |
|
| •
Import data into a table |
|
| •
Save an Access object as a Web page |
|
| •
Add hyperlinks to an Access object |
|
| •
Back up, restore, and compact a database
|
|
|
|
|
|
|
|
|
|
|
| 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! |
|
|
|
