MS Access 2010 VBA Training Course in London
Our MS Access 2010 VBA course will provide users that have existing advanced level skills in Access to build on their knowledge. The Visual Basic course will focus on automating repetitive tasks in Access using the VBA programming language. The course is designed for users who need to validate data, build complex Access routines for Importing, Exporting or Report Building.
To maximize the gain you receive from our MS Access 2010 VBA training course, it is recommended that you have attended our MS Access Advanced course or that you are at a similar level.
Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.
Access 2010 VBA Training Course
Audience: This course is designed for advanced Access users whom need to start automating database tasks or simplify complex database sequences.
Access 2010 VBA Course Objectives: After the course, you will be able to:
- Understand the VBA Environment
- Create Subroutines and Functions
- Understand all VBA Structures
- Apply DAO Model
Requirements: You must have strong Access skills and understand all concepts from all other courses, e.g. Intermediate and Advanced
Course Duration :This is a 2 day Access 2010 VBA course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access 2010 VBA course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Access 2010 VBA Training Course Contents
Macros
- Creating Macros
- Assigning Macros to Controls
- Group Macros
- Conditional Macros
- The AutoExec Macro
- The AutoKeys Macro
VBA
- An overview
- The Environment
- Working with Modules
- Converting Macros -DOCMD
- Events
Coding Structures
- Control Structures (If, ElseIf, SelectCase)
- Looping Structures (Do, For..Next)
Functions
- Purpose
- Creating and using Functions
Variables
- Option Explicit
- Variable Type
- Scoping a Variable
- Testing Variable Contents
User Interaction
- MsgBox
- InputBox
Debugging and Error Handling
- Breakpoints
- Stepping Code
- The Immediate Window
- Creating Error Traps
Data Access Objects (DAO)
- The Workspace Session
- Manipulating Recordsets
- Creating Queries
- Creating Tables
Active X Controls
- VBA Menus and Toolbars
More 2010 Courses
