Access Developer Training is designed for users interested in expanding standard functionality of a database in Access using programming in Visual Basic (VBA) language including access to data using interface ActiveX Data Objects (ADO) and options for programming modifications of a database based on Data Access Objects (DAO). After completing this training participants will be able to import and export data automatically, to create custom functions for using them in queries, to modify the user interface and to process data in databases using programming.
Osnova školení Access Developer
U individuálního a firemního školení je možné osnovu přizpůsobit.
- Basics of VBA language
- Placing a source code
- Definition of procedures and functions
- Definition of variables
- Expressions
- Error-handling
- Object model Microsoft Access
- Structure of objects
- Links to forms and reports
- Basic types of events
- Nested functions
- Custom functions
- Interactive forms
- Conditional formatting
- Options of using VBA in forms
- Error messages and prompts
- Branching a program
- Response according to logged in user
- Programmatic access to data
- Interface structure ADO
- Connecting to database
- Query definition
- Reading from a set of records
- Updating set of records
- Updating source data
- Modifying database structure
- Using definition statements SQL
- Options of interface DAO
- Table definitions
- Query definitions
- Import and export data
- Import text files
- Text encoding
- Export in CSV and XLS formats
- Sending data or a report by email
- Multilingual environment of a database in Microsoft Access
- Principles for design
- Solution variants
Předchozí znalosti
Před školením se předpokládají znalosti na úrovni školení:
Verze programu
U firemního a individuálního školení si verzi programu, na které bude školení probíhat, můžete zvolit.