In this session you’ll learn how to export all objects out of Access (tables, macros, queries, forms, reports, and modules). You will learn how to verify that AI has an understanding of your database, and what prompts to use to have it discover security and performance issues. You will also learn a framework that will ensure your AI assistant does not deviate from your objectives and stays on mission, verifying code changes every step of the way. Finally, you’ll see a real-world example on how to add a new feature in Access with AI.
Juan Soto is the President of IT Impact, Inc., a Data and AI Microsoft Solution Provider, and has been named an Access MVP 14 years in a row. His firm specializes in helping companies throughout the US migrate their data from Access to Azure or even a web app. Beyond consulting, Juan founded the worldwide organization AccessUserGroups.org, where Access enthusiasts meet monthly to share knowledge and best practices. He is also a sought-after speaker at conferences across the USA, covering topics such as SQL Server integration with Access and providing code for Access developers worldwide. To learn more, visit AccessExperts.com.
In this live, hands-on session, we’ll design and develop an Azure solution that supercharges your Access application, with AI as your co-pilot. We’ll tackle a real-world challenge: automating secure IP management for Azure SQL. You’ll learn how to make remote, secure data access to Azure SQL databases possible, without VPNs, manually adding IPs, or remote desktops. By the end, you’ll see how your Access skills, combined with AI and Azure Logic Apps, can unlock powerful, scalable solutions in the cloud.
Rochelle has several decades of experience developing Access applications as a consultant and employee in a variety of industries. Over the last 10 years she has also expanded into Power BI and Power Apps. Rochelle recently spent nearly 4 years at Microsoft as a technical PM in Azure, and later a data analyst and engineer in data center intelligence. She quietly built several Access databases, tools that enabled her to do things that others said couldn’t be done. Shhhh.
Armen will cover both technical and business considerations in running a software development company, including marketing, sales, finances, growing a team, when and how to delegate, customer communications, hiring and firing, fostering a healthy company culture, and more.
Armen started J Street Technology over 31 years ago, working as a solo programmer for local companies out of his house. J Street now has over 15 team members, and has built and supported Access and web applications for hundreds of companies across the US.
It seems like everyone wants to build web applications these days, but what about all the existing business-critical Access applications being maintained by Access developers reaching retirement age? This increasingly common situation is what MBA types like to refer to as a “market opportunity.” But as with any opportunity, it comes with its own pitfalls and challenges. Taking over an existing application is not the same as writing a new application from scratch. It involves a different set of skills and techniques to be effective, and the client relationship challenges are just as important as the technical challenges. Mike covered tips and techniques for successfully navigating this process: key differences between new projects and taking over existing applications, onboarding a new client, getting up to speed with an existing code base, critical first steps for success, tools and techniques to make the process easier, and structuring the deal beyond a simple hourly engagement.
Mike Wolfe has been a professional Access and SQL Server developer since 2007, a business owner since 2014, a blogger at NoLongerSet.com since 2020, and an Access MVP since 2021. He has spoken at conferences and events around the world, including Access DevCon Vienna; Access User Groups including the Madrid, Denver, East Coast US, Pacific, and Europe groups; and in-person presentations at Oxford University and Microsoft Headquarters in Redmond, WA.
Hear it from the source! Members of the Access Team at Microsoft will update us on the latest product news, and will demonstrate the latest features they’ve been working on.
With the push toward “New Outlook” intensifying, it’s no longer safe to write or use code assuming that Outlook Automation is available. Microsoft’s answer to this is to use the Graph API to send emails, but if you’ve got 2FA turned on, that’s a problem, because VBA can’t work with M365’s multi-factor authentication. Peter and Andrew worked together for months to tackle this, and have a solution. Their new tool, GraphAuthenticator, allows VBA code in any application to connect to the Graph API and seamlessly authenticate with MFA, allowing access to a huge range of API calls to work with emails, calendars, contacts, SharePoint, OneDrive, Microsoft Bookings, and more. GraphAuthenticator was officially launched at VBAuth.com at Access Day.
Andrew’s journey with Access began when he bought a copy of “Access 97 in a Weekend.” At some point, he’s planning to get his money back because he’s still not finished learning about Access nearly 30 years later. Andrew runs The IT Service, based in London, where he both builds databases and provides IT training on all things data-related to clients across the public and private sectors, from Imperial College London and Oxford University to the Metropolitan Police, Marks and Spencer, and a BBQ supplies company in Texas. Peter has run his own consultancy since 2004 and specializes in not specializing, working in almost every sector from automotive to hi-fi and financial services to charity. An Access developer since the early beta program over three decades ago, his projects now focus on data analysis, business functions, and problem solving as much as VBA or SQL code. He is one of three co-chairs of the UK Access User Group and has spoken at most of the UK conferences in the past few decades.