MS Office Access Training - Macros 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.
475.-/d
ID : 649
Goal : Users willing to learn how to automate procedures such as import/export data or the execution of requests through forms, or push MS Access limits with the user interactivity through the forms graphic interface. Every type of macro will be learned through small practical exercises and a macro group will be created to resume the whole training.
Audience : Users willing to automate common basic tasks in MS Access with administrator rights on professional database.
Prerequisites : Attendees should know the various MS Access components (tables, forms, requests, status, fields, functions, etc.) and have significant experience in creating or modifying a database
Goals :
- Introduction
- About macros objectives ands limits
- Refresh macro
- Display toolbar, DispAllRec macros
- CancelEvent macro
- ApplyFilter macro
- SelectObject, ReachControl, ReachRecord macros
- Warning, Bip, Echo, Msgbox macros
- CopyObject, CopyTo macros
- DefineValue macro
- SendObject macro
- Executeapplication, Executemacro macros
- Close, Quit macros
- OpenReport, openform, openrequest, opentable, openview macros
- Transferbase macro, Transferspreadsheet macros
- Findrecord, Findnext macros
- Macro group (conditional macro)
- Training Conclusion
Pedagogical method : This training is based on examples used as examples proposed 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 : 475 CHF
Daily price in remote : 228 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 2375 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 : ms access training, ms access, MS access, macros, VBA, VBA access, access macros database.