Microsoft VBA Visual Basic for Applications is a great way to expand your skills in the Microsoft Office packages. The Office packages can be enhanced using VBA code to project their use beyond the standard office commands. VBA provides the opportunity to allow unlimited functionality in any of your databases, documents or spreadsheets.

Visual Basic has many new and improved features that make it a powerful object-oriented programming language, including inheritance, interfaces, and overloading.

Microsoft VBA Access Introduction: Programming in Access

Course Code: ITDVA | Duration: 1 Day | Level: Introduction

This course builds on the subjects discussed in the previous levels of Access. We will give you the required knowledge understand objects, use expressions, variables, and intrinsic functions and learn debugging codes and handing errors.

Course Requirements

The delegate needs to understand the advanced features within Access which will allow them to understand how to bend the rules in VBA.


Course Content

• Visual Basic Environment Introduction
• Visual Basic Controls (Events / Properties / Text / Methods / Forms / Focus)
• Visual Basic Definitions (General / Event / Function / Sub Procedures And Modules)
• Controlling Access Forms (Control Form Components / Forms Come To Life)
• Using Variables (Text Handling / Property / Functions / Strings / Variants)
• Conditions And Loops (IF Statement / Loops)
• Error Handling (Message Boxes / Debugging)
• Dialog Control Boxes Within Code (Print Menu / Format / File Open / File Save)
• External Application Links (Linking To Word / Linking To Excel / Linking To Outlook)
• Updating Data (Edit, Sort & Filter Records In Code / Ado And Doa Controls)
• Problem Solving Workshops
• Question and Answers

Microsoft VBA Excel Introduction: Programming In Excel

Course Code: ITDVE | Duration: 1 Day | Level: Introduction

This course builds on the subjects discussed in the previous levels of Excel..

Course Requirements

The delegate needs to understand the advanced features within Excel which will allow them to understand how to bend the rules in VBA.


Course Content

• Visual Basic Environment Introduction
• Visual Basic Controls (Events / Properties / Text / Methods / Forms / Focus)
• Visual Basic Definitions (General / Event / Function / Sub Procedures And Modules)
• Creating Forms (Create Your Document Wizards / Auto Fill Documents)
• Using Variables (Text Handling / Property / Functions / Strings / Variants)
• Problem Solving Workshops
• Question and Answers

Microsoft VBA Word Introduction Programming In Word

Course Code: ITDVW | Duration: 1 Day | Level: Advanced

Streamline your workflow and enhance the functionality of Word documents with the power of VBA (Visual Basic for Applications). This course leverages the expertise of the PCS Solutions team to teach you how to automate tasks, create advanced document features, and customize Word to meet your unique needs. Learn how to build efficient solutions and explore the full potential of VBA for Word.

Course Requirements

The delegate should have a strong working knowledge of Microsoft Word and a basic understanding of macros. Familiarity with the Word ribbon and document formatting is recommended.


Course Content

• Introduction to VBA for Word (Understanding the VBA Environment / Macro Basics)
• Creating and Managing Macros (Recording Macros / Editing Code / Assigning Macros)
• Document Automation (Custom Templates / Automated Formatting / Content Insertion)
• Working with Word Objects (Paragraphs, Tables, Headers/Footers, and Ranges)
• Building User Forms (Custom Dialog Boxes / User Input Fields / Navigation)
• Advanced VBA Techniques (Loops / Conditional Statements / Error Handling)
• Integration with Other Office Applications (Excel, Outlook, and PowerPoint Interactions)
• Problem Solving and Debugging (Debugging Tools / Optimizing Code Performance)
• PCS Development Tricks (Best Practices / Tips for Efficient VBA Coding)
• Workshop (Hands-on Practice to Apply Skills in Real-World Scenarios)
• Problem Solving Workshops
• Question and Answers