last updated 2020-01-28

 
   
Access Update by the Product Team  Ebo Quansah + Shane Groff, Microsoft, Redmond, USA

Ebo Quansah, new PM for Access, and Shane Groff, long-time engineer in the Access team, will come over from Redmond to attend the conference and present the latest news and plans for the product.

They will be there to discuss with attendees, answer questions, hear feature requests and pain points and learn about your Access work, applications and initiatives.

Ebo is a Program Manager at Microsoft and has become the product lead for Access in July. Prior to this role, he spent two years at Microsoft in a rotational program.
Ebo received his Bachelor's degree from Princeton University as an Operations Research and Financial Engineering major, which focuses on big data and complex system optimization, with a heavy emphasis on building algorithms, understanding how they work, and applying them to real-world situations.
Ebo has always been very passionate and energetic about creating the greatest experience for our customers, especially from his time in the field, and he is excited to play an active role in making the Access experience its best across our millions of customers.

   
Building performance optimized
and scaleable databases
 Anders Ebro, Exacto, Copenhagen, Denmark

When we deliver our freshly developed app to the customer, performance is lightning fast, and displays all of our 100 test records instantly. But what happens when the database has reached millions of records?How can we optimize our backend, and how can we still query efficiently? What are the common pitfalls to avoid? How can we debug what is causing our performance headaches? Some of the answers lie in the database architecture, specifically indexes!
This refreshing deep dive into the index and query work of ACE and SQL Server comes with a 30 day back guarantee if you are not satisfied with the inspired performance tuning and learning.

•  Indexes. What are they, why do they affect database performance, and how to use them efficiently?
•  Index and Query Anti-Patterns
•  Field type mismatch and their performance impacts
•  Access query vs SQL Server view
•  Jet Showplan, and SQL Server Query Plan

Anders has been developing and delivering optimized business applications for more than a decade. Everything from complex manufacturing forecasting to requirements management tools, Access can surely do the job, and do it well. As Anders loves to talk about Access development you can find him @ conferences around the globe and he has been awarded the Microsoft MVP every year from 2014 to 2019.
On his blog www.TheSmileyCoder.com you can find several code samples for treeviews, change tracking, and error/crash reporting, as well as lots of tips and tricks.

   
Remote access to Access  Luke Chung, FMS, Vienna (Virginia), USA

We all know shortcomings of Access applications such as installing Access on each user's machine, running it from a Mac, running it from poorly connected machines like WANs, deploying new versions etc. Therefore Access developers should know about remote hosting platforms and technologies. There are different approaches depending on whether the host is internal or in the cloud, and whether the backend is Access or SQL Server.

•  RemoteApp, Remote Desktop, Terminal Server, Virtual Machines on Azure
•  Fundamentals, pros and cons, demos to learn what fits for you, your application and your clients
•  Up to date information on the ever-changing licensing rules
•  How to optimize your Access application for remote use and how to avoid pitfalls

Luke founded 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.
Luke is a Microsoft Access MVP. He is a graduate of Harvard University with a Bachelor degree in Engineering and Applied Sciences, and a Master in Physical Oceanography.

   
Who, What and When – Access Data Macros and SQL Server Temporal Tables  Kevin Bell, msaccesstocloud, Redmond, WA, USA

At some point in every database developer's career, a customer is going to ask to see who changed what in a record. Tracking the "who" and then "when" a record was last changed is pretty simple, but providing a detailed history of "what" the field changes were has always been more challenging.

Access 2010 introduced Data Macros that can be used to create an audit log in an ACCDB file, but what about with a SQL Server backend? SQL Server 2016 introduced System Versioned Temporal Tables which can provide a relatively simple way to track each record's history and run point-in-time queries of some, or all of your tables. In this session we will look at

•  How Data Macros can be used to implement a simple audit log
•  How to implement Temporal Tables
•  What kinds of Temporal Queries can we use in Access applications that use SQL Server

