Description

This training will teach you how to develop management applications using Access using the VBA language. You will see how to create menus, dialog windows, messages, trigger events and use data.

Who is this training for ?

For whom ?

Anyone wishing to automate processing and develop applications using Access.

Prerequisites

Basic knowledge of development with Access or knowledge equivalent to that provided by the "Mastering Access, level 2" course

Training objectives

Use VBA language syntax to program the display of input forms

Program events to process user actions on forms and reports

Use data update instructions

Program processing to communicate with other applications

Manipulate the development environment to create a debugged and finalized application

Training program

• The Visual Basic editor
  • The Project Explorer. Code modules.
  • The Properties window. Debugging tools.
• Understanding the structure of the VBA language
  • Writing rules and syntax.
  • Variables and data types.
  • Procedures and functions in VBA.
  • Control and iterative structures.
  • Objects, their properties and methods.
  • Form and Control objects. Collections of objects.
• Manage events
  • The event categories of Access objects.
  • The order of succession of events.
  • Data update events.
  • Event procedures.
• Program an application
  • The hierarchy between forms, reports and controls.
  • The management of actions and procedures on objects.
  • The creation of menus and toolboxes.
  • The CommandBar object for managing the ribbon.
  • The menu controls and event handlers.
  • The options for starting an application.
• Configure DAO/ADO objects
  • Know the usefulness of DAO and ADO objects.
  • Read data with the Recordset object.
  • Modify data with the Execute method.
• Dealing with errors
  • The different types of errors.
  • The different error management tools.
• Communicate with external applications
  • Reference an external library.
  • Drive Word for a mail merge service.
  • Drive Excel to export/import data.
  • Import a text file into a table.
  • Export a table to a text file.
• Finalize the application
  • Local installation, in client-server mode.
  • The linked table manager.
  • Database compaction.