Enable Technology

ACCESS PRESTON TRAINING COURSES 

ACCESS TRAINING COURSES PRESTON




About Enable Technology Preston Access Training Courses

We offer intensive two and three days Access courses. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a socially distanced venue near you in Preston. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are EDF Energy PLC, Nationwide Building Society Limited, Birmingham City Council, Birmingham City University, Keele University, Wolverhampton City Council, Halfords Group PLC and Carillion PLC.




Microsoft Access

  • 2 day course
  • Location: Preston
  • 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 ...
  • Multi Table Queries
    Calculations in Queries
    Getting to Know Access 
    Using a Navigation Form
    Aggregation Queries
    Adding Transactional Records
    Database Security
    DIY Forms
    Macros on Forms
    Data Validation
    Creating and Using Macros
    Relational Database Design
    Modifying Forms
    Querying Techniques
    Understanding VBA
    An Introduction to VBA
    Creating a Relational Database
    Parameter Queries
    Navigation Pane Protection
    Creating and Using Reports
    Modifying Table Structures

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Preston
  • Telephone on 01952 305730
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Working with Boolean Expressions
    Working with the Code Editor
    Calling Procedures
    Understanding VBA's Error Trapping Options
    Working with Inline Error Handling
    Naming Procedures
    Using Debugging Tools
    Working with Variable Scope
    Using the With Statement
    Understanding Expressions and Statements
    Using the If...End If Decision Structures
    Why Program in Access?
    Understanding the Development Environment
    Understanding the Err Object
    Using the For...Next Structure
    Using the Immediate Window to Call Procedures
    Stepping through Code
    Working with Variable Lifetime
    Using the Do...Loop Structure

  • See Training Course Details...



Email us about this courses



Other Preston Enable Technology Training Courses

SSRS 2008 - Preston SQL Server Reporting Services Training Courses
PowerPoint Basic Preston Training Courses
Crystal 2011 Preston Training Courses
Data Warehouse - Preston SQL Training Courses
SSRS 2005 Preston Training Courses
Excel Advanced Preston Training Courses



North West - Possible Access Training Course Locations


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

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