From Access to PowerApps: Using Helper Stored Procedures for Modular SQL Logic

Are you an experienced Access developer wondering how to take your skills mobile?
In this series, I’ll show you how I’m replicating the Northwind Developers Edition template from Access—step by step—in PowerApps.

In this video, I guide you through a case study using modular, reusable stored procedures to gather and calculate current inventory and product reorder quantities for Products.

It requires a set of "helper" stored procedures, each encapsulating one part of the process. Once the bits and pieces are gathered, the final step in the "master" stored procedure calculates the reorder quantity and passes it, along with the components, back to the PowerApps Application.

SQL Scripts for the stored procedures in this video can be found at

https://github.com/GPGeorge/NorthWind4PowerApps/tree/GPGeorge-InventoryandReorderQTY

About Northwind:

The Northwind 2.0 Developer Edition template showcases major features of Access; it is not designed to run a company nor show you how to build such an application.

Northwind is a fictitious trading company whose customers are independent grocery stores.

The PowerApps version:
You'll become familiar with the List and Detail screens for Orders, Purchase Orders, Products, Companies and Employees.

Assisted Intelligence provided by ChatGPT and Anthropic Claude.

Видео From Access to PowerApps: Using Helper Stored Procedures for Modular SQL Logic канала George "Grover Park George" Hepworth