Access VBA (Basic to Super Advance - 40 Hours)

About Access VBA (Basic to Super Advance - 40 Hours)

This course talks about the use of VBA in ms access. It has many sections (35 hours) and each topic is discussed in a detail.

If you know access front you are ready to learn access VBA and learn every small , big thing about it.

VBA Editor - Let us understand how to go to vba editor and understand its structure

Scope of Variables - How long a variable exist, public, local and module level . Option Explicit uses

Loops - for next with do while - How to write and use it on recordsets

Collection Loops - Loop tables, queries, forms, modules , forms, reports, objects - So amazing

Arrays - option base1, one dimensional , multi dimensional arrays with practicals

Functions (UDF and inbuilt)

Error Handlers - On error resume next, Go to err - How to use them wisely

Connecting Excel application - Work with excel application and control the way you want

Late binding and early binding with Powerpoint and word applications

SQL Statements - Select, update, Delete, Create, Drop , INSERT INTO - all sql statements use in VBA

Do CMD Function

IF function - Basic , nested IFs , With Loops and objects

File and Folder - How to create folders, files , how to work with scripting library - So much fun

File Dialogs - Why do we need it and how it can be used with scripting library to pick data from any folder

Dashboard Covered for you to gain confidence from the very beginning

Your questions answered - I have taken up students queries and solve them

Assignments also shared with you and some are solved as well