The first Access DevCon Vienna took place on April 1+2, 2017. It included 10
presentations by experienced developers from Europe and the USA and by the
Microsoft Access product team. We had a 50 attendees from 12 countries.
|This was the agenda in April 2017:
|Michal Bar + Mike Sullivan, Microsoft, Redmond, USA
Two members of the Microsoft Access product team came over from Redmond to
attend the conference and to keep us up-to-date with a short presentation:
Overview of whats new in Access 2016
Michal is a program manager in Microsoft and the product lead and champion for Access since 2014. Prior to Microsoft, Michal spent 10 years at Intels mobile division, mainly focused on SQL based solutions for microprocessors validation processes. She has served as a press non-commissioned officer in the IDF, and holds a B.Sc. in Information Systems engineering from the Technion institute of Technology in Israel. She feels honored to be part of the Access team, with the opportunity to make an impact on the product and millions of engaged customers all over the world.
Mike has been software engineer on the Microsoft Access product team for over ten years. Beginning on the test team, he has helped to ship every version of Access since Office 2007. More recently, Mike has been working on delivering some of the Access desktop roadmap items, including BigInt support. In his free time, Mike is an avid American football fan, rooting for his Buffalo Bills through thick and thin.
picoware, wizard from Berlin,
(+Karl Donaubauer, beautiful assistant)
Ever seen a fast&fluid Access touch app on a tablet?
Thomas made his master in computer science at the Technical University of Berlin
he has focused on UI and databases.
So he became an Access developer with the first version in 1992. He uses Access not only as RAD tool for app development, but also as basis for a next generation framework where apps are generated from or driven by meta data.
|Luke Chung, FMS, Vienna (Virginia), USA
As long-term president of the biggest producer of Access tools, Luke has
the most substantiated "industry" view of the product. His ideas on important
strategic aspects lead to lively discussions.
FMS in 1986. He is the primary author of many FMS tools including Total Access Analyzer/Detective/Emailer/Statistics. He
has also personally provided consulting services to a wide range of clients.
25 years of development work with Access mean dealing with a bunch of product
bugs and limitations, solving design issues and developing best practices in
|Communicating with JSON Services Natively in Access VBA
|Peter Bryant, Corylus Business Systems, Cambridge, UK
Access can talk to HTTP services, but doesn't provide built-in abilities to deal
with the data from JSON or XML API calls. Whilst there are third party tools and
libraries out there, they have their limitations and might not be permitted or
welcome on a project (which is how this came about). We show how to do it in
Access VBA with a few standard references and no other external dependencies.
Peter has run his own consultancy since 2004 and specialised in not specialising; hes worked in almost every sector ranging from automotive to hi-fi, from reseller to print, from financial services to charity. A Microsoft Access user since the early beta program, his projects are more about business problem solving with a complex database to deliver it, than the most amazing code writing. As well as Access/SQL development he provides general IT and Project Management.
|Optimizing Access with SQL Server online
|Juan Soto, IT Impact, Chicago, USA
Advanced topic on how to configure Access to work with a cloud hosted SQL Server. During this session we will discuss pitfalls to avoid and optimization techniques in order to get Access working great even if the data is web hosted. What to avoid doing when your data is in the cloud, sometimes perception is as important as reality
What speed standard should you shoot for and how can it be achieved? (overcoming web latency)
How to avoid using JET or ACE engine in queries and in your code. (Hint: Maximize the use of SQL
Advanced TSQL techniques for the Access developer.
SQL Server Security Best Practices, because you never know who might be listening
is the President of IT Impact Inc. and a Microsoft Access MVP for the last six
|Techniques+Tricks for Access Pros
|Anders Ebro, Exacto, Copenhagen, Denmark
Tips to storing images
Loading images on demand
Creating a local image cache
Every day we work with classes, the form class, the textbox class or the combobox.
But have you ever tried taking it one step further by enhancing one of those classes?
Reusable GUI enhancements for the textbox, form, combobox
Example of custom class that combines 3 controls to support business logic
Using a report inside a form
Pretty notes that scale in size
Continuous supreports inside continuous subreports but viewed as a form
Originally an engineer with a degree in Applied Physics, Anders started working with Access in 2008 and hasnt looked back since.
|Two Professional Tools to Extend Access Development
|Kevin Bell, COMC, Redmond, USA
Our company works on large projects with multiple developers. So we need to manage the development source code. The newest version of OASIS-SVN now offers tighter integration with Git repositories:
A few basics of source code control with Access
To complement our Access frontends for SQL Server we need web/mobile frontends. Microsoft has tried (and failed)
from DAPs to Access Web Apps, and PowerApps are still a toddler. However there is a
professional tool from Microsoft that will allow you to access your data remotely
and will surprise you with its ease of use: ASP.Net MVC
An introduction and open discussion on creating a package manager for Access. The goal is to offer a community driven platform that allows people to market their Access related tools or utilities to other Access users with minimal effort. Similar to what NuGet does for Visual Studio.
Kevin started working with Access in version 1.0 and has been working with SQL Server since version 4.21. For 15 years he ran a small consulting firm in Colorado that specialized in creating custom data driven application on Access and SQL Server. In 2008 Kevin joined the Microsoft Access Team as a test engineer, working on parts of the Access 2010, 2013 and 2016 releases. After leaving Microsoft in 2014 Kevin joined www.comc.com founded by another former Access Team member.
|Automated Testing in Access Applications
|Paul Rohorzka, TechTalk, Vienna, Austria
Your application works great, your code is clean, your customer is happy. But all of a sudden weird behaviour starts creeping in, bugs show up, things get broken that worked before.
And painfully even users start reporting problems, because you didn't notice that nasty side-effect of your latest change.
Paul (@paulroho) is a software gardener with a passion for great code, i.e. code that works and is easy to read and maintain. He lives both in the land of Begin/End and the realm of curly braces. Working as a developer mainly in .NET at TechTalk, he still supports long standing clients of his own consultancy softconcept with the focus on Access based projects. Not least by appearing with more than a dozen topics at Karl's conferences, he tries to cross-pollinate both worlds. Paul loves teaching other developers good coding practices in trainings, coding dojos, and talks at meetups and conferences.