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 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. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the Access course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Loughborough University, Shell UK Oil Products Ltd, TalkTalk Direct Limited, Wolverhampton City Council, Carillion PLC, Queen's Medical Centre Nottingham, South Staffordshire Water PLC and Royal Air Force.




Microsoft Access

  • 2 day course
  • Location: Preston
  • 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 ...
  • Creating a Relational Database
    Formatting Tables
    Setting Table Relationships
    Using a Navigation Form
    An Introduction to VBA
    Sorting and Filtering
    Creating Queries
    Action Queries
    Parameter Queries
    Database Security
    Calculations in Queries
    Creating and Using Forms
    Working With Records
    Adding Records to a Table
    Data Validation
    Aggregation Queries
    Understanding VBA
    Creating and Using Macros
    Multi Table Queries
    Designing a Lookup Database
    Importing and Exporting Records

  • 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 ...
  • Understanding Procedures
    Working with Events
    Considering Variable Scope and Lifetime Together
    Understanding Classes and Objects
    Naming Procedures
    Using Break Mode during Run Mode
    Working with Variable Scope
    Working with the ADODB Recordset Object
    Locking Records for Updating
    Understanding the Development Environment
    Working with Inline Error Handling
    Using Visual Basic Help
    Using Intrinsic Functions
    Using Debugging Tools
    Understanding Modules
    Understanding the DoCmd Object
    Using the Immediate Window to Call Procedures
    Understanding Recordset Cursor Properties - Optional
    Working with Recordsets

  • See Training Course Details...



Email us about this courses



Other Preston Enable Technology Training Courses

SSRS 2014 Preston Training Courses
Crystal 2011 - Preston Crystal Reports Training Courses
Crystal 2016 Preston Training Courses
Power Graphics - Preston Data Analytics Training Courses
Data Warehouse Preston Training Courses
Oracle BI - Preston Data Analytics Training Courses



North West - Possible Access Training Course Locations


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

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