|
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 2002 |
 |
|
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 shows how to create, plan, and modify databases
and database objects in Access 2002. Courses cover the
following topics: understanding relational databases,
creating and planning databases, selecting and printing
database objects, creating tables, entering records,
modifying tables and field properties, using advanced
sorts, finding records, applying and removing filters,
establishing and managing table relationships, specifying
query criteria, creating calculated fields, running
multi-table queries, creating forms and reports, implementing
standard and calculated controls in both forms and reports,
importing data, saving Access objects as Web pages,
and performing administrative tasks. This series is
procedure focused and assumes that the student is familiar
with the mechanics of getting around in a Microsoft
Office application.
Audience:
This series is for anyone who wants to get the most
out of using Access 2002.
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 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! |
|
|
|
