M.S Access VBA 2010

Course details

The Microsoft Access 2010 VBA Training course is designed for experienced Access 2007/2010 users who want to learn advanced VBA programming. In the course students will exchange data with other applications, automate business processes by using VBA code, and learn how to find and fix errors in VBA code.

Course Contents 

MODULE I: INTRODUCTION & BASICS

• Access Application.
• The development process.
• Macro / VBA.
• The VBA IDE.

MODULE II: CREATING THE CODE IN VB IDE

• Naming Convections.
• Variables and Data types.
• Constants and intrinsic constants.
• Built-in functions.
• Procedure declaration.
• Subroutines and functions.
• Modules.
• Procedures.
• Operators and operands.

MODULE III: CONTROLLING THE EXECUTION OF PROGRAM

• Control Structures.
• Decision Making.
• Looping.

MODULE IV: USING ACCESS OBJECTS

• Object browser.
• Special Objects
• Properties of Objects
• Events of Objects
• The DAO
• DAO V/s ADO

MODULE V: ENHANCE TABLE, FORM AND REPORT USING VBA

• Table creation (Using SQL)
• Selecting, Closing, Opening, Deleting a table
• Opening, Closing, Deleting, Navigating through a Form
• Opening, Closing, Deleting, Formatting a report
• Switch Board in MS Access
• Searching the Database by user defined conditions.

MODULE VI: AUTHENTICATING USER

• Security
• Record Locking
• Multiple Users With different Privileges
• The DBA

MODULE VII: ERROR HANDLING AND DEBUGGING

• Error handling
• Debugging
• Types of errors
• Testing
• Planning for errors