ajay parmar
What is vba editor window. Where do we write vba in ms access.
Types of variables, their data–types. What questions can be asked in your interview related to access vba variables.
Use of Option explicit and why it is important.
How to run the VBA codes when you debug or do the testing of code.
What is a record–set.
How we define them and how we use them with 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.
Instructor Details
Courses : 8
Specification: Access VBA introduction – Series1
|
11 reviews for Access VBA introduction – Series1
Add a review
| Price | $13.99 |
|---|---|
| Provider | |
| Duration | 7.5 hours |
| Year | 2019 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$19.99 $13.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….