|
A 8 hour Seminar which includes a VBA Access introduction .
Seminar will take place at (20:00-22:00 [GTM +2]) 2 hours each weekday.
Please use contact form to register. Payment will be asked when we have at least 4 attendants.
Seminar Schedule
Introduction to VBA (4h)
2.1 Reference to Module types (Form-Report Modules, ClassModules, Standard Modules).
2.2 How to reference to Form's, Report's, Table's, Query's objects.
2.3 Explain VB Editor (BookMarks, Break, Debbuging, Find-Replace)
2.4 Events and methods, Docmd, RunCommand, CurrentDb, CurrentProject
2.5 VBA Watch
2.6 VBA Immediate
2.7 Debug.Print Examples and Debug Tools.
3. Handle Events και Functions : (4h)
3.1 Example of Events . (Εvents BeforeInsert,BeforeDelConfirm, KeyPress, KeyDown, KeyAscii, Timer. NoData, OpenArgs, After Update κλπ.)
3.2 Build custom Functions, IsMissing, IsNull, nz, Dcount, Dsum, Dlookup.
3.3 Access application Examples
3.4 Macros AutoKeys, Autoexec,
|