Redmond, WA 2020 Access Day Presenters
Thursday, March 19, 2020
Ebo Quansah (Microsoft)
News from the Access Team
Ebo and a member of the Access development team will provide an update on where Access has been, some recently released features, and what they’re working on now.
Ebo is an end-to-end product manager of Microsoft Access, Microsoft’s database management system with over 11 million monthly active customers. Ebo works in close partnership with the team of Access software developers to manage their backlog, develop new features and prioritize the roadmap. He's a driver of Access community connections through customer engagement and user group presentations.
15 tips in 75 minutes
If you think you know everything about Access, you've come to the right place. I constantly collect tools, solutions, methods and explanations that you don't hear and read everywhere.
- How secure is Access currently? Let's crack it merrily!
- Often used, never understood: weird properties and commands finally explained.
- Free tools and fun shortcuts for everyday use.
- Horizontal continuous forms, misplaced context menus, impossible code snippets etc.
- Now everything also to take away!
Karl Donaubauer is a database developer, Data Protection Officer (GDPR) and conference organizer from Vienna, Austria. He works for clients in several European countries and has been an Access MVP since 1998.
Building performance optimized and scaleable databases
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.
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 http://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.
Ynte Jan Kuindersma
The power of Access and web services
MS Access is well known for its ability to connect to data sources. But Web based data sources are a bit unknown to MS Access Office developers
During this session Ynte Jan will show you how to connect to Web API’s from Access and process the resulting JSON-response in VBA. Or post data to a webservice that sends a Text-messages on your behalf.
The examples he will demonstrate come from various Microsoft Online Services like Flow, Forms and Power BI.
Ynte Jan is a longtime developer of Microsoft Office applications with VBA and database-driven websites with ASP.NET.
He's extremely solution-oriented and chooses his tools accordingly, be it Visual Studio, Access, SQL Server, Power BI or non-Microsoft tools. And always enthusiastic about “new things”, especially the MS Power Platform.
His goal is not programming in itself but making people and organizations more efficient in their daily work by means of some clever code.
Ynte Jan is not only a developer but also a trainer. He has conducted many trainings and presentations in the Netherlands, Germany and Austria. He presented at Karl Donaubauer’s Access Entwickler Konferenz and the .NET Entwickler Konferenz in Nürnberg, Germany for many years. In 2018 and 2019 he did presentations at the Dutch Access Developer Day.
He is a Power BI usergroup Volunteer in the Netherlands.
Power Apps for Access Developers
Greg will introduce and show the latest features and capabilities of Microsoft Power Apps and how they relate to similar features in Access. He will also cover how Access developers can extend their Access/SQL Server applications to the web and mobile devices using low code Power Apps.
Greg Lindhorst is a Principal Program Manager on the Microsoft Power Apps team, responsible for the formula language, relational data access, and commanding. Having been a leader on the Access team during the 2010 and 2013 Office cycles, Greg is well versed in the strengths of both products and how to use them well together. Greg has also contributed to Visual Studio, VBA, SharePoint, and InfoPath, always gravitating to low code tools that enable anyone to create their own solutions and professional developers to save time and effort.
Power Queries and Data Analysis Techniques
Luke will show several techniques for querying and analyzing data in Access, along with some specific methods that harness the power of SQL Server.
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.