Skip Navigation LinksNATIONAL-SEMINAR--Tuesday-29th-November-2016


NATIONAL SEMINAR  Tuesday 29th November 2016 

To be held at Gordon Associates, Suite G1, Montpellier House, Montpellier Drive, Cheltenham, Glos.

GL50 1TY




10.30 – 11.00                 Registration, Tea and Coffee

11.00 – 11.15                Introduction – by Rod Gordon, Chairman of the Access User Group


11.15 – 12.00 Communicating with Web Services Via JSON (and if there's time, SOAP) in Native Access VBA presented by Peter Bryant, Corylus Business Systems

Brought into a major project for a turnkey in-house processing system, Corylus were asked to develop code to talk to two separate web services using JSON and SOAP technologies but without using any third party coding and encoding tools.  Interpreting received JSON and SOAP objects into database table records is both entertaining and challenging.  This presentation aims to show how the problems were overcome.


12.00 – 12.15                 Break for Tea/Coffee and refreshments


12.15 – 13.00                        PowerApps, CDM and Flow – Is This The Way Forward For 'Declarative

Programming?' presented by Julian Kirkness Associates

Microsoft are putting a huge amount of effort into their Power platform for business users/citizen developers at the moment – exactly the same audience to which Access has been and is targeted.  Julian will be talking about this, giving a brief demonstration of the platform and discussing whether this is the future for existing Access users.

This presentation will only scratch the surface of these tools – which are still in public preview – but the objective is to give you an understanding of what's coming from Microsoft and what effect it may have on our work.


13.00 – 13.45                Break for Lunch           


13.45 – 14.30                Creating Charts In Access presented by Andrew Richards, The IT Service

  Access has a lot of impressive tools and is capable of providing a very high quality user interface.  Both forms and reports can make use of some really great controls.  But unfortunately, charts are not one of them.  Yes, Access does do charts but they've not really changed much over the years.  On the other side of Office, Excel's charts have come on in leaps and bounds in recent versions and provide great flexibility and quality.  In this presentation, Andrew will show one approach to getting the best of Excel charts into the Access interface.


14.30 – 14.45                Closing by Rod Gordon 


SEMINAR FEES:            

FREE OF CHARGE for members

£35.00 + VAT (£42.00 inc. VAT) for non-members

To make a credit card payment please go to:


Annual membership of the Access User Group costs £70.00 + VAT (£84.00 including VAT) for an individual membership and £225.00 + VAT (£270.00 including VAT) for corporate membership (up to 5 named employees).  Payment for membership should be made to: Access User Group.

For     further     details     on    membership    and     the     seminar    contact     Margaret     Chamberlain     at: , telephone: 01242 256549, or visit our web site at:




Peter Bryant,

Peter has run his own consultancy since 2004 and (after a fashion) specialises in not specialising; he's worked in almost every sector ranging from automotive to hi-fi, from reseller to print, and financial services to charity.  He has used Microsoft Access since the early beta program two decades ago and his projects are now more about data analysis, function and business problem solving rather than the most amazing code writing.  Projects are nearly always lengthy prototyping/agile projects where the client starts out quite unsure of their expected final outcome.  As well as Access/SQL development he gets involved in general IT Management for SME's as well as project management for resellers and enterprise.


Julian Kirkness,

Julian has been a long time Access user (since V1.1) and has successfully built (and ultimately sold) an HR

Software business which started with an Access 95 based system and typically followed by moving the data to SQL Server.  Since nearly retiring early (and thinking better of it) he has spent the last two years building HR and CRM Access Web Apps which are sold through the Sharepoint App Store.  He became an Access MVP in July 2014.


Andrew Richards,

Andrew is the Managing Director of The IT Service ( and has been developing databases and training others on how to develop databases using Microsoft Access for nearly twenty years.  Current and recent database projects include work for Marks and Spencer, The Environment Agency and various local government organisations.  When not working on databases, Andrew can be found attempting to train his various sheep and chickens.