Enable Technology

ACCESS ACCRINGTON TRAINING COURSES 

ACCESS TRAINING COURSES ACCRINGTON




About Enable Technology Accrington Access Training Courses

We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a socially distanced local training venue in Accrington. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Queen's Medical Centre Nottingham, Unipart Group, Shell UK Oil Products Ltd, Birmingham City University, Birmingham Heartlands Hospital, Birmingham City Council, Norfolk Police Constabulary and Aston University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Accrington
  • 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 Events
    Organizing Code and Procedures
    Understanding VBA's Error Trapping Options
    Creating a Function Procedure
    Understanding Errors
    Writing an Error-Handling Routine
    Guidelines for use of Branching Structures
    Why Program in Access?
    Understanding the Order of Events
    Understanding Recordset Cursor Properties - Optional
    Using Input Boxes
    Determining the Value of Expressions
    Navigating the Access Object Hierarchy
    Understanding Error Handling
    Using the Do...Loop Structure
    Working with Properties
    Setting Break Expressions
    Using the CacheSize Property - Optional
    Considering Variable Scope and Lifetime Together

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Accrington
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Working With Records
    Navigation Pane Protection
    Getting to Know Access 
    Macro Techniques
    Adding Records to a Table
    Action Queries
    Sorting and Filtering
    An Introduction to VBA
    Using a Navigation Form
    Creating a Relational Database
    Adding Transactional Records
    Querying Techniques
    Database Security
    Data Validation
    Setting Table Relationships
    Designing a Lookup Database
    Database Wellness
    Creating and Using Reports
    Modifying Forms
    Multi Table Queries
    Aggregation Queries

  • See Training Course Details...



Email us about this courses



Other Accrington Enable Technology Training Courses

SSRS 2016 - Accrington SQL Server Reporting Services Training Courses
CSS Accrington Training Courses
JQuery Mobile Accrington Training Courses
Oracle SQL Accrington Training Courses
Data Warehouse Accrington Training Courses
SSAS 2008 - Accrington SQL Server Analysis Services Training Courses



North West - Possible Access Training Course Locations


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

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