General Meeting Presentations

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

Upcoming Presentations

Thursday, August 20, 2020

Ebo Quansah

What’s New in Access 2020?

Ebo Quansah

Join in to hear from Access’s product manager, Ebo Quansah, as he discusses the latest news on features in Access, community involvement and updates in the Access ecosystem.

Ebo is a Program Manager at Microsoft and the product lead for Access. Prior to this role, Ebo spent two years at Microsoft in a rotational program, rotating throughout four teams in different organizations, including the Netherlands subsidiary and Machine Learning teams. Ebo received his Bachelor's degree from Princeton University as an Operations Research and Financial Engineering major. Ebo has always been very passionate and energetic about creating the best experience for our customers, especially from his time in the field, and he feels more than excited to play an active role in Access and help make the Access experience the best that it can ever be across our millions of customers.

Join us online at 6:30 PM Mountain on Thu Aug 20.

Past Presentations - 2020

Thursday, January 16, 2020

Jim Pilcher

SQL Server Basics for Access Developers, Part 1

Jim Pilcher

Join Jim Pilcher of DataOne, Inc. for an evening of discussion and demonstration surrounding the use of Microsoft Access with a Microsoft SQL Server on the backend. Jim will approach the evening from the viewpoint of a developer who has already transitioned to SQL Server and now wants more information about best practices, new possibilities, performance, and more, particularly when using Microsoft Azure SQL Databases. Jim will show some SQL Server developer utilities for managing SQL Server backend databases. Expect a free-form spirited discussion with plenty of audience participation.

Jim Pilcher is President of DataOne, Inc., a Microsoft Access/SQL Server consulting practice in Colorado since 1997. He is a 12-time Denver Area Access User Group president, and served as DAAUG vice president the past 3 years.

Watch the recorded video of SQL Server Basics for Access Developers, Part 1 on our YouTube channel

Thursday, February 20, 2020

Jim Plcher

SQL Server Basics for Access Developers, Part 2

Jim Plcher

Join Jim Pilcher of DataOne, Inc. for part two of a discussion and demonstration surrounding the use of Microsoft Access with a Microsoft SQL Server on the backend. Jim will approach the evening from the viewpoint of a developer who has already transitioned to SQL Server and now wants more information about best practices, new possibilities, performance, and more, particularly when using Microsoft Azure SQL Databases. Jim will show some SQL Server developer utilities for managing SQL Server backend databases. Expect a free-form spirited discussion with plenty of audience participation.

Jim Pilcher is President of DataOne, Inc., a Microsoft Access/SQL Server consulting practice in Colorado since 1997. He is a 12-time Denver Area Access User Group president, and served as DAAUG vice president the past 3 years.

Watch the recorded video of SQL Server Basics for Access Developers, Part 2 on our YouTube channel

Thursday, March 19, 2020

George Young

It's Logical, Captain. Automate Your Application with Azure Logic Apps!

George Young

Microsoft has a nice tool for automating application workflow, called Azure Logic Apps. Using a visual designer, with little or no code, you can automate aspects of your SQL-based Access application, such as logging to your database, sending notification emails, and much more. In this talk, we'll introduce Logic Apps, and develop two in real-time: sending a regular status email on a recurring schedule, and updating a database table in response to a change in another table. Join us for this look into another way that your Access application can play in the cloud!

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 twenty-five years, half of that time at Microsoft (in just about every group other than Office). He is 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.

Download the presentation materials

Watch the recorded video of It's Logical, Captain. Automate Your Application with Azure Logic Apps! on our YouTube channel

Thursday, April 16, 2020

Kevin Bell

Boost Your Productivity with Two New Access Add-ins

Kevin Bell

Looking for a better way to manage linked tables in Access? The AccessUI Data Source Manager allows you to quickly survey what external data sources are being used by your Access database, and change, or add linked tables with just a few mouse clicks. The AccessUI Ribbon & Tree Builder is an add-in to quickly build modern user interfaces for your Access applications. Whether you love or hate the Office Ribbon, it is not going away anytime soon. While you can do some very sophisticated things with the Ribbon, the XML markup is extremely finicky to work with, and hard to debug. With the Ribbon & Tree Builder you can create elaborate Ribbons without ever touching the XML. Treeview controls have always been a great way to navigate relational data, but working with ActiveX controls creates a whole set of potential problems. The Ribbon & Tree Builder uses a completely native treeview that is as simple to program, as creating a few queries.

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.

Watch the recorded video of Boost Your Productivity with Two New Access Add-ins on our YouTube channel

Thursday, May 21, 2020

Ben Sacherich

Tools, Tips, and Tricks - A day in the life of an Access developer

Ben Sacherich

Ben demonstrates some of the tools and techniques he uses in his daily activities. Some within Access and some external to it. If you’ve ever wondered “How could I do this a bit easier?” then take this opportunity to watch how someone else works and you may pick up techniques you can apply to your own development.

Ben Sacherich is a software developer from Pittsburgh, Pennsylvania with over 19 years of experience with VBA, Access, and Excel. He is a charter member of the international Professional Access Developer’s Unit, and attendee at multiple Portland International Database Conferences.

Watch the recorded video of Tools, Tips, and Tricks - A day in the life of an Access developer on our YouTube channel

Thursday, June 18, 2020

Armen Stein

Eight Million Unique Meetings

Armen Stein

Join Armen on a tour of Rotisserie, an Access application he designed and built for his Rotary Club. It invites random unique groups of people to get together for coffee chats. Features include importing from a master database of Rotarians, selecting a “captain” for each group, and sending out emails. It even includes a real life example of a Cartesian join!

Armen Stein is the founder and president of J Street Technology, a Microsoft Partner located near Seattle. J Street is a team of developers with expertise in building custom Access desktop and ASP.NET web applications. Armen is a Microsoft Certified Professional, an Access MVP since 2006, and has spoken at many user groups and conferences, including Microsoft TechEd, Office DevCon in Australia, Denver Dev Day, the PAUG Conference, and the UK Access User Group in London. Armen is co-author of Access 2007 VBA Programmer's Reference (Wrox). His other interests include travel, photography, Kauai, backgammon, movies, and driving his 1969 Ford Bronco in the sun.

Download the presentation materials

Watch the recorded video of Eight Million Unique Meetings on our YouTube channel

Thursday, July 16, 2020

Luke Chung

Access Remote Apps

Luke Chung

Remote Desktop and RemoteApp let your users run Access applications without having to installing anything on their local machine. That includes Access, the database, and any related programs. It lets users run the program across the network or Internet, from their PC or even a Mac. Luke Chung will demonstrate different approaches depending on whether the host is internal or in the cloud, and for backend databases in Access and 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.