.NET Training‎ > ‎

VBA Macros Online Training


VBA Macros Online Training Course Content:


1.     VBA MACROS (PROGRAMMING)

              ·         Building Solutions

·         Course Overview

·         Solution Concepts

·         Data Entry Concepts                       

·         Macro Concepts

·         Programming Concepts 

2.     Macro Basicss

 

·         Planning Macros

·         Recording Macros

·         Executing Macros

·         Maintaining Macros 


3.     VBA Programming Basics 

·         Understanding Objects

·         Using the Visual Basic Editor

·         Basics of Visual Programming Scripts

·         Visual Programming concepts

·         Understanding VBA Code

·         Executing VBA Code

·         VBA Help Reference


4.     Deployment Basics

·         Preparing for Deployment

·         Code Security

·         Creating Custom Toolbars

·         Creating Custom Macro Buttons 


5.     Customizing Macros


·         Prompting for User Input

·         Automating Data Entry

·         Recording Absolute vs. Relative References

·         Protecting VBA Source Code

·         Choosing the right Hosting Environment


6.     Enhancing VBA Code 

·         Programming concepts

·         Writing Source Code

·         Input box, Msgbox & Dim statements

·         Variables, Constants

·         keywords, data types

·         Writing Tips

·         Conditional Statements

·         Loops

·         Example Programming

·         Working with workbooks

·         Operators

·         Arrays

·         functions

·         Procedures and Sub Procedures 


7.     Handling Errors


·         Handling Errors

·         Syntax Errors

·         Logical Errors

·          Run-Time Errors

·         Accessing External Data

 

8.     Exceptions and faults 

·         An Introduction to Structured Query Language (Sql)

·         External References

·         Exporting Data from Excel To Access

·         ActiveX Data Objects Concepts

·         Using Ado in Microsoft Excel Applications

·         Database Creation with Ms Access

·         Import the Database From Access Based   On Sql Commands

·         Connecting to a Database

·         Retrieving Records from a Database 


9.     VBA User Form Basics 

·         Button Events 

·         Planning User Forms & Designing User Forms

 

VBA Macros Online Training