|
Approach
Our
Microsoft Access curriculum is custom designed to assist end-users
in getting up to speed on Access. It is assumed students are looking
to acquire skills readily applied in the workplace.
Courses
are not geared towards certification tests, although they do provide
a good background for many topics. Some topics such as queries which
are key to effective data retrieval and manipulation are treated in
more depth, some others less.
Prerequisites
All
courses require some background in using Microsoft Office. Students
should also be comfortable navigating the Windows interface. This is
due to the fast pace and intensive hands-on nature of the courses.
If
you or members of your group do not have this background check with
us for recommendations.
Entry
Points
AIA101/AIN100
- The two basic starting courses are AIN100 and AIA101. Both are
similar but AIN100 is a little slower paced. It also provides a bit
more coverage on introductory material such as table design,
manipulating the datasheet, using filters, etc. If your group is a
larger one, say 7 or 8 students, then AIN100 is probably the better
choice. If your group has a strong background and time is of the
essence then go with AIA101.
AIN101T
- This can be an alternate entry point if you or your group want to
go directly to a specialized module such as queries or reports and
forms. It provides the background in table design, sharing external
data, working with the datasheet, etc. It may be skipped if you or
your group already have this background.
If
you are short on time just take the second MS Access module,
skipping database design with Visio.
Notes
to open enrollment students:
1)
AIN101T may not be separately scheduled. Just take the first morning
session of AIN100.
2)
AIN100A and AIN100B are two one-day courses equivalent to the AIN100
two-day course. |
Database
Design - Those expecting to design their own database for
departmental or company use should consider taking the DBD201
Database Design course first. The other objects in your database such
as the forms and reports will then be much easier to build.
On
the other hand, if you will be working exclusively with small
personal databases, or an existing database you can probably pick up
what you need to know from our regular courses and some reading along
the way.
Suggested
Curricula
Here
are some suggested course sequences:
1)
AIA101 or AIN100 - One of the two standard classes.
2)
DBD201/AIA101/AIN104 - If you will be building a database
application for departmental or company use.
3)
AIA101/AIN102 - If you will be doing extensive querying of existing
databases. Possibly using Access as a "front-end" to an
enterprise database such as Oracle or SQL Server.
Please
note multi-course discounts apply to classes beyond the first.
Courses
for Programmers
Currently
most of our Access courses are geared towards end users. VBA is an
exception, being better suited to those familiar with programming
concepts (variables, etc.). We are also working on more technical
versions of our standard classes. Call if interested. |
