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.
Courses : 8
Specification: Access VBA introduction – Series1
11 reviews for Access VBA introduction – Series1