Denver Area Access Users Group

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

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

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

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

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

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

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.

Watch the recorded video of Access Remote Apps on our YouTube channel

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.

Watch the recorded video of What’s New in Access 2020? on our YouTube channel

Access and Excel are both useful tools for data analysis. Getting data between these two Microsoft applications can be as easy as "cut and paste". There are also times when Access developers need to create processes in their applications that enable targeted imports of data from or exports of data to Excel. These code based solutions help developers maintain data integrity in their Access application and create smooth transitions of data between the two applications for their users. This presentation will show Access developers how to use VBA code within Access to manage data between Access and Excel.

Phil is a database software developer and founder of AFL Enterprises, LLC, located in Denver, CO. Phil's been developing in Access for almost 20 years and designs software database applications for all industries. A member of DAAUG since the early 2000s, Phil is an occasional presenter to the group and learns something new about the Access environment at every meeting. When Phil isn't coding a superb database app, he's either spending time with his family or training for a marathon.

Download the presentation materials

Watch the recorded video of Creating VBA automation in Access for Excel exports and imports on our YouTube channel

As user habits and expectations change over the years, we as developers can adjust our own habits to give our users a richer, less frustrating experience. This presentation will explore some of the ways that developers can enhance their applications' utility and ease of use, thus the user experience.

Dawn joined DAAUG in 2017, shortly after opening her own consultancy as a database developer. An Access enthusiast since 1999, one of her earliest applications is still in use today. When taking a break from coding, Dawn can be found communing with green growy things or researching her family's genealogy.

Watch the recorded video of A Better User Experience on our YouTube channel

DAAUG Treasurer Lee Milligan will share information on the upcoming Access conferences in 2021, including interviews with the conference organizers. Join us for an entertaining virtual tour around the world of Access!

Lee entered the IT/Software Development market in 1999 with an emphasis on Microsoft Access database creation and support of existing network distributed database applications. He soon began VBA (Visual Basic for Applications), SQL Server, and .NET development as technologies evolved. Several of his Microsoft Access database applications are still deployed in production after 18 years and have stood the test of time through over five versions of Microsoft Access.

Download the presentation materials

Watch the recorded video of Accessing the Main Events: Access Conferences in 2021 on our YouTube channel

No General Meeting in December. Due to restrictions on indoor dining in Colorado, we will postpone the members dinner until (hopefully) early 2021.