Enable Technology



About Enable Technology Milton Keynes Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be modified to accommodate your specific training needs.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

We have operated primarily in the West Midlands for twenty years. Our clients include: Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Nuclear Engineering Services, Shell UK Oil Products Ltd, DHL Express, Birmingham City Council, Total Telecommunications Limited and Canadian High Commission.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Milton Keynes
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Working with Methods
    Understanding Expressions and Statements
    Stepping through Code
    Using the CacheSize Property - Optional
    Using the For Each...Next Structure
    Working with Recordsets
    Working with Inline Error Handling
    Navigating the Access Object Hierarchy
    Introduction to Programming in Access
    Determining the Value of Expressions
    Guidelines for use of Branching Structures
    Working with Boolean Expressions
    Calling Procedures
    Understanding VBA's Error Trapping Options
    Using Visual Basic Help
    Using the Immediate Window to Call Procedures
    Specifying a Recordset Cursor Type
    Specifying a Recordset Cursor Location - Optional
    Creating a Standard Module

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Milton Keynes
  • 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 ...
  • Creating Queries
    Setting Table Relationships
    Formatting Tables
    Adding Transactional Records
    Relational Database Design
    Understanding VBA
    Macro Techniques
    Getting to Know Access 
    Database Wellness
    Creating and Using Forms
    Using a Navigation Form
    Action Queries
    Working With Records
    Adding Records to a Table
    Aggregation Queries
    Creating a Relational Database
    Navigation Pane Protection
    Creating a Lookup Database
    Calculations in Queries
    Creating and Using Macros
    DIY Forms

  • See Training Course Details...

Email us about this courses

Other Milton Keynes Enable Technology Training Courses

TSQL Milton Keynes Training Courses
JQuery Mobile - Milton Keynes JavaScript Training Courses
VBA - Milton Keynes Excel Training Courses
SSRS - Milton Keynes SQL Server Reporting Services Training Courses
Excel 365 Advanced - Milton Keynes Excel Training Courses
SSIS Milton Keynes Training Courses