Access Programs

In partnership with UNM Continuing Education, we are offering focused, professional skill development programs. Building and sharpening software skills, enhances your leadership and management aptitudes.  

ce-logo.png

Access: Beginning

Understand the basic concepts of database use and how to most effectively design your database using Microsoft Access. Design basic tables and add, edit, locate, sort, filter and delete data. Set field properties, work with input masks and set validation rules. Learn to design and apply queries and reports to make it easier to accomplish everyday database tasks. In addition, get an introduction to basic forms. Prerequisites: Basic computer knowledge.

Program Information

Dates: New dates coming soon
Time: TBD
Location: Live Online
Cost: $259


 

Course Number: 52181-019
Contact Hours: 9.0
CEUs: 0.9 CEUs
Drop Request Deadline: Mar 05, 2021
Transfer Request Deadline: Mar 01, 2021
Withdrawal Request Deadline: Mar 08, 2021
Instructor: Rick Berg

 

Access: Intermediate

Go beyond the basics using queries to answer specific questions and develop summaries with Access. Create and enhance custom forms, a main form with sub-forms, and custom reports. In addition, learn how to identify and create relationships. Prerequisites - Access: Beginning or equivalent experience.

Program Information

Dates: New dates coming soon
Time: TBD
Location: Live Online
Cost: $259


 

Course Number: 52182-012
Contact Hours: 9.0
CEUs: 0.9 CEUs
Drop Request Deadline: Mar 12, 2021
Transfer Request Deadline: Mar 12, 2021
Withdrawal Request Deadline: Mar 15, 2021
Instructor: Rick Berg

 

Access: Advanced

Make Access do more for you through advanced queries, including crosstabs and parameters. Learn to write SQL statements and attach SQL queries to controls. Create, run, and modify macros, attach macros to events, and create macros that will provide user interaction or data transfer. Import, export and link objects, and work with hyperlinked fields. Prerequisite: Access: Intermediate.

Program Information

Dates: New dates coming soon
Time: TBD
Location: Live Online
Cost: $259


 

Course Number: 52183-009
Contact Hours: 9.0
CEUs: 0.9 CEUs
Drop Request Deadline: Mar 19, 2021
Transfer Request Deadline: Mar 19, 2021
Withdrawal Request Deadline: Mar 22, 2021
Instructor: Rick Berg

 

Access: Relational Database Design

Solve difficult design issues with database design analysis. Using practical examples, identify database tasks, collect data needed to support tasks, and map the data to tables. Apply rules of table design, resulting in efficient tables that take full advantage of relational capabilities. Determine key fields and relationships, learn about normalization and solve complex many to many" database relationships. Prerequisite: Access: Beginning or database experience.

Program Information

Dates: New dates coming soon
Time: TBD
Location: Live Online
Cost: $295

 

Course Number: 52190-007
Contact Hours: 9.0
CEUs: 0.9 CEUs
Drop Request Deadline: Apr 02, 2021
Transfer Request Deadline: Apr 02, 2021
Withdrawal Request Deadline: Apr 05, 2021
Instructor: Rick Berg

 

Access: Programming with Visual Basic for Applications

Find out what professional Access developers know to create customized applications using Visual Basic for Applications (VBA), Access's programming language. Get input from the user for queries and reports, use loops and if statements, automate the program with command buttons, respond to user-generated events such as entering bad data, and create screens that call up related screens with a mouse click. Additional Information: Required Text: Access VBA Programming For Dummies (any edition from 2007 onward). The book may be purchased at any book reseller. Prerequisites: Advanced Access

Program Information

Dates: New dates coming soon
Time: TBD
Location: Live Online
Cost: $495

Course Number: 52195-003
Contact Hours:18.0
CEUs: 1.8 CEUs
Drop Request Deadline: Apr 09, 2021
Transfer Request Deadline: Apr 09, 2021
Withdrawal Request Deadline: Apr 12, 2021

Upcoming Programs

Practical Project Management

Tuesdays and Thursdays
June 8 - August 12, 2021

6 - 8 p.m.

Fundamentals of Human Resources

Mondays and Wednesdays
June 7-23, 2021

6-8 p.m.


Mediation Certification

Saturdays
June 5 - July 24, 2021
9 a.m. - 3:30 p.m.

Essentials for Managers

Mondays
Sep. 13 - Nov. 15, 2021
6-9 p.m.



SHRM Exam Prep

Thursdays
Sep. 2 - Nov. 18, 2021
6-9 p.m.


Women's Leadership Development

Wednesdays
Sep. 15 - Nov. 3, 2021
6-8 p.m.



Sales Strategies for the 21st Centry

Tuesdays
Sep. 21 - Nov. 9, 2021
6-9 p.m.



Upcoming Workshops

Leading through Uncertainty to Clarity

Tuesdays and Thursdays
June 8 - 17, 2021
6-8 p.m.