Kevin started working professionally 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 applications on Access and SQL Server. In 2008 Kevin joined the Microsoft Access Team as a test engineer, working on the Access 2010, 2013 and 2016 releases. Kevin is now helping companies migrate their Access backends to the cloud. In his free time Kevin enjoys traveling the world searching for the perfect pint of ale.

   
Access to Health Care  Davide La Mantia, GestioneDati.com, Palermo, Italy

Demo of a complex real-world situation where Access holds things together

When you have to manage multi-part healthcare services with large quantities of patients, you have to handle multiple queues with a low impact on patients and staff. Likewise, you have to run detailed billing reports for the services provided. This means different applications that communicate with other systems within the healthcare facility, medical machines (radiotherapy), billing software etc.

In a mix of live presentation and video I'll show how Access allows to manage the different aspects of this work cycle:

•  A kiosk application that interacts with the patient, accepting user input via the touchscreen, reading barcodes, checking the patient's situation on the central SQL Server database and possibly issuing a waiting queue ticket and/or talking to the user.
•  The centralized management application analyzes and shows the patient's status and allows to make a call on the informational display.
•  The reporting application connects the services provided and transmits them to the billing application.

Davide is an IT consultant and developer registered in the Italian professional register of technical industrial experts.

He has worked with Access since 1994 and he also has many years of SQL Server programming experience. He develops and manages IT services for a wide range of purposes, such as billing and business management, factory production control and measurements, datawarehouse analysis and more.

   
The Power Platform
for database developers
 Alexandru Tofan (LI), Microsoft, Bucharest, Romania

Microsoft's Power Platform is steadily evolving. Database developers need to know the fundamentals in order to assess the options and changes. What does the platform offer us? What interfaces to use where and when? How can we combine our rich Access applications with Power Apps and Automate? And what will it cost in effort, knowledge, time and money?

•  Power Platform fundamentals: Environments and Resources
•  Common Data Service fundamentals: Common Data Model, solutions, entities and data integration
•  Power Apps Standard Canvas Apps vs. Power Apps Forms
•  Power Apps Model Driven Apps: Bite the bullet and start building! You will love it!
•  Embrace the hybrid using the On-Premises Data Gateway
•  Introducing Power Virtual Agents
•  What's new in Power Apps and Power Automate
•  Power Apps and Power Automate licensing

Alexandru started to use Access at his first job where he had to use a template to create mdb files containing land and building registration data. He has been using Access ever since, both as an end user and developer.

He is currently working for Microsoft as a Senior Technical Support Engineer for Power Apps and Power Automate, helping companies integrate them in their business processes.

   
Using PowerApps
to extend an Access/SQL Server system
 Peter Bryant, Corylus Business Systems, Cambridge, UK

A typical SME (a satellite TV installer) needed to improve data turnaround and accuracy – replacing near useless and slow paper records with real-time data through “something” on the phones. Once the initial test system was in place things snowballed! We’ll cover:

•  Getting the first quick and dirty app in PowerApps going.
•  Controlling stock levels using barcode reading (with observations on the experience and wisdom of using experimental features!)
•  Coping with a fundamental bug in PowerApps
•  Adding ETA management
•  Adding Risk Assessment surveys
•  Adding installation photographs (instead of occasionally remembering to email them)
•  Thoughts and recommendations on how to approach this for your projects

And all done without the client increasing their Office licence costs - just using native tools within a standard Office 365 Business Tenant (Access, SharePoint, PowerApps); and without changing the on-prem application very much either. (Assuming the demo gods are kind!), the objective is to leave you an account and working apps on a demo O365 tenant to take away and play with (for the lifetime of the tenant).

Peter has run his own consultancy since 2004 and specialised in not specialising; he’s worked in many sectors from automotive to hi-fi, reseller to print, financial services to charity.
A Microsoft Access user since the early beta program, his projects are a mix of business problem solving, business process, and developing the software to deliver it. As well as Access/SQL development he has branched into the PowerPlatform (principally PowerApps) to extend business data and processes onto mobile devices. He also provides general IT and Project Management services.

   
More sessions will be added in the coming weeks.