|
Transition to
Access 2007
Having trouble finding your familiar commands in
the new Access 2007? We can help in this hands-on class. Understand the
new Ribbon Bar and command buttons. Put back the toolbar buttons you
love. See the changes in Access features such as table and report
creation, grouping, filtering and sorting. Become familiar with new
features such as field templates, report and layout views, multiple
value fields, and an interactive calendar.
Note: Class designed for experienced
Access users. New users see Getting Started with Access.
Instructor: Catherine Dilley, B.G.S., Indiana University;
personal computer manager and instructor, IU South Bend
2.5 hours/.25 CEU.
$59 (includes materials and parking; no discount) |
|
|
2W-4635A: |
Friday, June 13, 9 a.m. - 4
p.m. |
Click here to Enroll Online |
|
|
Room:
AI001E, CE Computer Lab |
|
3X-4635B:
|
Tues. & Thurs., July 22 & 24, 5:30-8:30 p.m. |
Click here to Enroll Online |
|
|
Room: AI001E, CE Computer
Lab |
|
4X-4635C: |
Wed., Sept. 17, 9 a.m.
- 4 p.m. |
Click here to Enroll Online |
|
|
Room: AI001E, CE Computer
Lab |
|
|
4X-4635D: |
Mon. & Wed., Oct. 20 & 22, 5:30-8:30 p.m. |
Click here to Enroll Online |
|
|
Room: AI001E, CE Computer
Lab |
|
|
|
Hours: 6 hours/.6 CEU
Instructors: Larry DeLaruelle,
database
administrator, Family & Children's Center,
Inc., experienced IS
manager and Staff
Fee:
$175 (includes materials and parking)
Early Bird Special:
Enroll by May 15 to receive a 10% discount on classes that begin after
June 1
Enroll by August 15 to receive a 10% discount on classes that begin
after September 1
Classes marked "no discount" do not apply. |
|
Level 2
Moving Ahead With Access
Expand your knowledge of Access and gain more control over your data.
|
|
|
TOPICS:
• Validate and
restrict data, including using key fields
• Add calculations, groups and sorting to reports
• Use mailing labels
• Design a relational database
• Establish links between tables
• Combine tables in reports, queries and forms
|
"Very practical. Tailor made for
the working professional."
Saurabh
Pathak
Director, Special Projects
FM Stone Commercial
Getting Started with Access
|
|
Prerequisite:
Getting Started with Access- Level 1
or prior
experience.
Call 574-520-4261 to request permission to skip the prerequisite class. |
|
1W-4636B:
|
NEW DATE Friday, May 2, 9
a.m. - 4 p.m. |
Click here to Enroll Online |
|
ELKHART |
Site: IU South Bend
Elkhart Center, A205 |
|
2W-4636A:
|
Friday, June 27, 9 a.m. -
4 p.m. |
Click
here to Enroll Online |
|
ELKHART |
Site: IU South Bend
Elkhart Center, A205 |
|
3X-4636B:
|
Tues. & Thurs, July 29 & 31, 5:30
- 8:30 p.m. |
Click
here to Enroll Online |
|
|
Site: IU South Bend
Elkhart Center, A205 |
|
4X-4636C:
|
Wednesday, Sept. 24 9 a.m.
- 4 p.m. |
Click
here to Enroll Online |
|
|
Site: IU South Bend
Elkhart Center, A205 |
|
4X-4636D:
|
Mon. & Wed., Oct. 27 &29,
5:30 - 8:30 p.m. |
Click
here to Enroll Online |
|
|
Site: IU South Bend
Elkhart Center, A205 |
|
|
Hours: 6 hours/.6 CEU
Instructors: Larry DeLaruelle, see Getting Started with Access ,
and Staff
Fee:
$175 (includes materials and parking)
Early Bird
Special: Enroll
by May 15 to receive a 10% discount on classes that begin after June 1
Enroll by August 15 to receive a 10% discount on classes that begin after
September 1
Classes marked "no discount" do not apply. |
|
Level 3
Advanced Access Queries and
Forms
TOPICS:
Queries:
• Learn how and why to use
Append, Delete, Update, Make Table and Crosstab queries
• Use complex queries
and user- defined functions
Forms:
• Create complex forms,
subforms and a process for adding new lookup values
• Control how users enter
information
• Use Query by Form to
create a dynamic user interface for report generation.
Prerequisite:
Moving Ahead with
Access or
equivalent experience. Call 574-520-4261 to request permission to skip
this class.
|
|
1W-4645A: |
Mon. & Wed., May 5 & 7, 5:30-8:30
p.m.,
6 hours/.6 CEU
Room: AI001E, CE Computer Lab
Instructor: Larry DeLaruelle,
see Getting Started with Access
Fee:
$175 (includes materials and parking) |
Click here to Enroll Online |
|
Fall Class |
Coming in November |
|
Level 3
Using Access
Networking and Menu Systems
TOPICS:
• Allow multiple users to simultaneously add and
edit Access data
• Design user groups
• Require user ID’s and passwords and assign
permission levels
• Create an Access menu system with push buttons,
check boxes, drop-down lists and easy-to-use forms and reports
• Set a security interface and record locking
options to prevent data loss
Prerequisite:
Moving
Ahead with Access
or equivalent
experience. Call 574-520-4261 to request permission to skip this class.
|
What did you like best about the program?
"Information was easy to
understand. Good demonstrations."
Robert A. Peters
Access Networking and Security
|
|
1W-4646A:
|
Mon. & Wed., May 12 & 14,
5:30-8:30 p.m.
6 hours/.6 CEU
Room: AI001E, CE Computer Lab
Instructor: Larry DeLaruelle,
see Getting Started with Access
Fee:
$175 (includes materials and parking) |
Click here to Enroll Online |
|
Fall Class |
Coming in November |
|
Level 4
Using Visual Basic with Access
TOPICS
• Create and test functions and procedures
• Create intelligent navigation buttons
• Control user access to data
• Create references to forms and controls
• Use command buttons to direct actions
• Error trapping. Includes a brief introduction to
Structured Query Language (SQL)
Prerequisite:
Either Level 3 Access
class or equivalent experience. Call 574-520-4261 to request permission
to skip this class
. |
What did you like best
about the program?
"I learned
many things in this class that I was unaware you could do —great!!!"
Susan Hampton
Using Visual Basic with Access
|
|
1W-4138A:
|
Mon. & Wed., May 19 & 21, 5:30-9
p.m.
7 hours/.7 CEUs;
Room: AI001E, CE Computer
Lab
Instructor: Larry DeLaruelle,
see Getting Started with Access
Fee:
$185 (includes materials and parking) |
Click here to Enroll Online |
|
Fall Class |
Coming in November |
