Rating 4.65 out of 5 (44 ratings in Udemy)
What you'll learn- This is first series in an attempt to make you awesome in Access VBA.
- Learn what is VBA Editor, How to go there and insert modules and then write programmes.
- How to activate project explorer if it is not visible or closed by mistake. Shortcut key to activate it.
- Learn the role of property window in renaming the modules.
- Why should we rename modules and why we write sensible names to our sub routines or macros.
- Rules to …
Rating 4.65 out of 5 (44 ratings in Udemy)
What you'll learn- This is first series in an attempt to make you awesome in Access VBA.
- Learn what is VBA Editor, How to go there and insert modules and then write programmes.
- How to activate project explorer if it is not visible or closed by mistake. Shortcut key to activate it.
- Learn the role of property window in renaming the modules.
- Why should we rename modules and why we write sensible names to our sub routines or macros.
- Rules to remember while naming modules and sub routines or procedures.
- What are variables and why they are needed in Access VBA.
- What is the dim statement and different data types like byte,integer,single,long,double,variant and string
- What questions can one ask in your interview when it comes to variables.
- Similarities between data types and dis-similarities - let us know in detail. Ascending order of data types .Which is stronger & logic behind choosing right one
- Know your loops like Do while and For Next loops . Loops are the backbone of programming language and one should know it thoroughly
- What do you mean by recordset and how it is defined in access VBA .
- How to loop each and every row of your table from top to bottom or from middle point or in reverse direction.
- Know about amazing recordset methods like move next or move first, or move previous and why they needed and how they are used in Loops.
- How to write subloops , loop inside loop and why you should know it. Practical demos given
DescriptionWhat 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.
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.
