Learning Super powerful Arrays & Functions . From Basic level to extreme advance levels. Join me in this great journey.
- We will learn the use of Arrays- the most incredible thing in VBA and how to use the functions in access vba. Again^You must be familiar with Variables and looping system - how it works in access before learning this tutorial.
- 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.