Enable Technology



About Enable Technology Durham Access Training Courses

We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Durham. Every Access course can be modified to meet your bespoke 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 Barclays Bank PLC, Carillion PLC, West Bromwich Building Society, Aston University, Keele University, Norwich Union PLC, Birmingham City Council and Royal Air Force.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Durham
  • Telephone on 01952 305730
  • 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 ...
  • Controlling Program Execution
    Working with Procedures and Functions
    Understanding Error Handling
    Working with Variable Scope
    Using Input Boxes
    Understanding Classes and Objects
    Specifying a Recordset Cursor Type
    Declaring Variables
    Creating a Standard Module
    Using the For Each...Next Structure
    Handling Errors
    Using the Object Browser
    Understanding the Order of Events
    Considering Variable Scope and Lifetime Together
    Using Break Mode during Run Mode
    Using Intrinsic Functions
    Why Program in Access?
    Working with Recordsets
    Using the Select Case...End Select Structure

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Durham
  • Telephone on 01952 305730
  • 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 ...
  • An Introduction to VBA
    Database Security
    Macro Techniques
    Using a Navigation Form
    Data Validation
    Creating and Using Macros
    Formatting Tables
    Setting Table Relationships
    DIY Forms
    Creating Queries
    Creating and Using Reports
    Relational Database Design
    Multi Table Queries
    Parameter Queries
    Creating a Relational Database
    Getting to Know Access 
    Aggregation Queries
    Understanding VBA
    Designing a Lookup Database
    Macros on Forms
    Creating a Lookup Database

  • See Training Course Details...

Email us about this courses

Other Durham Enable Technology Training Courses

SSAS 2017 - Durham SQL Server Analysis Services Training Courses
SSRS 2008 Durham Training Courses
Power Query Durham Training Courses
HTML Durham Training Courses
Mobile Durham Training Courses
DAX Durham Training Courses

North - Possible Access Training Course Locations

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

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