Enable Technology

ACCESS LANCASTER TRAINING COURSES 

ACCESS TRAINING COURSES LANCASTER




About Enable Technology Lancaster Access Training Courses

Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Lancaster. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Fujistu PLC, Nationwide Building Society Limited, Royal Air Force, Wolverhampton City Council, Loughborough University, Dollond & Aitchison Limited, Carillion PLC and South Staffordshire Water PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lancaster
  • Telephone on 01952 305730
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Creating a Sub Procedure
    Handling Errors
    Working with Recordsets
    Writing an Error-Handling Routine
    Working with the Code Editor
    Understanding Control-of-Flow Structures
    Working with Properties
    Working with the ADODB Recordset Object
    Understanding Procedures
    Understanding Modules
    Determining the Value of Expressions
    Understanding the Err Object
    Using Intrinsic Functions
    Understanding the Development Environment
    Understanding Objects
    Controlling Program Execution
    Trapping Errors with the On Error Statement
    Using the If...End If Decision Structures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Lancaster
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Multi Table Queries
    Creating Queries
    Aggregation Queries
    Navigation Pane Protection
    DIY Forms
    Action Queries
    Working With Records
    Adding Transactional Records
    An Introduction to VBA
    Macro Techniques
    Relational Database Design
    Database Security
    Creating and Using Macros
    Parameter Queries
    Using a Navigation Form
    Creating and Using Forms
    Modifying Table Structures
    Macros on Forms
    Creating and Using Reports
    Designing a Lookup Database
    Querying Techniques

  • See Training Course Details...



Email us about this courses



Other Lancaster Enable Technology Training Courses

CSS Lancaster Training Courses
Data Mining Lancaster Training Courses
TSQL Lancaster Training Courses
SSIS 2005 - Lancaster SQL Server Integration Services Training Courses
SSRS 2014 Lancaster Training Courses
Power Graphics - Lancaster Data Analytics Training Courses



North West - Possible Access Training Course Locations


Salford Access Training Courses
Crosby Access Training Courses
Rochdale Access Training Courses
Morecambe Access Training Courses
Altrincham Access Training Courses
Lytham Urmston Access Training Courses
Lancashire Access Training Courses
Winsford Access Training Courses
Chorley Access Training Courses
Stockport Access Training Courses
Accrington Access Training Courses
Stretford Access Training Courses
Farnworth Access Training Courses
Widnes Access Training Courses
Ashton-under-Lyne Access Training Courses
Cheshire Access Training Courses
Sale Access Training Courses
Wigan Access Training Courses
Bootle Access Training Courses
North West Access Training Courses
Eccles Access Training Courses
Kirkby Access Training Courses
Bolton Access Training Courses
Chadderton Access Training Courses
Warrington Access Training Courses
Wallasey Access Training Courses
Prestwich Access Training Courses
Skelmersdale Access Training Courses
Northwich Access Training Courses
Liverpool Access Training Courses
Southport Access Training Courses
Hyde Access Training Courses
Thornton-Cleveleys Access Training Courses
Barrow-in-Furness Access Training Courses
Middleton Access Training Courses
Carlisle Access Training Courses
Blackpool Access Training Courses
Preston Access Training Courses
Macclesfield Access Training Courses
Chester Access Training Courses
Merseyside Access Training Courses
Denton Access Training Courses
Saddleworth Access Training Courses
Burnley Access Training Courses
Huyton Access Training Courses
Runcorn Access Training Courses
Birkenhead Access Training Courses
Leyland Access Training Courses
Bury Access Training Courses
Oldham Access Training Courses
Lancaster Access Training Courses
Crewe Access Training Courses
Ellesmere Port Access Training Courses
Blackburn Access Training Courses
Wythenshawe Access Training Courses
Leigh Access Training Courses
Manchester Access Training Courses

Salford, Crosby, Rochdale, Morecambe, Altrincham, Lytham Urmston, Lancashire, Winsford, Chorley, Stockport, Accrington, Stretford, Farnworth, Widnes, Ashton-under-lyne, Cheshire, Sale, Wigan, Bootle, North West, Eccles, Kirkby, Bolton, Chadderton, Warrington, Wallasey, Prestwich, Skelmersdale, Northwich, Liverpool, Southport, Hyde, Thornton-cleveleys, Barrow-in-furness, Middleton, Carlisle, Blackpool, Preston, Macclesfield, Chester, Merseyside, Denton, Saddleworth, Burnley, Huyton, Runcorn, Birkenhead, Leyland, Bury, Oldham, Lancaster, Crewe, Ellesmere Port, Blackburn, Wythenshawe, Leigh, Manchester