Enable Technology

ACCESS NEWCASTLE UNDER LYME TRAINING COURSES 

ACCESS TRAINING COURSES NEWCASTLE UNDER LYME




About Enable Technology Newcastle Under Lyme Access Training Courses

We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Newcastle Under Lyme. We are happy to modify the Access syllabus to match your teams training requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Homeserve PLC, Queen's Medical Centre Nottingham, Halfords Group PLC, National Power PLC, West Bromwich Building Society, Barclays Bank PLC, Aston University and Boots UK Limited.




Microsoft Access

  • 2 day course
  • Location: Newcastle Under Lyme
  • 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 ...
  • Macro Techniques
    Macros on Forms
    Action Queries
    Formatting Tables
    Getting to Know Access 
    Setting Table Relationships
    DIY Forms
    An Introduction to VBA
    Data Validation
    Adding Records to a Table
    Creating a Relational Database
    Working With Records
    Navigation Pane Protection
    Importing and Exporting Records
    Adding Transactional Records
    Using a Navigation Form
    Creating a Lookup Database
    Creating and Using Reports
    Database Wellness
    Database Security
    Multi Table Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Newcastle Under Lyme
  • 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 ...
  • Using the Select Case...End Select Structure
    Declaring and Creating Object Variables
    Considering Variable Scope and Lifetime Together
    Using Intrinsic Constants
    Using the CacheSize Property - Optional
    Using the With Statement
    Using the Do...Loop Structure
    Using Visual Basic Help
    Determining the Value of Expressions
    Creating a Standard Module
    Understanding Modules
    Working with the ADODB Recordset Object
    Debugging Code
    Introduction to Programming in Access
    Understanding Procedures
    Working with Procedures and Functions
    Working with Methods
    Understanding Collections
    Handling Errors
    Working with Inline Error Handling

  • See Training Course Details...



Email us about this courses



Other Newcastle Under Lyme Enable Technology Training Courses

SSAS 2005 Newcastle Under Lyme Training Courses
Microsoft Project Level 2 Newcastle Under Lyme Training Courses
DAX - Newcastle Under Lyme Excel Training Courses
Excel Advanced - Newcastle Under Lyme Excel Training Courses
TSQL - Newcastle Under Lyme SQL Training Courses
Data Mining - Newcastle Under Lyme Data Analytics Training Courses



Midlands - Possible Access Training Course Locations


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

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