Enable Technology

ACCESS SALE TRAINING COURSES 

ACCESS TRAINING COURSES SALE




About Enable Technology Sale Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Sale. Every Access course can be modified to meet your bespoke requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Lloyds TSB Bank PLC, Norfolk Police Constabulary, Birmingham City Council, GKN PLC, Nationwide Building Society Limited, Boots UK Limited, Royal & Sun Alliance Group PLC and University of Birmingham.




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 ...
  • Understanding Constants
    Working with the Application Object
    Writing an Error-Handling Routine
    Understanding Expressions and Statements
    Using the With Statement
    Working with the ADODB Recordset Object
    Working with Procedures and Functions
    Considering Variable Scope and Lifetime Together
    Using the CacheSize Property - Optional
    Using Message Boxes
    Using the For Each...Next Structure
    Understanding Data Types
    Understanding Objects
    Working with Methods
    Guidelines for use of Branching Structures
    Declaring and Creating Object Variables
    Introduction to Programming in Access

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Sale
  • 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 ...
  • DIY Forms
    An Introduction to VBA
    Parameter Queries
    Creating and Using Forms
    Adding Records to a Table
    Macros on Forms
    Setting Table Relationships
    Database Wellness
    Creating Queries
    Formatting Tables
    Sorting and Filtering
    Data Validation
    Using a Navigation Form
    Creating a Relational Database
    Designing a Lookup Database
    Getting to Know Access 
    Creating and Using Macros
    Modifying Forms
    Macro Techniques
    Aggregation Queries
    Importing and Exporting Records

  • See Training Course Details...



Email us about this courses



Other Sale Enable Technology Training Courses

SSIS 2014 Sale Training Courses
Power Query - Sale Excel Training Courses
SSAS Tabular Sale Training Courses
Mobile Sale Training Courses
Report Builder Sale Training Courses
Power Graphics Sale Training Courses



North West - Possible Access Training Course Locations


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

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