VBA using Access

IT Training Solutions Limited

Course

Inhouse

Price on request

The best Visual Basic courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Inhouse

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

About this course

Delegates should have attended Access Level 2 and/or Level 3 courses or have equivalent knowledge. Delegates should be currently working with an Access database application that they have built themselves. Delegate should also understand table, query, form, report and macro design and function, as well as data normalization and table relationships.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Overview

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
Prerequisites
  • Delegates should have attended Access Level 2 and/or Level 3 courses or have equivalent knowledge.
  • Delegates should be currently working with an Access database application that they have built themselves.
  • Delegate should also understand table, query, form, report and macro design and function, as well as data normalization and table relationships.


Objectives


    Delegates will be able to :
  • Explain the difference between sub and function procedures in VBA code
  • List 3 common events and in where they might use them in application design
  • Write professional VBA code segments with error checking to carry out tasks as defined by your tutor
  • Use the AccessObject object to create an intelligent report selection form
  • Build a browse form for quick navigation to a specific record
  • Create a flexible report such that people may choose its content at run-time
  • Describe how to debug VBA code
Related Courses
  • Access Level 2 ()
  • Access Level 3 ()
Whats Included
  • Comprehensive colour course manual and exercises
  • Use of a Modern Training suite with 19 inch flat screen monitors
  • 1 delegate per computer
  • Lunch (When at our training venue)
  • Refreshments (When at our training venue)
  • Relaxed refreshment area at our training room
Course Content
Designing Applications
  • Macros or VBA?
  • The development process
  • What is an access application?
Introduction to Event Driven Programming
  • Completing the company contacts Form
  • Converting macros to VBA
  • The VBA IDE
Creating Code
  • Naming conventions
  • Variable scope and lifetime
  • Constants and intrinsic constants
  • Variables
  • Built-in functions
  • Procedure declaration
  • Subroutines and functions
  • Modules
  • Procedures
Controlling the Program
  • Arrays
  • Repetition
  • Programming structures
Using Access Objects
  • The object browser
  • Special objects
  • Referring to objects
  • Forms and reports
  • The AccessObject object
  • Access objects
  • Object models
  • Object-oriented programming
Using DAO
  • Working with recordsets
  • The DAO hierarchy
  • DAO vs ADO
Reports
  • Filters
  • Format
  • Error
  • Close
  • Deactivate
  • Activate
  • Open
  • Events
Advanced Programming Techniques
  • Custom DAO properties
  • Dynamic-link libraries (DLLs)
  • Arguments
  • Arrays
Error Handling and Debugging
  • Debugging your debugging code
  • Error handling
  • Debugging
  • Types of errors
  • Testing
  • Compiling
  • Planning for errors
Using Classes
  • Forms as class modules
  • Class modules and custom objects
Libraries and Add-Ins
  • Add-ins
  • Class libraries
  • Library databases
Multi-User
  • Compiling
  • Security
  • Record locking in access
  • Multi-developer issues
The Internet (Optional as time permits)
  • Publishing data to the internet
  • The HyperLink data type
  • The internet
Optimising Your Application
  • Finishing touches
  • Network considerations
  • Increasing apparent speed
  • Increasing execution speed
  • Reducing memory overhead
  • Efficiency

See related categories

VBA using Access

Price on request

The best Visual Basic courses

See all

See all