Enable Technology

ACCESS LANCASTER TRAINING COURSES 

ACCESS TRAINING COURSES LANCASTER




About Enable Technology Lancaster Access Training Courses

We are a company that provides short intensive Access training courses. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and Access course resources that can be referenced post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. We can also deliver the Access course at a socially distanced local training venue in Lancaster. Every Access course can be modified to meet your bespoke 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 Nuclear Engineering Services, Loughborough University, Royal & Sun Alliance Group PLC, Fujistu PLC, Nationwide Building Society Limited, University of Birmingham, TalkTalk Direct Limited and South Staffordshire Water PLC.




Microsoft Access

  • 2 day course
  • Location: Lancaster
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Setting Table Relationships
    Navigation Pane Protection
    Creating and Using Forms
    Importing and Exporting Records
    Designing a Lookup Database
    Formatting Tables
    Working With Records
    Aggregation Queries
    Modifying Forms
    DIY Forms
    Creating a Lookup Database
    Querying Techniques
    Database Wellness
    Parameter Queries
    Relational Database Design
    Database Security
    Adding Transactional Records
    Multi Table Queries
    Creating Queries
    Data Validation
    Adding Records to a Table

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lancaster
  • 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 ...
  • Working with Events
    Using Message Boxes
    Understanding Control-of-Flow Structures
    Declaring Variables
    Specifying a Recordset Cursor Location - Optional
    Determining the Value of Expressions
    Introduction to Programming in Access
    Using the Immediate Window to Call Procedures
    Using the Do...Loop Structure
    Understanding the DoCmd Object
    Writing an Error-Handling Routine
    Understanding Objects
    Locking Records for Updating
    Using the Select Case...End Select Structure
    Setting Break Expressions
    Creating a Sub Procedure
    Stepping through Code
    Guidelines for use of Branching Structures

  • See Training Course Details...



Email us about this courses



Other Lancaster Enable Technology Training Courses

Microsoft Project Level 3 Lancaster Training Courses
PowerPoint Advanced - Lancaster Office Training Courses
Crystal 2016 - Lancaster Crystal Reports Training Courses
CSS Lancaster Training Courses
JavaScript - Lancaster JavaScript Training Courses
Crystal 2011 Lancaster Training Courses



North West - Possible Access Training Course Locations


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

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