Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Access VBA (Basic to Super Advance - 40 Hours)
Rating: 4.4 out of 5(95 ratings)
731 students

Access VBA (Basic to Super Advance - 40 Hours)

Variables.Recordsets , Loops. Arrays, IFs, Connecting Excel,Collection Loops, functions, SQL, Forms,Dashbaords, ADO.DAO
Created byajay parmar
Last updated 3/2024
English

What you'll learn

  • 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

Course content

13 sections • 52 lectures • 39h 29m total length

  • VBA Editor and variables and data types use?1:00:41

    • Let us know the first thing in this chapter- What are variables and why they are so important in any VBA language. 

    • Different types of data types like single,double,object,string,byte,integer, long etc.

    • What are the types of variables and how long they exist in your code. So much in-depth discussion going here.

    • Use of option explicit and how to call macros and connect them.

    • Come and join this amazing journey. Your first step towards becoming a Access programmer.

  • More on Variables - fundamentals11:01

    Enable option explicit to require variable declaration and catch undefined variables in access VBA. This setting forces proper variable use, helps spot typos, and prevents silent errors.

  • Public, module, local Variables - Scope52:18

Requirements

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

Description

  • 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

Who this course is for:

  • Students who want to make career in analytics field and want to be Access Programmer. Knowing Access VBA means you can fully control Access and integrate it with Excel pretty well.

Report abuse