|
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, see Computers 101.
2.5 hours/.25 CEU.
$59 (includes materials and parking; no discount) |
|
|
1W-4635A: |
Sorry, this class is no longer available. See Section B below
Mon. & Wed., Feb. 25 & 27, 5:30-8:30 p.m. |
Click
here to Enroll Online |
|
|
Room: AI001E, CE Computer Lab |
|
|
1W-4635B:
|
NEW DATE - Tuesday, April 22, 9 a.m. - 4 p.m. |
Click
here to Enroll Online |
|
ELKHART |
Site: IU South Bend Elkhart Center, A205 |
|
|
Hours: 6 hours/.6 CEU
Instructors: Catherine Dilley, see Computers 101 and
Larry DeLaruelle,
database
administrator, Family & Children's Center,
Inc., experienced IS
manager.
Fee:
$175 (includes materials and parking)
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28 |
|
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-4636A:
|
Sorry, this class is no longer available. See Section B below
Mon. & Wed., Mar. 3 & 5,
5:30-8:30 p.m.
|
Click
here to Enroll Online |
|
|
Room: AI001E, CE Computer Lab |
|
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 |
|
|
Hours: 6 hours/.6 CEU
Instructors: Catherine Dilley, see Computers 101 and
Larry DeLaruelle, see Getting Started with Access
Fee:
$175 (includes materials and parking)
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28 |
|
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-4168 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)
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28 |
Click
here to Enroll Online |
|
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-4168 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)
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28 |
Click
here to Enroll Online |
|
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-4168 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)
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28 |
Click
here to Enroll Online |
More
and more jobs are demanding that workers become increasingly
familiar with and comfortable using a wide range of computer
applications.