VBA (MS Office) Training - Using objects and events in VBA Access in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
950.-/d
ID : 824
Goal : Understand and learn to use most common basic objects, classes, methods, properties and events based on MS Access library to develop simple or complex routines (macros).
Audience : This training is for anyone wishing to push the limits of MS Access and unlock all sorts of possibilities.
Prerequisites : The participant must be very familiar with the tools and functions available in MS Access and creating action and group macros. Much experience is recommended as well as English proficiency, concepts of algorithms and basic mathematics.
Goals :
- Introduction
- Management of the event on database opening and closing
- Management of classical events of forms (OnOpen, OnClose, OnCancel, OnDelete , OnError, OnFilter, OnUpdate)
- Management of classical events on reports (OnOpen, OnPrinting)
- Event Management on form controls (OnExit, OnNoList, OnKeyPressed)
- Managing tables and recordset in VBA
- Import data from Excel, Word, XML, CSV, TXT or Outlook into VBA
- Manage pictures and files (external objects) in VBA
- Control of opened forms and of multiple-choice options in VBA
- Applying filters on Forms in VBA
- Input Control in VBA
- Using calendars (only version prior to 2007)
- Training Conclusion
Pedagogical method : This training is based on practice only with examples choosen by the trainer.
Suggested duration for presentiel training (days) : 1
Suggested duration for on-line training (days) : 1.2
Daily price in face-to-face : 950 CHF
Daily price in remote : 456 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 4750 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Tags : access training, MS access course, MS access, ms access, VBA, visual basic application, recordset, xml, csv, txt.