ajay parmar
What is 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.
Instructor Details
Courses : 8
Specification: Access VBA introduction – Series1
|
11 reviews for Access VBA introduction – Series1
Add a review
| Price | $15.99 |
|---|---|
| Provider | |
| Duration | 7.5 hours |
| Year | 2021 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$15.99
Jyot –
I really like the session. It was so nicely explained. And i see that there are practice assignments as well which should help me after completing the course. Thank you Ajay.
Excelexpert –
Hi Ajay,I think the lectures are very long (good for me) and explained very well with lot of patience and good pauses. no sign of haste shown. If i will have any question I will message you. I am going to work on assignments now. What about your other series. I can go and watch them series wise..Will that how i will learn access vba practically?
Boris Pranjic –
The pace and content is spot on. I have been doing other Access courses but this one fills the gap that all others are missing. Even after only going through the first chapter I have a much better understanding of VBA and why and how it works. Thank you. The only reason this is not 5star review is that sometimes I have a hard time understanding your dialect, therefore, I use the subtitles but these are autogenerated? and show some very odd text. but maybe that is something that Udemy needs to fix.
Mario Franco –
I really enjoyed this course. It cleared up questions I had on the use of recordsets and looping.
Eugene C Meehan –
Ajay Provides Excellent coverage and detailed explanations of variables including the scope and lifetime of variables. He also provides working VBA examples of how and when to use these different types of variables.
Athanasios Litsakos –
This course teaches you the principles of vba. Just follow his examples and do his assignments.
Rodrigo Olivera Mares –
Very well explained, alot of examples
Bobbie Breaux –
Yes, it started at the basics of using VBA. No other online course has started at the beginning.
Terence K Boissel –
As the course went on and I got used to the instructor I found him a lot easier to understand. I loved the course and would recommend it to anyone who is starting out to learn VBA
Kevin Heine –
Loving the course seems to be exactly what I’ve been searching for.
Mark Tuttle –
Nice job…very informative….