Access VBA (Basic to Super Advance - 40 Hours)

Variables.Recordsets , Loops. Arrays, IFs, Connecting Excel,Collection Loops, functions, SQL, Forms,Dashbaords, ADO.DAO

• 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