Class Modules, Encapsulation, Properties & Methods

Welcome

Welcome to Microsoft Access Developer Level 50, brought to you by Access Learning Zone. I'm your instructor, Richard Rost.

This course introduces class modules in Microsoft Access, starting with user-defined types and moving into encapsulation, property management, and input validation. You will learn to create calculated and read-only properties to centralize business logic.

We will also add methods and behavior to classes, enforce business rules, and work with real-world customer data from tables, bringing everything together into a practical application.

Resources

• Full Course Lessons Page
• Course Topic Outline

Topics Covered

In Lesson 1, we will review how to use user-defined types (UDTs) in VBA, review their structure and limitations, and demonstrate how to create custom functions that work with UDTs, such as toggling properties and handling variable scope within forms. You will also learn why UDTs may fall short compared to class modules, setting the stage for building your first class module in the next lesson.

In Lesson 2, we will learn how to create your first class module, define public variables, instantiate the class, use the Set and New keywords, compare class modules to user-defined types, add methods directly to the class, and explain the importance of encapsulation, setting you up for more advanced concepts in the next lesson.

In Lesson 3, we will learn how to use encapsulation in class modules to protect and manage your data, set up private variables, implement property Get and Let procedures for controlled data access and validation, and apply a clear naming convention to avoid confusion in your code.

In Lesson 4, we will learn how to add calculated properties to your class modules, including creating read-only properties that return values like years active and full name based on other data in the class. We will also cover making a dynamic customer status property and demonstrate how calculated properties can simplify your code and keep everything organized inside your class.

In Lesson 5, we will learn how to add methods and behaviors to your class modules, including creating a deactivate method, enforcing business rules for actions like deactivation, using private helper functions, and keeping your form logic clean by centralizing code and formatting within the class itself.

In Lesson 6, we will learn how to build a practical example using classes by looping through all the customers in a table, assigning each one into a class, and displaying their name and status with class functions. You will learn how to use recordsets alongside class logic, handle property read/write issues, and expose specific fields with property let procedures for greater control over your data.

Enroll Today

Enroll now so that you watch these lessons, learn with us, post questions, and more!

Questions?

Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.

Keywords

microsoft access, access 2016, access 2019, access 2021, access 365, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, class modules, user defined types, encapsulation, property get, property let, calculated properties, read-only properties, methods, behavior, customer records, object oriented access, access vba classes, form logic, business rules