Enable Technology



About Enable Technology Macclesfield Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with Access training materials which they keep after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams training requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Shell UK Oil Products Ltd, Loughborough University, DHL Express, Dollond & Aitchison Limited, South Staffordshire Water PLC, National Power PLC, EDF Energy PLC and Aston University.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Macclesfield
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Using Debugging Tools
    Navigating the Access Object Hierarchy
    Working with the ADODB Recordset Object
    Controlling Program Execution
    Using Intrinsic Functions
    Understanding the Form Object
    Understanding Recordset Cursor Properties - Optional
    Working with Methods
    Stepping through Code
    Creating a Standard Module
    Considering Variable Scope and Lifetime Together
    Understanding Errors
    Understanding Constants
    Writing an Error-Handling Routine
    Understanding the DoCmd Object
    Declaring Variables
    Setting Break Expressions
    Using the Select Case...End Select Structure
    Creating a Sub Procedure

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Macclesfield
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Formatting Tables
    Modifying Forms
    Macros on Forms
    Data Validation
    Working With Records
    Parameter Queries
    Relational Database Design
    Getting to Know Access 
    Modifying Table Structures
    Database Wellness
    DIY Forms
    Calculations in Queries
    An Introduction to VBA
    Adding Records to a Table
    Navigation Pane Protection
    Creating and Using Macros
    Adding Transactional Records
    Creating and Using Forms
    Creating and Using Reports
    Action Queries
    Database Security

  • See Training Course Details...

Email us about this courses

Other Macclesfield Enable Technology Training Courses

JavaScript Macclesfield Training Courses
Report Builder - Macclesfield SQL Server Reporting Services Training Courses
Power BI Macclesfield Training Courses
DAX - Macclesfield Excel Training Courses
PL/SQL Macclesfield Training Courses
SSIS Macclesfield Training Courses