MS Access 97 VBA Training Course in London
Our MS Access 2000 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 repitive 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 2000 VBA training course, it is recommended that you have attended our MS Access Advanced course or that you are at a similiar 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 97 VBA Training Course
This course is designed for advanced Access users whom need to start automating database tasks or simply complex database sequences
Course Duration
This is a 2 day Access 97 VBA course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access 97 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 97 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 Structutes
- Control Structures
- Looping Structures
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 97 Courses
