ACCESS USER GROUP
NATIONAL SEMINAR Tuesday 18th November 2014
To be held at Microsoft, Thames Valley Park, Reading, Berkshire, RG6 1WG
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.30 Great Database Design presented by Armen Stein, J Street Technology, USA
We are extremely fortunate to have Armen, who will be travelling all the way from Seattle, as our keynote speaker presenting two sessions. Armen is one of the leading Access developers in the world, an Access MVP, regular speaker at Microsoft conferences and co-author of a number of Access books. Both of his sessions are aimed at Access enthusiasts – presented by an Access enthusiast! The first session will cover the following:
All Access Projects should start with great database structures - do yours? Armen will present the database design techniques and naming conventions that J Street Technology uses in their projects. Slides and documents will be available to attendees.
10.30 – 10.45 Break for Tea/Coffee and refreshments
10.45 – 11.45 Useful Access Coding Procedures presented by Adrian Bell, Microsoft Access MVP
Adrian will present on his coding abilities and procedure library which will include String manipulation; SQL specific string manipulation; Process optimisation; Security (passwords); Progress display; Basic tools for working with files and much more!
11.45 – 12.45 Web Apps – from Idea to App Store presented by Julian Kirkness, Microsoft Access MVP,
Julian has an impressive record – he was the first person worldwide to put up an Access-based web app in the Office Online Store. As such, he is well placed to describe how Office Online – and Access web apps – can benefit you, both as a user and as a developer.
During this session Julian will cover the following points;
- His background
- Why he chose Access Web Apps
- Was it the right decision?
- What you can achieve (with examples and demo)
- What is missing
- Setting up for the Store
- Publishing (original process) including some tips for creating the .APP file
- Save for Deployment – the new way of publishing
- Has it been worth it?
12.45 – 13.30 Break for Lunch
13.30 – 14.15 The Non-Access Parts Of Office Online presented by Paul Christie
We have been given some excellent information about using the Access Web App but what about the rest of Office? There are Web Apps for Excel, PowerPoint and Word. Paul will quickly run through what can be done with PowerPoint and Word and then focus on the Excel Web App. He will look at the Table functionality that came in with Excel 2007 and what limitations there are when using some of these facilities in the Web App.
14.15 – 14.30 Break for Tea/Coffee and refreshments
14.30 – 16.00 Access Form Techniques presented by Armen Stein, J Street Technology, USA
Armen will show ways to make your Access forms more powerful and easier to use and navigate. Techniques will include alternatives to tabs, daisy-chaining forms, and custom navigation buttons. Slides and documents will be available to attendees.
16.00 – 16.15 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
Armen is the founder and 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 an Access MVP and has spoken at many user groups and conferences, including Microsoft TechEd, Office DevCon in Australia, the AUG Conference, the UK Access User Group and J Street's own Access Day. Armen is co-author of a couple of Access programming books. His other interests include travel, photography, backgammon, movies and driving his 1969 Ford Bronco in the sun.
Adrian has been working in IT since leaving school during which time he's had five 'proper' jobs and three stints at 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 contributions to the Access support forum on Bytes.com. 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 children, Christopher (24) and Sarah (21) and they live in Shirley near Croydon.
Originally an HR and Payroll software salesman, in the early '90's Julian decided that HR systems looked quite simple to develop(!) and thought that he would give it a go using Access. After over a year of development carried out during evenings and weekends, in January 1996 Julian decided he would start a business to sell the product and Select Software was born.
The business grew from that moment on and went through several technology changes and eventually Julian sold it to The Access Group in January 2010 with 40 employees and 300 customers.
Since then, Julian has been looking for the right technology to start a new business and to his huge surprise, has come back to Access in the form of Access Web Apps. He will explain that decision in his talk but he believes that he was the first to publish Web Apps on the Sharepoint Store apart from Microsoft, who have recognised his efforts by making him an MVP for the first time.
Paul has worked in IT for all of his career and has been working with PC's and PC application software for the last 30 years. Since becoming a freelance developer in 1992 Paul has specialised exclusively in Microsoft Office, focusing on Access and Excel in almost equal measure, but with occasional use of Word and PowerPoint.
Paul has worked in a number of different business sectors mostly for large organisations working closely with end users and bypassing in-house or outsourced IT departments.