Enable Technology

ACCESS SALE TRAINING COURSES 

ACCESS TRAINING COURSES SALE




About Enable Technology Sale Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Access courseware which they can refer to after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a socially distanced training location in Sale. Every Access course can be modified to meet your bespoke requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Wolverhampton City Council, GKN PLC, Countrywide Homes Limited, Lloyds TSB Bank PLC, Nuclear Engineering Services, Barclays Bank PLC, Norwich Union PLC and Dollond & Aitchison Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Sale
  • 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 ...
  • Setting Breakpoints
    Working with Boolean Expressions
    Using the Immediate Window to Call Procedures
    Controlling Program Execution
    Using Message Boxes
    Understanding the Form Object
    Writing an Error-Handling Routine
    Declaring Variables
    Determining the Value of Expressions
    Using the Object Browser
    Understanding Recordset Cursor Properties - Optional
    Handling Errors
    Understanding Error Handling
    Using Expressions, Variables, and Intrinsic Functions
    Navigating the Access Object Hierarchy
    Working with Properties
    Trapping Errors with the On Error Statement
    Working with Variable Scope
    Understanding Constants
    Specifying a Recordset Cursor Location - Optional

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Sale
  • 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 ...
  • Relational Database Design
    Data Validation
    Getting to Know Access 
    Macros on Forms
    Working With Records
    Creating a Relational Database
    Setting Table Relationships
    Importing and Exporting Records
    An Introduction to VBA
    Calculations in Queries
    Navigation Pane Protection
    Designing a Lookup Database
    Modifying Table Structures
    Adding Records to a Table
    Action Queries
    Creating a Lookup Database
    Database Wellness
    DIY Forms
    Creating and Using Macros
    Multi Table Queries
    Sorting and Filtering

  • See Training Course Details...



Email us about this courses



Other Sale Enable Technology Training Courses

SSRS 2016 Sale Training Courses
SSAS 2008 - Sale SQL Server Analysis Services Training Courses
SSRS 2005 - Sale SQL Server Reporting Services Training Courses
Crystal 2013 - Sale Crystal Reports Training Courses
PL/SQL - Sale SQL Training Courses
SSIS 2008 - Sale SQL Server Integration Services Training Courses



North West - Possible Access Training Course Locations


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

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