What you'll Learn
- Introduction to Macro, VBA interface
- Writing your first Access VBA code in IDE
- Controlling program execution
- Enhance Table, Form and Reports using VBA
- Getting familiar with User Authentication
- Error handling and Debugging
Microsoft Access VBA
Access 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.
Duration : 30 Hrs
Microsoft Access VBA Course Content
- Introduction & Basics
- Access Application
- The development process
- Macro / VBA
- The VBA IDE
- 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
- 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
- Enhance Table, Form and Reports 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
- Authenticating User
- Security
- Record Locking
- Multiple Users With different Privileges
- The DBA
- Error Handling and Debugging
- Error handling
- Debugging
- Types of errors
- Testing
- Planning for errors
