Access Day Presenters
Friday March 28, 2025
Mike Wolfe
Alternatives to Classic Outlook Email Automation
Most Access developers have heard that New Outlook won’t support COM, so it won’t automate emails from another Office program like Access. As the adoption of New Outlook advances, we’ll need to find other ways to send email from our applications. Mike will lead us through some alternatives and explain their pros and cons.
Mike Wolfe has been an Access MVP since 2021. He runs Grandjean & Braverman, Inc., specializing in Microsoft Access and SQL Server software solutions for government, banking, and insurance clients. He writes daily articles about advanced Access and VBA topics at nolongerset.com, where he’s published over 12,000 articles since 2020.
Peter Doering
What To Do When a Microsoft Update Breaks Your Application
Numerous update bugs have caused disruptions in our Access applications over the last few years. Access developers have developed a reasonable fear of Office patches and Security and Windows updates. But it doesn’t have to be that way. Peter will give us some practical tips about how to minimize the changes of an update affecting our applications, and the steps to take if one does.
Peter has been self-employed since 1993. He developed a CRM system based on Access and SQL Server for corporate clients and has carried out many international projects. These days, he specializes in migrating from Access to SQL Server/Azure/Office365, SQL Server database design and management, development of custom solutions, and the implementation of Microsoft Teams. Peter has been a Microsoft Access MVP since 2004, and has been the only German Access MVP for several years.
George Young
Build Your Own Web API in Minutes
Web APIs are a great way to have access to external data from the Internet, whether public APIs, like weather, stock prices, and mapping, or your own data. Access can easily make us of Web APIs using free packages like VBA-Web (See George’s presentation, Using Web APIs in Access on YouTube at https://www.youtube.com/watch?v=9CQcJkR_aKM.
In this presentation, we will take an Access database, put it in SQL Server, and build a Web API using Visual Studio wizards in minutes that can be used in your Access applications. You will come out of this talk with the ability to quickly create Web APIs from your own data sources. All sample code an applications will be provided to attendees.
George first encountered Microsoft Access when using the thirty-plus floppy disk versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since. George has worked as a software developer for the past thirty years, half of that time at Microsoft (in just about every group other than Office). He is a Microsoft MVP, president of the Denver Area Access Users Group, and the founder and president of Dawson Butte Software, working primarily on .NET applications (often with Access somewhere in the mix). George still has a commercial site or two that is driven by an Access database sitting in the server file system.
Luke Chung
Extend Your Access Applications with Other Microsoft Office Products
Enhance Access applications by using features available in other Microsoft products such as Excel, PowerPoint, Word, etc. Interactively and through VBA and Windows API calls, Access applications can share data, update files, display visualizations, and perform tasks that don’t exist in Access but are provided by Microsoft through other products included in Office and Windows licenses.
Luke Chung is the president and founder of FMS (http://fmsinc.com), the world’s leading creator of Microsoft Access add-ins. In its 31st year of business, FMS offers 12 products specifically designed for Microsoft Access including Total Access Analyzer, Total Access Emailer, Total Access Detective, Total Access Statistics, Total Access Speller, Total Access Admin, Total Access Startup, Total Access Components, Total Access Memo, Total Visual Agent, Total Visual CodeTools, and Total Visual SourceBook. Luke is an author of several of these products and involved in the design of all of them with tens of thousands of customers in over 100 countries. Luke has also created custom Access, SQL Server, VB6 and .NET solutions for Windows and the web. Luke has written a wide range of technical papers and spoken at conferences across the US, Australia, and Europe.
Kevin Bell
SQL Server Tips and Tricks for the Access Developer
SQL Server Tips and Tricks for the Access Developer
Access and SQL Server can work well together; however, as an application grows and becomes more complex, they can become more challenging to manage, and performance may decrease. Access is often blamed for these performance issues due to its reputation of not being a “real” development tool, but many of these issues can be addressed through more efficient use of SQL Server. In this session, various SQL Server tips and techniques will be explored. Some methods will enhance readability and manageability, others will improve performance, and some will achieve both!
Kevin began his professional career with Access version 1.0 and has been working with SQL Server since version 4.21. For 15 years, he operated a consulting firm in Colorado, specializing in the development of data-driven custom applications using Access and SQL Server. In 2008, Kevin joined the Microsoft Access Team as a test engineer, contributing to the Access 2010, 2013, and 2016 releases. In his leisure time, Kevin enjoys cycling and traveling internationally in search of the finest pint of ale.
Access Team
Dale Rector, Shane Groff, Courtney Owen, Sachin Arunkumar, Tushar Jain
Access News and Demos of New Features
Hear it from the source! Members of the Access Team at Microsoft will update us on the latest product news, and will demonstrate the latest features they’ve been working on.