Skip to main site navigation
Skip to main content
Switch to text-only view
Switch to default view

MICROSOFT ACCESS

Instructor

  • Larry DeLaruelle | Microsoft Certified Technology Specialist; former database administrator

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

MC-4D-4635A
Wed. | Sept. 10 | 9 a.m.-4 p.m.
South Bend     [online registration available soon | email for information]    


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.

6 hours | 0.6 CEU

MC-4D-4636A  
Wed. | Oct. 22 | 9 a.m.-4 p.m.
South Bend    [online registration available soon | email for information]          


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.

6 hours | 0.6 CEU
$182      

MC-1C-4645A
Wed. | May 14 | 9 a.m.-4 p.m.
South Bend          [register online]

MC-4D-4645A  
Wed. | Nov. 12 | 9 a.m.-4 p.m.
South Bend    [online registration available soon | email for information]