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.  

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

Upcoming Workshops

Have a question? Call us at 505.277.2525 or e-mail our team:  cpd@unm.edu