Enable Technology



About Enable Technology Barnsley Access Training Courses

We offer intensive two and three days Access courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with Access training materials which they keep after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Enable Technology offers instructor led training taught by technology specialists. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a Access course at an alternative training site in Barnsley. All Access courses can be customised to meet your particular requirements.

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

Our teaching team have over twenty years continuous technical training experience. Our clients include: Nuclear Engineering Services, Countrywide Homes Limited, EDF Energy PLC, Carillion PLC, Total Telecommunications Limited, Shell UK Oil Products Ltd, Unipart Group and Lloyds TSB Bank PLC.

Microsoft Access

  • 2 day course
  • Location: Barnsley
  • 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 Transactional Records
    An Introduction to VBA
    Querying Techniques
    Database Security
    Creating and Using Reports
    Macros on Forms
    Creating Queries
    Designing a Lookup Database
    Calculations in Queries
    Modifying Table Structures
    Multi Table Queries
    Parameter Queries
    Action Queries
    Creating a Lookup Database
    Understanding VBA
    Aggregation Queries
    DIY Forms
    Macro Techniques
    Navigation Pane Protection
    Importing and Exporting Records
    Relational Database Design

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Barnsley
  • Telephone on 01952 305730
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Navigating the Access Object Hierarchy
    Creating a Standard Module
    Working with Variable Scope
    Declaring and Creating Object Variables
    Organizing Code and Procedures
    Understanding VBA's Error Trapping Options
    Using Intrinsic Functions
    Understanding Expressions and Statements
    Understanding Classes and Objects
    Using the With Statement
    Creating a Function Procedure
    Working with the ADODB Recordset Object
    Debugging Code
    Handling Errors
    Specifying a Recordset Cursor Type
    Using the Object Browser
    Using the For...Next Structure

  • See Training Course Details...

Email us about this courses

Other Barnsley Enable Technology Training Courses

Excel Intermediate Barnsley Training Courses
Microsoft Project Level 2 - Barnsley Microsoft Project Training Courses
JQuery Mobile - Barnsley JavaScript Training Courses
Power BI - Barnsley Microsoft Power BI Training Courses
Power Query - Barnsley Excel Training Courses
SSRS 2005 - Barnsley SQL Server Reporting Services Training Courses

North - Possible Access Training Course Locations

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

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