MS Access VBA Course (Basic to Super Advanced) - 40 hrs
Variables, Loops. Arrays, IF , Connecting Excel, Collection Loops, Functions, SQL, Dashboards- Everything covered
Updated on Jun, 2025
Language - English
Office Productivity,Microsoft,Microsoft Access
Lectures -57
Resources -21
Duration -38.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
- What is the access VBA editor window. Where do we go and write our VBA code in the MS Access database.
- Know your modules, project explorers, property windows, renaming modules, and sub routine names.
- Types of variables, and their data types like byte, integer, single, double, string, and variants.
- What happens if you give numeric values to string data type or vice versa.
- Know your overflow error and why type mismatch errors can come.
- Know the scope of a variables which means how long they exist in memory. Local Level, Module level, and public level variables.
- Learn the use of the Call keyword and how we can carry forward the variable values from one macro to another.
- What questions can be asked in your interview related to access VBA variables.
- Use of Option explicit and why it is important. It's amazing.
- How to run the VBA codes when you debug or do the testing of code.
- What is a record set and how do we define it.
- How we use recordsets with loops.
- Let us discuss loops from zero level and explore everything about them in detail. Know for next and do while loop in detail.
- Learn how to run a loop inside another loop which we call a sub-loop.
- Loop your access tables from the first row to the last row or the last row to the first row by knowing everything about loops used in recordsets.
- how to pick up values from the last record if your data has many repeated IDs. Mini project shared in this -idea taken from my live project.
- Discussion on practical projects to make you understand how loops and record sets work together. It is a complete discussion from basic to advanced level. We have covered everything for an access developer for a great beginning.
- This tutorial is meant for those who know the use of Variable in programming and how to loop through the record sets in Access VBA. If are not aware of these things then kindly first go and learn these subjects. You can enroll for series 1 which is my first series in the Access VBA training.
- In this tutorial, we are talking about the basics of Arrays – what are the arrays – why we use them, and how we use them in practical life.
- What is option base1 . What questions can be asked in your interview related to that.
- How to loop through the arrays. How to use abound and unbound functions in arrays. Why are they used and what is their advantage.
- What is credit and the need to use it. What is the preserve statement in Arrays and its advantage.
- I have shared an interesting project as well with you.
- After Arrays, we are talking about Access VBA inbuilt functions along with UDFs. (user-defined functions).
- You can create your own functions as well in VBA to make things simpler. Let us start now. Happy learning.
- We are learning the SQL syntax. How do we write select, update, delete, make the table, and insert into queries. Not just that, but also while writing the queries what important things we need to take care of. for eg, whether to use single quotes double quotes or both depending you use integer or string data type. A lot of interesting things are going on in these sessions. Enough to make you a great access user-form programmer.
- We will go and take a deep dive into access user forms where I will teach you all the important form controls like list-boxes, combo-boxes,text-box labels option buttons checkboxes. It is a complete tutorial starting from scratch. It is a long training and you will not just learn how to design form controls, what are their properties
- UserForm control events – how they run and we need to program
- many good examples are taken from real access projects to give you confidence. It's not just learning about topics but also in real life we use them.
- How to create a Login page and protect the database preventing it not to accessed by invalid users. Step by step tutorial for you.
- A real MS access reporting project which revises everything we have done so far.
- We are talking about Error Handlers – if the error comes then how we can customize them or bypass them and get the code run successfully.
- We are also talking about message boxes and input boxes- from their basics to real use in coding life.
- A most important topic is how to handle files and folders. How to get inside folders of your choice and pick the files which you can move or copy in other folders or even import in access in one table or different -different tables depending on how many files you have got.
- learn also how to run access macros in vba and also how to display file dialog – again from learning them to their real use in practical life
- how to create new folders or how to ignore them if they exist. Related to folders and files we are going to learn so much in this tutorial
- if you have any questions or need my assistance in making your projects – you are most welcome
- Learn how to work with recordsets using ADODB Library. This is the first time I am sharing the ADODB library. My all previous series were on DAO.
- Not just ADODB methodology but side side we are also making the code in DAO so that we can a good comparisons
- Talking about connection strings you go and use when you work with other ACCCESS Database which is on your computer or maybe on the server.
- Types of DAO record cursor types like dB forward only, DB snapshot only, dB dynamic etc
- Also how to set up the security set up and create a login page for users.
- How to connect access db with another database on the same system
- How to connect access db with the database which is on the server. Like SQL server or MS access etc.
- What is a connection string and where we can have it if we want to connect front end access with other databases?
- How to set up the security set up in MS Access using the bypass key.
- How to allow users to see limited data by giving them read-write only.
Goals
This course has 13 sections and every information is shared on access VBA.
It has 40 hours of amazing content in a sequence
Scope of Variables, Forms, Dashboards, and Security of a database. do cmd, Events, Error handlers
Write subloops, Fundamentals, Error descriptions
Arrays, Collection Loops, Do while, for next loops, IF statements, SQL, Forms, Early binding, late binding
Supporting files are also available for you to download with my 24*7 support
Prerequisites
Basic knowledge of the Access front part - Familiarity with Tables and Queries at least
Curriculum
Check out the detailed breakdown of what’s inside the course
VBA Editor and Variables - Deep Study
4 Lectures
-
VBA Editor and variables and data types use?
01:02:32
01:02:32
-
More on Variables – fundamentals
11:01
11:01
-
Public, module, local Variables – Scope
52:18
52:18
-
Resources
LOOPS with IF
7 Lectures
ARRAYS
3 Lectures
FUNCTIONS
4 Lectures
SQL Commands
3 Lectures
USERFORMS
9 Lectures
Error Handlers
2 Lectures
Files And Folders
6 Lectures
Collection Loops
5 Lectures
Connecting with Excel
4 Lectures
Connecting with Outlook Email
2 Lectures
ADO Library
6 Lectures
Project
2 Lectures
Instructor Details
ajay parmar
I have been teaching online from 13 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now