Microsoft Access VBA Introduction for the Complete VBA Newb

Create and organize VBA modules in Access using the Visual Basic Editor. Rename and store code in the project’s modules folder, and write procedures and functions across multiple modules.

Create a Microsoft Access VBA sub procedure in a module, insert it, name it, set it public, and run it to display a hello world message box.

learn how to call an Access VBA sub procedure by referencing its name from another procedure, optionally using call, and create a second procedure that executes the first.

Open the immediate window from the Visual Basic Editor to test and run code instantly, type single lines or call procedures to display message boxes, without building a module.

Explore built-in VBA features like message box and prebuilt functions, then learn to create your own function procedure with arguments that return values, such as a simple math function.

Create a simple math function in Access VBA, pass two numbers, return the sum, and call it from a sub procedure or test it in the immediate window.

Explore how Microsoft Access uses objects and how to talk to them with VBA. Identify tables, queries, forms, reports, macros, and modules as objects with defining characteristics.

Discover how access objects use properties, methods, and events to shape forms, reports, and data. Learn to edit design view, inspect the properties sheet, and automate actions with VBA.

Master Access objects with VBA using dot notation to reach the application and forms, then use the immediate window and bang notation to modify a form's back color with RGB.

Explore how the Access application object hosts forms and reports collections, navigate open forms and reports with dot notation, and understand the count and zero-based indexing.

Use the with statement to streamline VBA code by referencing the customer info form once, then set its detail properties, caption, and navigation to false, improving readability and efficiency.

Master referencing access objects with dot notation and the do command to open forms, navigate controls, and invoke methods and events in VBA.

Learn how VBA variables store content, from hard-coded values to user input, and display results with a message box. Create modules and declare variables using lower camel case.

Declare variables with the dim keyword, assign values, and reference them; choose a datatype such as string, integer, or boolean to improve readability and error handling.

Explore VBA variable scope and lifetime, and extend access by declaring a public global variable outside a procedure to share user input across procedures.

Learn to build branching logic in VBA using an if statement, guiding code paths from user input to access decisions with if, else, and simple message box outputs.

Explore how to use a select case statement to branch within VBA code, contrasting it with if statements, and implement age-based cases with input box handling.

Learn how to repeat code blocks in VBA using do loops, while loops, and for next loops. The tutorial demonstrates iterating through open forms in Access.

Learn how to store references to Access objects in VBA object variables, declare a form variable, and use the set keyword to reference the customer info form and manipulate properties.

Learn to use set to assign a form's recordset to a variable, open the form, loop until end, and print contact names to the immediate window.

Step into code line by line to locate errors, watch variables, and learn VBA by debugging with the immediate window and the F8 shortcut.

Learn to use breakpoints in a VBA procedure to pause execution, inspect variables, and trace branches for targeted debugging and efficient code verification.

Learn to add error handling in Access VBA by using the error object, on error goto, and a dedicated error handler to present clear user messages and exit gracefully.

Improve error handling in Access VBA by using the error object to deliver specific messages, using on error goto and select case for divide by zero and data type mismatch.

Design a navigation board form with buttons that open the orders form and the customer info form. Learn to create a single reusable procedure that powers this simple project.

Set up a blank Microsoft Access form in design view, add two command buttons, name them CND orders and CND customer info, and save the form to begin coding.

Learn where to store your VBA in Access, choosing between a universal module and object-specific code on forms, with private scope and practical setup for a navigation board.

Create a simple public sub procedure named open form to open the Orders form via the do command method, then bind this procedure to a button on the navigation board.

Learn to wire a command button on click event to open a form using a reusable vba procedure, leveraging modules and the code builder for a more dynamic navigation.

Create a single sub procedure that takes a form name as a string and opens that form, making code dynamic and highly reusable.

Create a simple Access form, name controls, and build a reusable procedure that handles multiple buttons via their on click events by passing the form name.

Congratulations on completing the Microsoft Access VBA introductory course by applying the learned concepts through practice. Keep practicing and revisit the material, and I’ll see you in other courses.