Course Outline
Introduction to VBA
- Storing information
- Data types
- Variables
- Terminology, characteristics, scope, visibility of variables
- Control structures if, select case, do, for
- Loops
- Built-in functions
- Types, finding and removing errors
- Comments
Object
- Definition
- Properties
- Methods
- Collections of objects
- Viewing
- Tables, queries, indexes
- Object-oriented data access
- Custom Class
- Object Error Handling
Databases
- Constructing queries with VBA
- Use of SQL syntax
- Transactions
- DAO and ADO
- Records
- Importing data from other systems
Applications
- Plan
- Interface
- Menus
- Reports
- Controls available from code
- Forms
- Integration and support for other applications
- Library functions
Best Practices
- Tips and trics