Enable Technology

ACCESS ELLESMERE PORT TRAINING COURSES 

ACCESS TRAINING COURSES ELLESMERE PORT




About Enable Technology Ellesmere Port Access Training Courses

We have a twenty year history of providing skills based Access industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each Access training participant with learning resources which they can refer to post training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the Access course at a socially distanced local training venue in Ellesmere Port. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are GKN PLC, Barclays Bank PLC, University of Birmingham, Royal Air Force, Vodafone Group Services, Cadbury PLC, Shell UK Oil Products Ltd and Countrywide Homes Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ellesmere Port
  • 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 ...
  • Working with Inline Error Handling
    Working with Methods
    Using the With Statement
    Understanding Modules
    Understanding Classes and Objects
    Understanding Procedures
    Specifying a Recordset Cursor Location - Optional
    Why Program in Access?
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Data Types
    Working with Boolean Expressions
    Understanding the Form Object
    Working with Recordsets
    Understanding Objects
    Using the For Each...Next Structure
    Creating a Function Procedure
    Understanding the Development Environment
    Understanding Recordset Cursor Properties - Optional
    Understanding Expressions and Statements
    Working with Events

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Ellesmere Port
  • 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 ...
  • Creating a Lookup Database
    Macros on Forms
    Database Security
    Adding Records to a Table
    Modifying Forms
    Aggregation Queries
    Adding Transactional Records
    Creating and Using Reports
    Querying Techniques
    Modifying Table Structures
    Macro Techniques
    Setting Table Relationships
    Action Queries
    Database Wellness
    Creating and Using Macros
    Creating Queries
    Understanding VBA
    DIY Forms
    Getting to Know Access 
    Calculations in Queries
    Importing and Exporting Records

  • See Training Course Details...



Email us about this courses



Other Ellesmere Port Enable Technology Training Courses

Project 2016 L1 Ellesmere Port Training Courses
SSAS 2017 - Ellesmere Port SQL Server Analysis Services Training Courses
DAX Ellesmere Port Training Courses
Excel Basic Ellesmere Port Training Courses
TSQL - Ellesmere Port SQL Training Courses
Microsoft Project Level 2 - Ellesmere Port Microsoft Project Training Courses



North West - Possible Access Training Course Locations


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

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