- Seminar / Training
- Microsoft
- MS Office
- Access 2022 Query Techniques
- Access 2022 Advanced
- Access 2022 Reports
- Access 2022 Diagrams
- Access 2022 Forms for data maintenance
- Access 2022 for Controllers
- Access 2022 Basics
- Access 2022 Complete
- Access 2022 Macros
- Access 2022 VBA
- Access 2022 VBA Advanced
- Access VBA 2022 Complete
- Excel 2022 Advanced
- Excel 2022 Charts
- Excel 2022 Formatting
- Excel 2022 Functions
- Excel 2022 for Analysts
- Excel 2022 Basics
- Excel 2022 Templates
- Excel 2022 Pivot Tables
- Excel 2022 Power Query Basics
- Excel 2022 VBA
- Powerpoint 2022 Animation
- PowerPoint 2022 Advanced
- PowerPoint 2022 Basics
- PowerPoint 2022 Complete
- PowerPoint 2022 Presentation Templates
- Prezi Desktop Basics
- Project 2022 Advanced
- Project 2022 Basics
- Project 2022 Complete
- Word 2022 Advanced
- Word 2022 Editing longer texts
- Word 2022 Document Template Creation
- Word 2022 Templates
- Word 2022 Basics
- Word 2022 Complete
- Word 2022 Serial Documents
- Word 2022 Tables
- Word 2022 VBA
- Seminar / Training
- Microsoft
- MS Office
- Access 2022 Query Techniques
- Access 2022 Advanced
- Access 2022 Reports
- Access 2022 Diagrams
- Access 2022 Forms for data maintenance
- Access 2022 for Controllers
- Access 2022 Basics
- Access 2022 Complete
- Access 2022 Macros
- Access 2022 VBA
- Access 2022 VBA Advanced
- Access VBA 2022 Complete
- Excel 2022 Advanced
- Excel 2022 Charts
- Excel 2022 Formatting
- Excel 2022 Functions
- Excel 2022 for Analysts
- Excel 2022 Basics
- Excel 2022 Templates
- Excel 2022 Pivot Tables
- Excel 2022 Power Query Basics
- Excel 2022 VBA
- Powerpoint 2022 Animation
- PowerPoint 2022 Advanced
- PowerPoint 2022 Basics
- PowerPoint 2022 Complete
- PowerPoint 2022 Presentation Templates
- Prezi Desktop Basics
- Project 2022 Advanced
- Project 2022 Basics
- Project 2022 Complete
- Word 2022 Advanced
- Word 2022 Editing longer texts
- Word 2022 Document Template Creation
- Word 2022 Templates
- Word 2022 Basics
- Word 2022 Complete
- Word 2022 Serial Documents
- Word 2022 Tables
- Word 2022 VBA
Access VBA 2022 Complete
Seminar / Training Access VBA Complete
The development environment
- The VBA Editor
- The module window
- The Project Explorer
- The property sheet
The Access security concept
- Different module types
- Class modules
- General modules
Introduction to the object model
- Hierarchy
- Properties
- Methods
Dealing with program structures
- Function or procedure
- Definition and validity of variables and constants
- Different data types
- Object variables
- Local and global variables
- The practical application
- Using various functions
- Functions with and without $
- InputBox(), Isnumeric() and others
- Creating your own functions
Planning and program flow control
- Creating a program flow
- Using different loops
- Do loops
- For loops
- Header controlled
- Foot-controlled
- Selection structures
- IfThen Else
- Select case
- Handling
object oriented programming
- Object
- Access to properties
- Access to methods
- The With statement
- Collective objects
- The DoCmd object4
Event-oriented programming
- Explanation of important events
- Examples of:
- On key
- On Open
- On click
- On load
- When formatting (report)
Programming with forms and reports
- Syntax for form access
- on open forms
- on closed forms
- Access to controls
- Programming timers
- multiple selection in list fields
- Programmatic navigation in forms
- Deleting records
- Closing forms
- Procedures for filtering
- Procedures for sorting
- Selecting data for printing
Data access with VBA
- Data access using domain functions
- Data access with ADO and DAO
- Library referencing
- Access to recordsets
- Adding records
- Search records
- Modifying records
- Deleting records
- Close recordset
Executing SQL statements in VBA
- Syntax of an SQL statement
- SQL statements with the DoCmd object
Including libraries (see Extras References)
- Check the list of references
- Library paths and the registry file
- Create new references
Design Access interface
- Configuration via a system table (XML) and via VBA
- XML commands to configure a register
- Deactivating and activating existing registers
- Creating registers, command groups and buttons
- Labeling and icons
- VBA, XML and AutoExec macros
- Alternative graphical configuration tools
Advanced form techniques specifically in Access
- Working with attachments
- Form specific tabs
Reading data via VBA
- Two ways: DAO/ODBC and ADO/OLEDB
- Data access with DAO
- Data access with ADO
Detailed commands for DAO and ADO
- Commands for searching in a RecordSet
- Indexing of RecordSet columns
User control
- User level security alternatives
- User recognition functions (Windows and SQL Server)
Access control for forms and reports
- Allow properties
- Prevent circumvention of restrictions
We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.
Your contacts
-
Promise Akachukwu Kelechi
E-Mail:
Phone: +234 1 227 9218 -
Peter Chidiebere Ugochukuw
E-Mail:
Phone: +234 1 227 9218 -
Raphael Chukuwgozie Ndubuisi
E-Mail:
Phone: +234 1 227 9218
What makes our seminars different?
We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.
All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.
Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.
- Implementation guarantee - Implementation guarantee for two or more participants
- Mobile classrooms - the ideal complement for company seminars
- Free support - for questions after the seminar
- Delivery on account - no prepayment required
- Interview with the trainer / quality assurance - get to know and assess the trainer in advance
- Clarify seminar requirements - review your knowledge with the trainer
- Assistance with travel costs - we cover part of the costs of hotel accommodation
- Meals - all day cold / hot drinks and a full lunch in the restaurant
- Location of training centres - always centrally located and easily accessible
- Discount - we have attractive prices, take advantage of our additional discounts
- Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars
Prestations de service
Nous vous proposons des séminaires très pertinents sur le plan pratique. Le contenu et les exercices sont axés sur vos tâches quotidiennes dans l'entreprise et évitent totalement les références publicitaires à d'autres produits du fabricant de logiciels.
Toutes les formations que nous proposons sont indépendantes du fabricant. Cela nous permet d'offrir des observations critiques sur les produits eux-mêmes et des comparaisons avec les concurrents du fabricant dans le séminaire. Le contenu des cours nous est propre et découle de l'expérience pratique de nos formateurs dans le cadre de projets.
Bien entendu, le contenu des séminaires d'entreprise peut être adapté à vos besoins. N'hésitez pas à nous contacter.
Réservation
Das Seminar wurde auf die Merkliste gesetzt
Das von Ihnen gewählte Seminar wurde bereits auf die Merkliste gesetzt
Bitte wählen Sie einen freien Termin aus
Bitte geben Sie Ihren Wunschtermin im Format tt.mm.jjjj ein
Bitte wählen Sie einen freien Termin aus
Bitte geben Sie den gewünschten Termin im Format tt.mm.jjjj der Schulung ein