General Meeting Presentations

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

Upcoming Presentations

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.

Can't make it in person? Join us online at 6:30 PM Mountain on Thu Apr 16.

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

Please note, this meeting will be remote only.

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.