IT trainings > Technical

Access : Visual Basic Application

Access Visual Basic

Goals

Be able to manipulate an Access database and to access data via VBA.

Requirements

Advanced knowledge of Access.

Contents

Introducing Visual Basic

  • Objects
  • Collections
  • Properties
  • Methods
  • Events
  • Modules
  • Procedures
  • Functions

Modules

  • The Visual Basic Editor
  • Standard modules - Concepts and uses
  • Forms and Report modules - Concepts and uses

VBA commands

  • Conditional statements - IF, Select case
  • Loops - For Next, Do Loop
  • Interactivity - Input box, Msgbox

Variables

  • Definition
  • Data types
  • Declaration
  • Dim, Redim, Public, …
  • Local and global variables

 
 

Let’s stay in touch

We'll never share your email address and you can opt out at any time, we promise.