Enable Technology

ACCESS LYTHAM URMSTON TRAINING COURSES 

ACCESS TRAINING COURSES LYTHAM URMSTON




About Enable Technology Lytham Urmston Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in Lytham Urmston. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

We have operated primarily in the West Midlands for twenty years. Some of our clients are TalkTalk Direct Limited, Capita Group PLC, DHL Express, Aston University, Birmingham City University, Boots UK Limited, Loughborough University and Royal & Sun Alliance Group PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lytham Urmston
  • 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 ...
  • Using Expressions, Variables, and Intrinsic Functions
    Writing an Error-Handling Routine
    Working with Procedures and Functions
    Stepping through Code
    Understanding Recordset Cursor Properties - Optional
    Locking Records for Updating
    Using Visual Basic Help
    Understanding Error Handling
    Understanding the Err Object
    Using the For...Next Structure
    Creating a Standard Module
    Working with Variable Lifetime
    Working with Methods
    Understanding VBA's Error Trapping Options
    Understanding Objects
    Understanding Data Types
    Understanding Collections
    Creating a Sub Procedure
    Understanding Control-of-Flow Structures
    Organizing Code and Procedures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Lytham Urmston
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Creating and Using Forms
    Querying Techniques
    Parameter Queries
    Getting to Know Access 
    DIY Forms
    Using a Navigation Form
    Importing and Exporting Records
    Creating a Lookup Database
    Database Wellness
    Creating Queries
    Understanding VBA
    Creating a Relational Database
    Aggregation Queries
    Modifying Table Structures
    Macros on Forms
    Formatting Tables
    An Introduction to VBA
    Macro Techniques
    Adding Transactional Records
    Sorting and Filtering
    Calculations in Queries

  • See Training Course Details...



Email us about this courses



Other Lytham Urmston Enable Technology Training Courses

SSRS 2008 Lytham Urmston Training Courses
Microsoft Project Level 3 Lytham Urmston Training Courses
Visio 2013 Lytham Urmston Training Courses
PowerPoint Basic Lytham Urmston Training Courses
Oracle SQL Lytham Urmston Training Courses
SSRS 2005 - Lytham Urmston SQL Server Reporting Services Training Courses



North West - Possible Access Training Course Locations


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

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