SCN GmbH

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.

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

Duration 5 Days, approx. 6h/Day
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 1.179.610,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Choose a free date for Aba














Duration 5 Days, approx. 6h/Tag
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 3.262.751,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Enter your preferred date for Aba



Duration 5 Days, approx. 6h/Tag
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 1.179.610,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Please select a free date