MS Access VBA (Basic to Super Advance - 40 hrs Course)

4.4 ★★★★ ★

MS Access VBA (Basic to Super Advance - 40 hrs Course)

Name: MS Access VBA (Basic to Super Advance - 40 hrs Course)
Rating: 4.4 (236 reviews)
Author: ajay parmar

Variables.Recordsets , Loops. Arrays, IF condtions, Connecting Excel, Collection Loops, Functions, SQL, Forms, Dashbaords, ADO, DAO - Everything covered

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Ajay Parmar

category icon Development,Programming Languages,Access VBA

Lectures -57

Resources -21

Duration -38.5 hours

4.4 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

What is access vba editor window. Where do we go and write our vba code in ms access database.
Know your modules, project explorers , property windows, renaming modules and sub routine names.
Types of variables, 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 over flow error and why type mismatch error can come.
Know scope of a variables which means how long they exist in memory. Local Level, Module level and public level variables.
Learn the use of 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. Its 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 loop inside another loop which we call it as sub loops.
Loop your access tables from first row to last row or last row to first row by knowing everything about loops used in recordsets.
how to pick up values from 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 advance level. We have covered everything for a access developer for a great beginning.
This tutorial is meant for those who knows 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 lbound and ubound functions in arrays. Why are they used and what is their advantage.
What is redim and need of using it. What is 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 it now. Happy learning.
We are learning the SQL syntax’s . How do we write select ,update,delete ,make table, insert into queries. Not just that , but also while writing the queries what important things we need to take care of . for eg weather to use single quotes or double quotes or both depending you using interger or string data type. 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-box,text-box labels option buttons check box . It is a complete tutorial starting from scratch. Its a long training and you will not just learn the how to design form controls , what are their properties
UserForm control events – how they run and we need to program
many good examples taken from real access projects to give you a confidence.its not jsut a learning about topics but also in real life we use them.
How to create Login page and protect the database preventing it not to access 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 error comes then how we can customize them or by pass them and get code run successfully.
We are also talking about message boxes and input boxes- from their basics to real use in coding life.
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 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 my first time I am sharing the ADODB library. My all previous series were on DAO.
Not just ADODB methodology but side by side we are also making the code in DAO so that we can a good comparisons
Talking about connections strings you go and use when you work with other ACCCESS Database which is on your computer or may be on server.
Types of DAO recordset cursor types like dbforward only, dbsnapshot only, dbdynamic 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 database which is on 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 by pass key.
How to allow users to see limited data by giving them read-write only.

Goals

What will you learn in this course:

This course has 13 sections and every information is shared on access VBA.
It has 40 hours amazing content in a sequence
Scope of Variables, Forms, Dashboards, 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
Supporing files are also available for you to download with my 24*7 support

Prerequisites

What are the prerequisites for this course?

Basic knowledge of Access front part - Familiarity with Tables and Queries atleast

MS Access VBA (Basic to Super Advance - 40 hrs Course)

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

Course Certificate

Use your certificate to make a career change or to advance in your current career.