BiggestSale: 17Courses in 3500Rs (500 Hrs), 10 Courses in 3000Rs

Log In
Registration

MS Access Vba (Basic To Advance) – English

MS Access Vba (Basic To Advance) – English

Access VBA Programming for Database learning including SQL

Created by Ajay Parmar

Material Includes

  • Lectures Files and HD video lectures with lifetime access on website.

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.

Course Curriculum

Training starts

  • VBA Editor and variables and data types use?
    01:02:33
  • More on Variables – fundamentals
    11:02
  • Public, module, local Variables – Scope
    52:19
  • Loops – How to write and use in access
    01:17:31
  • Loops continues
    01:01:56
  • Recordsets – Amazing concept to work on data
    01:08:11
  • Recordsets – Deep dive – how to scroll
    28:42
  • Let us do Assignment now
    28:27
  • Idea I used in my project – Pick last value when data is repeating
    15:07
  • Your Questions My solutions
    33:26
  • Introduction to Access VBA Arrays
    00:00
  • Project for your study – Arrays
    00:00
  • Introduction to Access VBA FUNCTIONS
    00:00
  • More on Functions
    00:00
  • Your Questions My solutions
    00:00
  • How to use UDF in queries – Fantastic and Superb knowledge
    00:00
  • Introduction to Access VBA Arrays
    01:17:49
  • Project for your study – Arrays
    34:26
  • Introduction to Access VBA functions
    01:17:59
  • More on Functions
    01:23:21
  • Your Questions My solutions
    38:32
  • How to use UDF in queries – Fantastic and Superb knowledge
    34:26
  • Know USERFORM Controls – Intro
    01:17:39
  • SQL – How to write
    01:19:00
  • Create the USERFORM
    53:39
  • Linking Combo-boxes with after update and change events
    51:16
  • List box with SQL
    53:41
  • Option buttons controls and more
    49:52
  • Project – Book ledger with automatic pages
    49:50
  • Create Move Next and previous buttons
    43:48
  • Security in Forms
    00:00
  • One more Small Project for you
    26:34
  • Create Auto SERIAL numbers- Powerful Project on Events
    16:41
  • Meeting Planner -A wonderful Project – Revision plus Learning Part1
    01:06:58
  • Meeting Planner -A wonderful Project -Part2
    31:39
  • Meeting Planner -A wonderful Project – Revision plus Learning Part3
    31:40
  • Student question – How to create search form – this is superb
    27:36
  • Intro – Error Handlers
    01:00:16
  • Errors with message and Input box
    41:23
  • Work with Excel File Dialogs in access
    49:58
  • Real project-Get sheets and range that you want from excel – File Dialogs
    49:58
  • Scripting Library to work with Files and Folders
    53:45
  • Project – Inserting 1000s of Excel files path into Access table
    47:37
  • How to Work with Text Files
    47:37
  • Intro to ADODB Library – active X data object
    40:54
  • Open or Connect another databases on local machine with DAO
    32:24
  • Connect databases which are on servers
    28:22
  • Connect with database which has passwords
    18:28
  • Introduction to Cursor Types
    41:54
  • MoveNext MovePrevious Buttons
    43:48
  • Security Set Up in Access
    01:16:06
₹899.00
₹899.00 ₹4,500.00
  • Level
    All Levels
  • Total Enrolled
    65
  • Duration
    25 hours
  • Last Updated
    February 7, 2023

MS Access Vba (Basic To Advance) – English

₹899.00
₹899.00 ₹4,500.00
  • Level
    All Levels
  • Total Enrolled
    65
  • Duration
    25 hours
  • Last Updated
    February 7, 2023

Material Includes

  • Lectures Files and HD video lectures with lifetime access on website.

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.

Course Curriculum

Training starts

  • VBA Editor and variables and data types use?
    01:02:33
  • More on Variables – fundamentals
    11:02
  • Public, module, local Variables – Scope
    52:19
  • Loops – How to write and use in access
    01:17:31
  • Loops continues
    01:01:56
  • Recordsets – Amazing concept to work on data
    01:08:11
  • Recordsets – Deep dive – how to scroll
    28:42
  • Let us do Assignment now
    28:27
  • Idea I used in my project – Pick last value when data is repeating
    15:07
  • Your Questions My solutions
    33:26
  • Introduction to Access VBA Arrays
    00:00
  • Project for your study – Arrays
    00:00
  • Introduction to Access VBA FUNCTIONS
    00:00
  • More on Functions
    00:00
  • Your Questions My solutions
    00:00
  • How to use UDF in queries – Fantastic and Superb knowledge
    00:00
  • Introduction to Access VBA Arrays
    01:17:49
  • Project for your study – Arrays
    34:26
  • Introduction to Access VBA functions
    01:17:59
  • More on Functions
    01:23:21
  • Your Questions My solutions
    38:32
  • How to use UDF in queries – Fantastic and Superb knowledge
    34:26
  • Know USERFORM Controls – Intro
    01:17:39
  • SQL – How to write
    01:19:00
  • Create the USERFORM
    53:39
  • Linking Combo-boxes with after update and change events
    51:16
  • List box with SQL
    53:41
  • Option buttons controls and more
    49:52
  • Project – Book ledger with automatic pages
    49:50
  • Create Move Next and previous buttons
    43:48
  • Security in Forms
    00:00
  • One more Small Project for you
    26:34
  • Create Auto SERIAL numbers- Powerful Project on Events
    16:41
  • Meeting Planner -A wonderful Project – Revision plus Learning Part1
    01:06:58
  • Meeting Planner -A wonderful Project -Part2
    31:39
  • Meeting Planner -A wonderful Project – Revision plus Learning Part3
    31:40
  • Student question – How to create search form – this is superb
    27:36
  • Intro – Error Handlers
    01:00:16
  • Errors with message and Input box
    41:23
  • Work with Excel File Dialogs in access
    49:58
  • Real project-Get sheets and range that you want from excel – File Dialogs
    49:58
  • Scripting Library to work with Files and Folders
    53:45
  • Project – Inserting 1000s of Excel files path into Access table
    47:37
  • How to Work with Text Files
    47:37
  • Intro to ADODB Library – active X data object
    40:54
  • Open or Connect another databases on local machine with DAO
    32:24
  • Connect databases which are on servers
    28:22
  • Connect with database which has passwords
    18:28
  • Introduction to Cursor Types
    41:54
  • MoveNext MovePrevious Buttons
    43:48
  • Security Set Up in Access
    01:16:06

The beautiful thing about learning is that nobody can take it away from you.

Twitter Facebook-f Instagram Telegram-plane Youtube

Quick Links

Imp. Links

Weekly Newsletter

  • Copyright 2022-23 AjayParmarTutor. All Rights Reserved