Enable Technology



About Enable Technology Leicester Access Training Courses

Enable Technology specialise in succinct skills based Access training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a socially distanced venue near you in Leicester. We are happy to modify the Access syllabus to match your teams training requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Shell UK Oil Products Ltd, Aston University, Wolverhampton City Council, Cadbury PLC, Royal Air Force, Carillion PLC, Queen's Medical Centre Nottingham and Norfolk Police Constabulary.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Leicester
  • 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 Input Boxes
    Understanding the Err Object
    Using Debugging Tools
    Guidelines for use of Branching Structures
    Trapping Errors with the On Error Statement
    Debugging Code
    Understanding the DoCmd Object
    Understanding Errors
    Understanding Objects
    Understanding Data Types
    Using Intrinsic Constants
    Specifying a Recordset Cursor Type
    Working with Events
    Working with Boolean Expressions
    Creating a Function Procedure
    Declaring and Creating Object Variables
    Handling Errors
    Using Intrinsic Functions

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Leicester
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Macros on Forms
    Creating Queries
    Adding Transactional Records
    Modifying Table Structures
    Creating and Using Forms
    Macro Techniques
    Parameter Queries
    Understanding VBA
    Adding Records to a Table
    Database Wellness
    Creating a Relational Database
    Getting to Know Access 
    Creating and Using Macros
    Action Queries
    Creating a Lookup Database
    Sorting and Filtering
    An Introduction to VBA
    Data Validation
    Aggregation Queries
    Setting Table Relationships
    Formatting Tables

  • See Training Course Details...

Email us about this courses

Other Leicester Enable Technology Training Courses

Excel 365 Intermediate - Leicester Excel Training Courses
TSQL Leicester Training Courses
Excel 365 Basic Leicester Training Courses
Oracle SQL - Leicester SQL Training Courses
Report Builder - Leicester SQL Server Reporting Services Training Courses
SSIS - Leicester SQL Server Integration Services Training Courses