Enable Technology

ACCESS ACCRINGTON TRAINING COURSES 

ACCESS TRAINING COURSES ACCRINGTON




About Enable Technology Accrington Access Training Courses

We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We will issue each Access training participant with learning resources which they can refer to post training. 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. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a socially distanced training location in Accrington. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Total Telecommunications Limited, Birmingham City University, TalkTalk Direct Limited, Norfolk Police Constabulary, Canadian High Commission, Countrywide Homes Limited, DHL Express and Royal Air Force.




Microsoft Access

  • 2 day course
  • Location: Accrington
  • Telephone on 01952 305730
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • An Introduction to VBA
    Aggregation Queries
    Sorting and Filtering
    Using a Navigation Form
    Navigation Pane Protection
    Creating a Relational Database
    Macros on Forms
    Database Security
    Modifying Table Structures
    Database Wellness
    Designing a Lookup Database
    Multi Table Queries
    Creating Queries
    Creating and Using Reports
    Data Validation
    Formatting Tables
    Parameter Queries
    Working With Records
    Creating a Lookup Database
    Adding Records to a Table
    Getting to Know Access 

  • See Training Course Details...


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 ...
  • Creating a Function Procedure
    Understanding the Development Environment
    Working with the ADODB Recordset Object
    Navigating the Access Object Hierarchy
    Understanding Error Handling
    Using the Do...Loop Structure
    Working with Variable Scope
    Using Input Boxes
    Understanding VBA's Error Trapping Options
    Why Program in Access?
    Using Intrinsic Constants
    Working with Methods
    Working with Procedures and Functions
    Understanding Classes and Objects
    Working with Recordsets
    Organizing Code and Procedures
    Understanding Recordset Cursor Properties - Optional
    Creating a Standard Module
    Using the Immediate Window to Call Procedures
    Debugging Code

  • See Training Course Details...



Email us about this courses



Other Accrington Enable Technology Training Courses

VBA Accrington Training Courses
DAX - Accrington Excel Training Courses
Crystal 2013 Accrington Training Courses
Excel Advanced - Accrington Excel Training Courses
SSIS 2014 Accrington Training Courses
SSAS 2005 Accrington Training Courses



North West - Possible Access Training Course Locations


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

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