|
|
|
|
|
|
|
|
Synopsis:
Accelerated Introduction to Microsoft Access course for experienced
Microsoft Office users. Corresponds roughly to material required for
MOUS proficient level plus some additional material. Covers tables,
external data, queries, forms, reports and macros. Students will
create a working database application during this intensive, hands-on
course. This database can be tailored to the needs of custom groups
or private training students. |
|
Formats:
Custom group at your facility or ours, private training, and open
enrollment in San Juan Capistrano. Classes begin at 9:00 AM unless
otherwise arranged. |
|
References:
Please see our Microsoft Access Book List
for recommended books. None are required for class, but we do
recommend purchasing one or two for use afterwards. |
|
Group
Discounts: Yes
- see FAQ's |
Group
Registration:
See
Price List |
|
|
|
- Session
I:
MS
Access Tables and Queries.
- Creating
an MS Access database
- Designing
tables
- Exporting
tables to Excel and text files
- Importing
files
- Creating
simple and multi-table queries
- Calculated
fields and concatenation
- Summary
and parameter queries
- Using
the expression builder
-
|
4 hours |
- Session
II:
MS
Access Reports and Forms.
- Creating
reports and subreports.
- Formatting
your report.
- Adding
graphics.
- Creating
forms and subforms.
- Unbound
(report criteria selection) forms
- Using
the builders and wizards.
-
|
4 hours |
- Session
III:
Automating
Tasks.
- Action
queries.
- Macros
- Macro
groups
- Conditional
macros
- Switchboards
-
|
2 hours |
Prerequisites:
Familiarity with Windows and MS Office in general. No prior
experience with Access is assumed. Try the interactive Windows
Pre-requisite Mini-test if you like. We also have an on-line Microsoft
Access Practice Test which you can take before and after your
class to measure your progress.
|
|
Related Courses:
AIN100 Introduction
to Microsoft Access is very similar but with session 1 expanded
to two 3 hour sessions taught at a slightly slower pace. It also
provides a bit more coverage on the datasheet and queries. It is
probably a better course for less experienced users. You may also
want to consider taking DBD201 Introduction
to Database Design and AIN102 Microsoft
Access Queries. (Note: when you purchase two or more classes
at once you
get a 15% package discount!).
|
|
Materials:
Students will be provided a copy of all exercise files. They will
also receive a binder for note-taking with a printout of the slides
used for their class.
|
|
Scheduling:
Each session above may be customized and scheduled as desired for
group and private classes. See below for Open Enrollment.
|
|
Location:
Group classes are normally taught at your facilities. We do,
however, offer a wide range of alternatives, including our own
training rooms. Please see FAQ's
for details. We also travel beyond Southern California.
Open
enrollment classes are taught in our facilities in San Juan
Capistrano, Orange County, close to shopping, fine dining and local
attractions (map
and directions). |
|
|
|
|
Check our calendar of Open Enrollment Classes. (Note: custom group
classes and private training scheduled by arrangement. If you do not
see the Microsoft Access class you are looking for at a convenient
time just contact us). Classes
begin at 9:00AM unless
otherwise arranged.
|
Related Services |
|
Need help with
a project? We also provide Microsoft
Access programming and consulting services to help you get off to
a quick start. Special pricing for in-office consulting. Please
contact programming for more information. |
|
|
|
