Enable Technology

ACCESS LIVERPOOL TRAINING COURSES 

ACCESS TRAINING COURSES LIVERPOOL




About Enable Technology Liverpool Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. 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. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in Liverpool. We are happy to modify the Access syllabus to match your teams training requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Wolverhampton City Council, Carillion PLC, Queen's Medical Centre Nottingham, Royal & Sun Alliance Group PLC, Total Telecommunications Limited, DHL Express, Keele University and EDF Energy PLC.




Microsoft Access

  • 2 day course
  • Location: Liverpool
  • 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
    Formatting Tables
    Aggregation Queries
    Creating a Lookup Database
    An Introduction to VBA
    Sorting and Filtering
    Adding Transactional Records
    Designing a Lookup Database
    Getting to Know Access 
    Creating and Using Macros
    Adding Records to a Table
    Macro Techniques
    Creating Queries
    Creating and Using Reports
    Multi Table Queries
    Macros on Forms
    DIY Forms
    Database Security
    Parameter Queries
    Working With Records
    Importing and Exporting Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Liverpool
  • Telephone on 01952 305730
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Considering Variable Scope and Lifetime Together
    Working with Variable Lifetime
    Locking Records for Updating
    Trapping Errors with the On Error Statement
    Writing an Error-Handling Routine
    Using Debugging Tools
    Specifying a Recordset Cursor Type
    Creating a Function Procedure
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Data Types
    Using Intrinsic Functions
    Handling Errors
    Debugging Code
    Using the CacheSize Property - Optional
    Creating a Sub Procedure
    Organizing Code and Procedures
    Working with Methods
    Guidelines for use of Branching Structures
    Understanding Procedures

  • See Training Course Details...



Email us about this courses



Other Liverpool Enable Technology Training Courses

Visio 2013 Liverpool Training Courses
Crystal 2011 - Liverpool Crystal Reports Training Courses
Excel Power Pivot Liverpool Training Courses
Excel Basic Liverpool Training Courses
Microsoft Project Level 2 - Liverpool Microsoft Project Training Courses
Report Builder - Liverpool SQL Server Reporting Services Training Courses



North West - Possible Access Training Course Locations


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

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