Enable Technology

ACCESS CANNOCK TRAINING COURSES 

ACCESS TRAINING COURSES CANNOCK




About Enable Technology Cannock Access Training Courses

We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a socially distanced venue near you in Cannock. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time 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 Birmingham Heartlands Hospital, DHL Express, Carillion PLC, Dollond & Aitchison Limited, West Bromwich Building Society, Nuclear Engineering Services, Unipart Group and South Staffordshire Water PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cannock
  • 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 ...
  • Guidelines for use of Branching Structures
    Setting Breakpoints
    Understanding Error Handling
    Understanding the Form Object
    Understanding Expressions and Statements
    Considering Variable Scope and Lifetime Together
    Creating a Function Procedure
    Using the Immediate Window to Call Procedures
    Writing an Error-Handling Routine
    Creating a Sub Procedure
    Understanding VBA's Error Trapping Options
    Working with Variable Lifetime
    Using the CacheSize Property - Optional
    Trapping Errors with the On Error Statement
    Using Message Boxes
    Controlling Program Execution
    Determining the Value of Expressions
    Introduction to Programming in Access
    Working with Recordsets
    Working with the Code Editor

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Cannock
  • 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 ...
  • Parameter Queries
    DIY Forms
    Macros on Forms
    Calculations in Queries
    Database Wellness
    Modifying Forms
    Relational Database Design
    Importing and Exporting Records
    Data Validation
    Modifying Table Structures
    Database Security
    Navigation Pane Protection
    Working With Records
    Designing a Lookup Database
    Sorting and Filtering
    Creating and Using Forms
    Setting Table Relationships
    Adding Records to a Table
    Adding Transactional Records
    Querying Techniques
    Getting to Know Access 

  • See Training Course Details...



Email us about this courses



Other Cannock Enable Technology Training Courses

Crystal XI - Cannock Crystal Reports Training Courses
Oracle SQL Cannock Training Courses
SSIS 2014 Cannock Training Courses
Microsoft Project Level 2 - Cannock Microsoft Project Training Courses
SSRS 2005 Cannock Training Courses
Excel Advanced Cannock Training Courses



Midlands - Possible Access Training Course Locations


Birmingham Access Training Courses
Northhampton Access Training Courses
Kidderminster Access Training Courses
Crewe Access Training Courses
Shrewsbury Access Training Courses
Stoke On Trent Access Training Courses
Leicester Access Training Courses
Tamworth Access Training Courses
Droitwich Access Training Courses
Evesham Access Training Courses
Warwick Access Training Courses
Herefordshire Access Training Courses
Bromsgrove Access Training Courses
Wolverhampton Access Training Courses
Midlands Access Training Courses
Sandwell Access Training Courses
Solihull Access Training Courses
Bridgnorth Access Training Courses
Shropshire Access Training Courses
Halesowen Access Training Courses
Cannock Access Training Courses
Redditch Access Training Courses
Black Country Access Training Courses
Kidsgrove Access Training Courses
Lichfield Access Training Courses
Stourbridge Access Training Courses
Staffordshire Access Training Courses
Bedworth Access Training Courses
Leamington Spa Access Training Courses
Newcastle Under Lyme Access Training Courses
Warwickshire Access Training Courses
Worcestershire Access Training Courses
Leicestershire Access Training Courses
Walsall Access Training Courses
Coventry Access Training Courses
Nuneaton Access Training Courses
Rugby Access Training Courses
Tipton Access Training Courses
Oxford Access Training Courses
Wednesbury Access Training Courses
Stafford Access Training Courses
East Midlands Access Training Courses
Uttoxeter Access Training Courses
Oswestry Access Training Courses
Hereford Access Training Courses
Kenilworth Access Training Courses
Rowley Access Training Courses
Milton Keynes Access Training Courses
West Midlands Access Training Courses
Smethwick Access Training Courses
Telford Access Training Courses
Burton On Trent Access Training Courses
Stourbridge Access Training Courses
West Bromwich Access Training Courses
Rugeley Access Training Courses
Dudley Access Training Courses
Staffordshire Access Training Courses
Leek Access Training Courses
Stratford Upon Avon Access Training Courses
Atherstone Access Training Courses
Cheltenham Access Training Courses
Chester Access Training Courses
Malvern Access Training Courses
Nottingham Access Training Courses
Worcester Access Training Courses
Derby Access Training Courses

Birmingham, Northhampton, Kidderminster, Crewe, Shrewsbury, Stoke On Trent, Leicester, Tamworth, Droitwich, Evesham, Warwick, Herefordshire, Bromsgrove, Wolverhampton, Midlands, Sandwell, Solihull, Bridgnorth, Shropshire, Halesowen, Cannock, Redditch, Black Country, Kidsgrove, Lichfield, Stourbridge, Staffordshire, Bedworth, Leamington Spa, Newcastle Under Lyme, Warwickshire, Worcestershire, Leicestershire, Walsall, Coventry, Nuneaton, Rugby, Tipton, Oxford, Wednesbury, Stafford, East Midlands, Uttoxeter, Oswestry, Hereford, Kenilworth, Rowley, Milton Keynes, West Midlands, Smethwick, Telford, Burton On Trent, Stourbridge, West Bromwich, Rugeley, Dudley, Staffordshire, Leek, Stratford Upon Avon, Atherstone, Cheltenham, Chester, Malvern, Nottingham, Worcester, Derby