How to Integrate Machine Learning into Microsoft Access Applications
2.3 هزار بار بازدید -
2 سال پیش
-
In this episode, we're going
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.
Related Videos:
How to Use a File Dialog in MS Access to Allow Users to Pick a File or Folder
How to Use a File Dialog in MS Access...
How to Write a Custom Text File Using MS Access VBA
How to Write a Custom Text File Using...
How to Integrate Machine Learning into Microsoft Access Applications
You are watching this video now!
How to Use Base64 in Microsoft Access
How to Use Base64 in Microsoft Access
How to Use Sleep to Pause VBA in MS Access
How to Use Sleep to Pause VBA in MS A...
How to Open Excel from Access Using VBA
How to Open Excel from Access Using VBA
How to Use vbScript to Open and Work with Data in Access accdb Files - Late Binding Example
How to Use vbScript to Open and Work ...
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!
Patreon: mackenziedataengineering
Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...
Want the code from this video?
http://mackenziemackenzie.com/downloads
For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-...
Contact form you can find at http://www.mackenziemackenzie.com/
Follow me on social media:
Facebook: mackenziedataanalytics
Twitter: seamacke
Instagram: seamacke
Reddit: seamacke
LinkedIn: psmackenzie
Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...
#msaccess #datascience #python
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.
Related Videos:
How to Use a File Dialog in MS Access to Allow Users to Pick a File or Folder
How to Use a File Dialog in MS Access...
How to Write a Custom Text File Using MS Access VBA
How to Write a Custom Text File Using...
How to Integrate Machine Learning into Microsoft Access Applications
You are watching this video now!
How to Use Base64 in Microsoft Access
How to Use Base64 in Microsoft Access
How to Use Sleep to Pause VBA in MS Access
How to Use Sleep to Pause VBA in MS A...
How to Open Excel from Access Using VBA
How to Open Excel from Access Using VBA
How to Use vbScript to Open and Work with Data in Access accdb Files - Late Binding Example
How to Use vbScript to Open and Work ...
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!
Patreon: mackenziedataengineering
Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...
Want the code from this video?
http://mackenziemackenzie.com/downloads
For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-...
Contact form you can find at http://www.mackenziemackenzie.com/
Follow me on social media:
Facebook: mackenziedataanalytics
Twitter: seamacke
Instagram: seamacke
Reddit: seamacke
LinkedIn: psmackenzie
Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...
#msaccess #datascience #python
2 سال پیش
در تاریخ 1401/06/15 منتشر شده
است.
2,349
بـار بازدید شده