How to Integrate Machine Learning into Microsoft Access Applications

In this episode, we’re going to level up our Microsoft Access application by integrating Machine Learning into it, so that we can see classification of customers that will show predictions of a fictional bank scenario where customers become part of a “preferred program“ or not. We’ll integrate the work we did in our last video where we created an Artificial Neural Network (ANN) to do this task. By integrating powerful Python scripting with our application, we will harness the power of Machine Learning in our MS Access application. I have been asked many times over the years on how to implement weighting, scoring, and predictive systems in complex environments. This episode’s ANN integration can be used in a wide range of contexts where MS Access is used, and though the actual ML model used is one of the simplest that can be used, it is still FAR more powerful than most other weighting and scoring systems that can be (easily) made with MS Access. And, when you consider that the model can be extended into Deep Learning territory to tackle greater complexity with more precision, you can see the power that can be added to any of your applications. Some things to remember when watching this video: - The ANN we created in my last video then integrated here is a simple one. It used many defaults (ie. learning rate, batch size) - It could easily be tuned for higher accuracy. - The purpose of this video was to demonstrate a sample integration. Every integration and application will be different. - Many datasets easily lend themselves to classification, but many do not and it is hard to get accurate classification. - This technique can also be used for computer vision (photo classification) - This example is called Supervised Learning, where we provide the labels of each case for the computer to learn from. Join me on Patreon! Want the code from this video? For developers looking for a new role, check out and sign up: Needing to hire technical resources for your project? Get the best: Contact form you can find at Follow me on social media: #msaccess #datascience #python