Enable Technology



About Enable Technology Carlisle Access Training Courses

Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. Another option is we can organise a local socially distanced training site in Carlisle. The Access syllabus can be modified to accommodate your specific training needs.

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

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Halfords Group PLC, Lloyds TSB Bank PLC, Loughborough University, Wolverhampton City Council, Boots UK Limited, TalkTalk Direct Limited, Unipart Group and Capita Group PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Carlisle
  • 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 ...
  • Understanding Control-of-Flow Structures
    Considering Variable Scope and Lifetime Together
    Working with Events
    Creating a Standard Module
    Using Visual Basic Help
    Stepping through Code
    Organizing Code and Procedures
    Working with the Application Object
    Using the If...End If Decision Structures
    Using Debugging Tools
    Determining the Value of Expressions
    Guidelines for use of Branching Structures
    Debugging Code
    Writing an Error-Handling Routine
    Trapping Errors with the On Error Statement
    Working with Boolean Expressions
    Creating a Function Procedure
    Working with Procedures and Functions
    Using Intrinsic Constants

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Carlisle
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • DIY Forms
    Database Security
    Relational Database Design
    Creating and Using Macros
    Adding Transactional Records
    Using a Navigation Form
    Understanding VBA
    Macro Techniques
    Creating and Using Forms
    Creating and Using Reports
    Setting Table Relationships
    Importing and Exporting Records
    Database Wellness
    Sorting and Filtering
    Modifying Table Structures
    Adding Records to a Table
    Creating Queries
    Creating a Lookup Database
    Formatting Tables
    Creating a Relational Database
    Aggregation Queries

  • See Training Course Details...

Email us about this courses

Other Carlisle Enable Technology Training Courses

DAX Carlisle Training Courses
SQL Carlisle Training Courses
TSQL Carlisle Training Courses
Excel 365 Advanced - Carlisle Excel Training Courses
SSAS Carlisle Training Courses
Power Query Carlisle Training Courses