To make use of Visual Basic functions to automate and customise processes in Access using coding.

Who Should Attend

All who would like to develop their skills and knowledge of VBA programming in Access application development to automate task for increase productivity.

Pre-Requisite

No previous programming experience is required. Participants should be currently working with an Access database application that they have built themselves. They should also understand table, query, form and report.

Course Outline

Part 1: Introduction To VBA

• Macros in Access
• Creating a macro
• Running a Macro
• Assigning a macro to form and switchboard
• Visual Basic Editor Environment
• The VBE Window
• Using the Project Explorer
• Understanding the Properties Window
• Using the Code Window
• Creating a new module
• Entering VBA codes
• Customizing VBE environment

Part 2: Beginning With VBA

• Learning about Objects & Property
• Understanding the Access Object Model
• Understanding collections
• Using the Object Browser
• Importing and export objects
• Objects referral
• Variables, Data Type & Constants
• Commenting for programming
• Declaring variables
• Scoping variables
• Defining data type
• Working with Date & String type
• Using assignment, logical and other operators
• Arrays
• Understanding Events
• Event sequences for various database objects
• Programming Events & using Code Builder
• Using MsgBox function for response
• Form & report events
• Mouse clicks & focus events

Part 3: VBA Core

• Procedures, Functions and Constructs
• Creating procedures by entering codes
• Scoping a procedure
• Various methods of invoking a procedure
• Passing arguments to procedures
• Inserting procedures
• Return Type
• ing built-in functions
• Using the MsgBox function for data return
• Using the InputBox function for data request
• Programming Constructs
• GoTo
• If … Then … Else
• Select Case
• For … Next loops
• Do … While loops
• Do … Until loops
• While … Wend loops
• With … End
• For Each … Next
• Incorporating custom functions
• Passing arguments to procedures
• Error Handling
• Trapping Error
• Using Break Mode
• Setting Breakpoints
• The Immediate and Watch panes
• Using Watch variables
• Using Step commands

Part 4: VBA For Databases

• VBA for Database Design
• Understanding Relational Databases
• Table Design using VBA
• Configuring Relationships
• Form & Report design using VBA
• Incorporating command, navigation & other Controls
• Setting properties for Form & Report
• Creating Dialog Boxes
• Using DoCmd Object
• Creating a Workspace using Microsoft Jet Engine
• Using Data Access Object
• Retrieving & editing recordset
• Querying data
• Using VBA objects to read, edit and change data in database