|
Approach
Our
Microsoft Access curriculum is custom designed to assist 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 students:
1)
AIN100T is two sessions with the first design and a little Visio.
Building the Access tables is done in the second session. If you
like, you can purchase the second session only.
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. Good choice for
groups as well as the individual student.
2)
AIA101 or AN100 + 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. Consider taking SQL200A, too, after a while. It will sharpen
your query skills to include SQL. Buy them as a package and get the
multi-course discount.
3)AIN100T/AIN102/AIN104/AMP110
- Emerging as a very popularr sequence. Covers all the basic and
intermediate MS Access material but more in depth. Can be readily
taken on the the 4 class passport.
Courses
for Programmers
Currently
most of our Access courses are geared towards analysts and end
users. VBA can be 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. |
