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.

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.