General Meeting Presentations

2022 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003

Upcoming Presentations

Thursday, June 16, 2022

Karl Donaubauer, Access MVP, donkarl.com

Design Patterns with Access

Karl Donaubauer, Access MVP, donkarl.com

IMPORTANT: This presentation is at 10:30 AM Mountain Time

It doesn't hurt to become even more efficient and confident in implementing requirements. No, you won't run out of work. ;-) In 25 years and 150 Access projects, patterns and techniques have developed, some of which I show using real client projects.

  • Guidelines for the defensive Access board means fundamentalist
  • Design patterns for visible and invisible applications
  • Structuring interfaces and processes in templates
  • Making project duration and costs predictable
  • Demos on standard structure, user administration, translation, schedule...

Karl is an Access developer and MVP since the 90s. He organizes conferences, does presentations, workshops and videos. Due to an obstinate nature he has dedicated himself to tilt at windmills, fighting the bad image of Access and the worse intentions, boasting in poor armour in various languages, countries and funny places, including an English wedding castle, a Calabrian sanctuary and several MSFT offices.

Join us online at 10:30 AM Mountain Time on Thu Jun 16.

Past Presentations - 2022

Thursday, January 20, 2022

Nathan Helgren, Senior Program Manager, Microsoft Corporation

Dataverse Deep Dive for Access Developers

Nathan Helgren, Senior Program Manager, Microsoft Corporation

Join us for this special presentation as Nathan Helgren and Vijay Singh from Microsoft present a deep dive on Dataverse and answer your questions about this new platform for Access developers!

Nathan is a Senior Program Manager at Microsoft on the Power Platform team, where he focuses on the Dataverse platform. During his more than twenty years at Microsoft, he has also worked as a Program Manager in the Windows Development Group, the ECO group (Microsoft Support) and the Licensing and Pricing organization.

Download the presentation materials

Watch the recorded video of Dataverse Deep Dive for Access Developers on our YouTube channel

Thursday, February 17, 2022

Colin Riddington, Mendip Data Systems

Automatic Form Resizing in Access

Colin Riddington, Mendip Data Systems

IMPORTANT: This presentation is at 10:30 AM Mountain Time

All developers will be aware that forms designed for a specific screen size or resolution may look dreadful on a different monitor with a different resolution or screen size or shape. Automatic form resizing (AFR) code is designed to fix all such issues. Using AFR, forms and their controls can be automatically resized and repositioned for any screen size & resolution whilst allowing developers full control over the form layout and appearance. AFR code works with all types of form (including split forms, navigation forms and datasheets) and with both overlapping windows and tabbed documents display modes. This session will explain how the code works and provide tips for using the code most effectively in your own applications.

Colin has been an Access developer for over 20 years starting with Access 97, with many years teaching in secondary schools including responsibility for data analysis. He initially created Access apps for his own use and later for all staff in a number of UK schools. His websites include many Access articles, example apps, sample code and security challenges, together with commercial applications for businesses, schools and developers. His focus is on stretching the boundaries of what can be achieved using Access.

Download the presentation materials

Watch the recorded video of Automatic Form Resizing in Access on our YouTube channel

Thursday, March 17, 2022

Mike Wolfe, Grandjean & Braverman, Inc.

Troubleshooting Query Performance

Mike Wolfe, Grandjean & Braverman, Inc.

Even when you follow best practices, you are still bound to run into query performance problems. When you do, do you know the best way to troubleshoot them?

In this presentation, Mike will describe and demonstrate several tools you can use to troubleshoot query performance for both Access and SQL Server backend databases. Those tools include JetShowPlan, ODBC Trace SQL Mode, SQL Server Profiler, and even a couple of truly low-level utilities that probably don’t come to mind when you think of query troubleshooting.

Mike 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 500 articles since 2020. Mike is the most recently awarded Access MVP, earning the award in November 2021.

Download the presentation materials

Watch the recorded video of Troubleshooting Query Performance on our YouTube channel

Thursday, April 21, 2022

Tom van Stiphout, Kinetik IT, Access MVP

A New Northwind!

Tom van Stiphout, Kinetik IT, Access MVP

Join us as Access MVP Tom van Stiphout talks about the work going on to create a new and improved Northwind sample application. Tom will present what the group is doing, and get your feedback on how you would like to see this venerable sample application updated and improved!

Tom is the Software Development Manager of Kinetik I.T. in Phoenix, Arizona, a full service information technology and internet services provider offering a wide array of technology and internet strategy solutions. Tom has a degree from Amsterdam University and came to the United States in 1991. After a few years with C++ and Windows SDK programming, he gradually focused more and more on database programming. He worked with Microsoft Access from version 1.0, and Microsoft SQL Server from version 4.5, when both were quite immature products.

Watch the recorded video of A New Northwind! on our YouTube channel

Thursday, May 19, 2022

Kevin Bell

AppLauncher for Access - a new Access front-end deployment service

Kevin Bell

Anyone who develops Access applications knows you need to split your database. The data can live on a file share, or better yet in SQL Server, and your Access front-end is ideally copied to each user’s computer. Running the front-end locally will improve performance and virtually eliminate corruption issues, but how do you effectively push out a new version out to all your users? Join us as Kevin Bell gives the first public demonstration in the USA of a new deployment service, appLauncher for Access.

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 he joined the Microsoft Access Team as a test engineer, working on the Access 2010, 2013 and 2016 releases. Kevin is currently working for a large consulting firm building equity compensation systems for big tech companies. In his free time he enjoys cycling, playing baseball and someday being able to travel the world again searching for the perfect pint of ale.

Watch the recorded video of AppLauncher for Access - a new Access front-end deployment service on our YouTube channel