The aim of the course is to introduce participants to the use of Visual Basics on Access applications. The course will cover the main themes connected to relationship management, database management and customization, the main functions and operations with Visual Basic language.
1. Introduction to visual basic for application in Access
• Introduction to the relationship model
• Connecting to VBA in Access
• Introduction to procedures and modules
• The visual basic editor
2. Working with VBA in Access
• Creating and managing modules
• Creating and managing procedures
• The main typologies of variables
• Managing constants
• The use of functions in VBA
• Creating and managing arrays
• Debugging
3. Managing data and tables
• Data access with ADO
• Creating and managing tables with ADO
• Security and access management with ADO and JRO
• Programming events
• Basics of XML
• Managing data with XML
Ad hoc
Contatti
