MICROSOFT ACCESS
Instructors
Larry DeLaruelle: Microsoft Certified Technology Specialist; database administrator, Family & Children’s Center, Inc.
Catherine Dilley: BGS, Indiana University; instructor, IU South Bend Extended Learning Services
Mastering Microsoft Access Certificate
Concentrate your efforts on learning Access, the foremost database software for individuals and small-and mid-sized companies.
Required Courses:
- Getting Started with Access— Level 1
- Moving Ahead with Access— Level 2
- Advanced Access Queries and Forms—Level 3
- Using Access Networking and Menu Systems—Level 3
- Using Visual Basic with Access—Level 4
- Organizing Your Computer Files
- Final Project
Important Information:
Total CEUs required for certificate: 4.7
A one-time, non-refundable $25 registration fee is required
Call 574-520-4261 for more information
Getting Started with Access (Level 1)
Design a database. Create and edit tables, forms, reports, and queries. Create effective input screens and professional-looking reports. Organize, sort, and select data.
6 hours; 0.6 CEU
$182
MC-3Y-4635A
Instructor: Catherine Dilley
Thurs., July 23; 9 a.m.-4 p.m.
AI001E, Management Training CenterMC-4Y-4635A [CANCELLED]
Instructor: Larry DeLaruelle
Tues./Thurs., Sept. 8 & 10; 5:30-8:30 p.m.
AI001E, Management Training CenterMC-4Y-4635B
Instructor: Catherine Dilley
Mon./Wed., Oct. 26 & 28; 2-5 p.m.
Elkhart Center A205 [Register Now]
Moving Ahead with Access (Level 2)
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.
Prerequisite: Getting Started with Access or prior experience. Call 574-520-4261 to request permission to waive the prerequisite class.
Instructor: Catherine Dilley
6 hours; 0.6 CEU
$182
MC-3Y-4636A [NEW DATE]
Thurs., Aug. 20; 9 a.m.-4 p.m.
AI001E, Management Training CenterMC-4Y-4636B
Mon., Nov. 16; 9 a.m.-4 p.m.
Elkhart Center A205 [Register Now]
Using Access Networking and Menu Systems (Level 3)
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 waive the prerequisite class.
Instructor: Larry DeLaruelle
6 hours; 0.6 CEU
MC-4Y-4646A
2 Thurs., Nov. 5 & 12; 5:30-8:30 p.m.
AI001E, Management Training Center
$182 [Register Now]
Advanced Access Queries and Forms (Level 3)
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 waive the prerequisite class.
Instructor: Larry DeLaruelle
6 hours; 0.6 CEU
MC-4Y-4645A [CANCELLED]
2 Thurs., Oct. 8 & 15; 5:30-8:30 p.m.
AI001E, Management Training Center
$182
Using Visual Basic with Access
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 waive the prerequisite class.
Instructor: Larry DeLaruelle
7 hours; 0.7 CEU
MC-4Y-4138A
Tues./Thurs.,Dec. 15 & 17; 5:30-9 p.m. AI001E, Management Training Center
$180 [Register Now]
