Database Automation using VBA(Advanced MS Access)

You are here: [Database Automation using VBA(Advanced MS Access) Home]

A course reader developed by the instructor is provided at no additional cost to accompany this course.

This course introduces the Visual Basic for Applications (VBA) programming language.

See what former students had to say about this course.

The following main concepts are covered in this course:

  • Learn VBA programming syntax and Data Access Technologies (DAO/ADO) which are built into Microsoft Access and Office applications.
  • Implement programming concepts such as variables, recordsets and event-driven models into discrete program units.
  • Develop insight into control-of-flow execution that is integral to programming.
  • Enrich user experience with dynamic coding that meet directed objectives.
  • Polish and manage application flow by linking program units to form, report and control events.
  • Enact communication technologies (DAO/ADO) to automate processes and gain access to Windows DLLs.

On successful completion you will be able to apply these new skills:
  • Navigate comfortably in the VBA environment (VB Editor).
  • Create basic programming units (sub and function routines).
  • Apply basic VBA programming elements such as variables (declaring, scope, lifetime) and controlling executions (If-Else-End if, Do/While/Until loops, Select Case).
  • Implement dynamic coding using the MS Access object model and hierarchy.
  • Identify and use form, report, and control events to link program units to your application.
  • Bulletproof your application using sophisticated error handling routines.
  • Use data access technologies (DAO/ADO) to automate database tasks and denormalize data structures.

Prerequisites: Successful completion of Intermediate Microsoft Access, or a strong background in MS Access using all main objects except modules. Previous programming experience is helpful but not required.

Click here for more information