|
|
|
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: | ||
| Access Team | 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 |
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. |
|
| Access Flows |
Thomas Pfoch,
picoware, wizard from Berlin,
Germany (+Karl Donaubauer, beautiful assistant) |
|
|
Ever seen a fast&fluid Access touch app on a tablet? |
|
|
| Access Strategies | 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. |
|
|
| Access Challenges | ||
|
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
many fields. |
||
| 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. |
|
|
| 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 Server resources.) Advanced TSQL techniques for the Access developer. SQL Server Security Best Practices, because you never know who might be listening |
|
|
| Techniques+Tricks for Access Pros | Anders Ebro, Exacto, Copenhagen, Denmark | |
|
Image Handling Tips to storing images Resizing thumbnails Loading images on demand Creating a local image cache Classes 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 |
|
|
| 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. |
|
|
| 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. |
|
|
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.
After
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 founded
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.
Juan
is the President of 
Originally an engineer with a degree in Applied Physics, Anders started working with Access in 2008 and hasnt looked back since.
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
Paul (