Enable Technology



About Enable Technology Southport Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a socially distanced local training venue in Southport. We are happy to discuss customising the course content should you have particular Access training requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: GKN PLC, Norwich Union PLC, Countrywide Homes Limited, Birmingham City University, Homeserve PLC, Royal Air Force, Barclays Bank PLC and DHL Express.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Southport
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Why Program in Access?
    Controlling Program Execution
    Using Debugging Tools
    Working with the Code Editor
    Calling Procedures
    Using the Immediate Window to Call Procedures
    Specifying a Recordset Cursor Type
    Working with Methods
    Handling Errors
    Navigating the Access Object Hierarchy
    Using the Do...Loop Structure
    Understanding Errors
    Working with Events
    Organizing Code and Procedures
    Understanding Classes and Objects
    Understanding the Form Object
    Working with Procedures and Functions
    Understanding the Order of Events
    Introduction to Programming in Access
    Understanding the Development Environment
    Using the CacheSize Property - Optional

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Southport
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Sorting and Filtering
    Creating and Using Macros
    Understanding VBA
    An Introduction to VBA
    Data Validation
    Creating a Lookup Database
    Working With Records
    Database Security
    Getting to Know Access 
    Parameter Queries
    Setting Table Relationships
    Creating Queries
    Macro Techniques
    Relational Database Design
    Multi Table Queries
    Creating a Relational Database
    Database Wellness
    Creating and Using Reports
    Action Queries
    Creating and Using Forms
    Formatting Tables

  • See Training Course Details...

Email us about this courses

Other Southport Enable Technology Training Courses

JQuery Southport Training Courses
Power Query - Southport Excel Training Courses
SSRS - Southport SQL Server Reporting Services Training Courses
JavaScript Southport Training Courses
Oracle SQL Southport Training Courses
TSQL - Southport SQL Training Courses