NATIONAL SEMINAR Tuesday 17th May 2016
To be held at Beaumont House, Burfield Road, Old Windsor, Berkshire, SL4 2JJ in the Kensington Conference Room
8.45 – 9.15 Registration Tea and Coffee
9.15 – 9.30 Introduction – by Rod Gordon, Chairman of the Access User Group
9.30 – 10.15 Building a Data Warehouse presented by Andy Couch, ASC Associates
With companies looking to consolidate data in central warehouses using the Microsoft BI stack, a basic understanding of the approach to take when constructing a Data Warehouse could open up new business opportunities. Andy will introduce the concepts and techniques used to construct a data warehouse using SQL Server and SQL Server Integration Services, following the Kimball Methodology. He will demonstrate how data is stored as Facts, Dimensions, and Slowly Changing Dimensions. A three step process will be shown for taking data from a staging area through an enterprise area to then create data marts. Source code for a sample data warehouse with SSIS packages will be provided.
10.15 – 10.55 The Easy Way To Apply Themes To (Non-web) Access Databases presented by Peter Cole, Cole Computers
During this session, Peter will show his ‘ThemeMyDatabase’ service that allows easy application of Themes to old databases without having to go through the manipulation of code as provided in his previous presentation (May 2013). The concept of collecting together particular settings as a named ‘Style’ will be introduced and Peter will discuss the implications of using themed fonts with particular reference to datasheet forms . There will also be an analysis of a sample database with statistics for number of forms and reports along with colours and fonts used. The presentation will finish with the style created during the presentation being applied to the sample database demonstrating the simplicity of the operation.
10.55 – 11.10 Break for Tea/Coffee and refreshments
11.10 – 12.10 You Can Get The Job, But Can You Do The Job? presented by Armen Stein, J Street Technology
We often focus on landing new projects, but what about succeeding with the projects we land? Armen will discuss how to manage your client relationships, set expectations, communicate effectively, handle (inevitable) scope creep, produce clear status reports and follow up after the project is complete.
12.10 – 13.25 Break for Lunch
13.25 – 13.55 Control External Processes from Access presented by Adrian Bell, Access Consultant (UK) – Microsoft Access MVP
Have you ever wondered how to control external processes from within Access? That is to say to create as well as to execute command or script files that include numbers of variable parameters and values within them, such as addresses of files. Even creating and using an FTP script file to control an FTP session automatically (ie. without requiring user intervention). Let Adrian take you through some of the techniques he uses to do this.
13.55 – 14.35 Replacing Pivots in Access Forms and Reports presented by Peter Bryant, Corylus Business Systems
We know that Access is the best database reporting tool ever invented but what should you do when they start deprecating (ie. deleting) features? Peter Bryant developed an application for a plant hire company in Access 2007 with a great pivot table report showing plant availability – only to discover that the pivot table was dropped from Access 2010/2013 run-time. Unfazed by this minor setback, Peter decided to build something better instead! In this session Peter will briefly show the plant hire application and the plant availability report from the user’s point of view and will then show how he created the report, the options that were available to him, the issues encountered and how the report is now actually better than it was before.
14.35 – 14.50 Break for Tea/Coffee and refreshments
14.50 – 15.50 Access Tips and Tricks presented by Armen Stein
Armen will present techniques for making your Access desktop applications consistent, powerful and easy to use. Topics covered will include configuration values, relinking tables, navigation techniques, performance improvements, and UI tricks. Example code will be available to attendees.
15.50 – 16.00 Closing by Rod Gordon
£100.00 + VAT (£120.00 including VAT) for members
£135.00 + VAT (£162.00 including VAT) for non-members
To make a credit card payment please go to: www.gordonassociates.co.uk/matchriverevents
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: Margaret@gordonassociates.co.uk , telephone: 01242 256549, or visit our web site at: www.ukaug.co.uk
Andy Couch, ASC Associates, Access MVP
Andy has been developing with Microsoft Access and Microsoft SQL Server for over 14 years and specialises in Client-Server design and the Microsoft Business Intelligence Stack. As a specialist in the migration of Access databases to both SQL Server and SQL Azure, he has developed a commercial software tool: Migration Upsizing SQL Tool (MUST available from www.upsizing.co.uk). As a director and one of the founding members of the UK Access User Group (www.ukaug.co.uk) he presents at various UK developer events. Andy has been awarded MVP status for eight years and has written several books for Microsoft Press including "£xtend Microsoft Access Applications to the Cloud"; "Microsoft Access 2013 Plain & Simple" and "Microsoft Access 2010 VBA Programming Inside Out".
Peter Cole, firstname.lastname@example.org
Peter originally started with Access developing a timesheet program. He diverted on to CAD/CAM and developed a system to transfer data to modern systems providing a service to around 100 companies. Returning to Access he developed an interior designers system and parametric CNC system integrating with a Nesting Package via the COM interface. His special interest is the look and feel of Access (Desktop).
Adrian Bell, email@example.com
Adrian has been working in IT since leaving school during which time he’s had five ‘proper’ jobs and three stints as working for himself. His most recent job prior to working as a consultant was with Stat Plus Limited, where he found himself responsible for, and increasingly working with, various Access databases. By the time he left in 2010, Stat Plus had been bought out by and merged with Office Team and Adrian had been involved with migrating all their data into their system – a massive job that was fully successful and completed by the due date. Since leaving Office Team in September 2010, Adrian has managed to set up a small but successful company consulting to SME businesses that need help with Access and data generally. His main claim to fame as an MVP is his contribution to the Access support forum on Bytes.com: http://bytes.com/profile/51203/neopa/. Currently he has just over 29,000 posts out there which is a clear indication of how much interest there still is in Access. Adrian is married to Carolyn and they have two grown-up children – Christopher and Sarah. They all live in Shirley near Croydon.
Armen Stein, firstname.lastname@example.org
Armen is the president of J Street Technology , a Microsoft Partner located near Seattle. J Street is a team of developers with expertise in custom Access desktop and ASP.NET web applications. Armen is a Microsoft Certified Professional and Access MVP, and has spoken at many user groups and conferences including Microsoft TechEd, Office DevCon in Australia, the PAUG Conference and the UK Access User Group (this will be his third time). Armen is co-author of Access 2007 VBA Programmer’s Reference (Wrox). His other interests include travel, photography, backgammon, movies and driving his 1969 Ford Bronco in the sun.
Peter Bryant, email@example.com
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.