Access VBA introduction - Series1

Access VBA introduction - Series1

• 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.

• 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.

In-depth study on Variables and Recordsets with loops. Our first chapter in access VBA tutorial.

Url: View Details

What you will 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.

Rating: 4.35

Level: All Levels

Duration: 7.5 hours

Instructor: ajay parmar