Microsoft Access VBA – Create your own applications

Learn VBA to automate repetitive tasks in Microsoft Access and to create state of the art database applications.

When you know Visual Basic for Applications [VBA],  you can create macros to automate repetitive tasks which will save you a lot of time and boredom of doing the same thing over and over again. If you know how to use VBA in Microsoft Access, you are on top of all Access users because you know how to create state of the art database solutions. By learning Access VBA, you can:

What you’ll learn

  • Create subroutines and functions..
  • How to create fully automated and animated dashboards..
  • Automate import and export of data..
  • Creating complex forms and reports and securing your database application..
  • How to use Dialog Boxes in MS Access..
  • Automate tasks with Action Queries..
  • Generate reports and share through MS Outlook with one click..

Course Content

  • Advanced MS Access and VBA –> 20 lectures • 6hr 14min.

Microsoft Access VBA - Create your own applications

Requirements

  • Before you enrol in this course, please make sure that you know how to use Microsoft Access..

When you know Visual Basic for Applications [VBA],  you can create macros to automate repetitive tasks which will save you a lot of time and boredom of doing the same thing over and over again. If you know how to use VBA in Microsoft Access, you are on top of all Access users because you know how to create state of the art database solutions. By learning Access VBA, you can:

  1. Manage smaller to medium size databases.
  2. Create you own defined functions.
  3. Manipulate data using advanced features of various objects of MS Access.
  4. Create a portable procedure to reuse as and when required.
  5. Animate data to get rid of non value added activities.
  6. Communicate with other applications and platforms.

Topics and theories covered in this course include reasons for using VBA in Access, good coding habits, using variables, constants and data types, error handling, debugging code, using procedures, subroutines vs. functions, conversion, date, math, string, format and is functions, input and message boxes, logical programming commands, arrays, objects, and classes and instantiation. This course will help learners of any level get the most out of the Visual Basic for Applications (VBA) environment. Starting with the development environment and working through various aspects of VBA, you will learn the tools and techniques needed to build custom solutions using Microsoft Access.