Enable Technology



About Enable Technology Yorkshire Access Training Courses

Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Enable Technology offers instructor led training taught by technology specialists. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Yorkshire. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Yell Group PLC, Keele University, Total Telecommunications Limited, DHL Express, Countrywide Homes Limited, EDF Energy PLC, Vodafone Group Services and Queen's Medical Centre Nottingham.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Yorkshire
  • Telephone on 01952 305730
  • 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 ...
  • Using Intrinsic Functions
    Understanding Objects
    Working with Procedures and Functions
    Understanding Error Handling
    Working with Events
    Locking Records for Updating
    Understanding Modules
    Working with Variable Lifetime
    Creating a Standard Module
    Using the CacheSize Property - Optional
    Guidelines for use of Branching Structures
    Working with Variable Scope
    Calling Procedures
    Determining the Value of Expressions
    Understanding Classes and Objects
    Understanding the Err Object
    Understanding the Development Environment
    Working with Methods
    Using the Immediate Window to Call Procedures

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Yorkshire
  • Telephone on 01952 305730
  • 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 ...
  • Adding Records to a Table
    Working With Records
    Aggregation Queries
    Importing and Exporting Records
    Creating a Lookup Database
    Macro Techniques
    Navigation Pane Protection
    Adding Transactional Records
    Getting to Know Access 
    Modifying Table Structures
    Action Queries
    Understanding VBA
    Setting Table Relationships
    Multi Table Queries
    Using a Navigation Form
    Sorting and Filtering
    Formatting Tables
    An Introduction to VBA
    Data Validation
    Macros on Forms
    Creating and Using Reports

  • See Training Course Details...

Email us about this courses

Other Yorkshire Enable Technology Training Courses

Excel Power Pivot - Yorkshire Excel Training Courses
SQL Yorkshire Training Courses
Project 2016 L1 - Yorkshire Microsoft Project Training Courses
HTML - Yorkshire Web Development Training Courses
Power BI - Yorkshire Microsoft Power BI Training Courses
Excel Basic Yorkshire Training Courses

North - Possible Access Training Course Locations

Halifax Access Training Courses
Grimsby Access Training Courses
Harrogate Access Training Courses
Huddersfield Access Training Courses
Sheffield Access Training Courses
Leeds Access Training Courses
Gateshead Access Training Courses
Normanton Access Training Courses
Wetherby Access Training Courses
Scarborough Access Training Courses
Durham Access Training Courses
Batley Access Training Courses
Yorkshire Access Training Courses
Rotherham Access Training Courses
Wakefield Access Training Courses
Newcastle Upon Tyne Access Training Courses
North East Access Training Courses
Dewsbury Access Training Courses
Castleford Access Training Courses
Hartlepool Access Training Courses
Doncaster Access Training Courses
Pudsey Access Training Courses
Keighley Access Training Courses
Bridlington Access Training Courses
Middlesbrough Access Training Courses
York Access Training Courses
Scunthorpe Access Training Courses
South Shields Access Training Courses
Barnsley Access Training Courses
Hexham Access Training Courses
Sunderland Access Training Courses

Halifax, Grimsby, Harrogate, Huddersfield, Sheffield, Leeds, Gateshead, Normanton, Wetherby, Scarborough, Durham, Batley, Yorkshire, Rotherham, Wakefield, Newcastle Upon Tyne, North East, Dewsbury, Castleford, Hartlepool, Doncaster, Pudsey, Keighley, Bridlington, Middlesbrough, York, Scunthorpe, South Shields, Barnsley, Hexham, Sunderland