About This Class

Microsoft Excel&Microsoft Power BIare the most popular and used tools for analyzing and visualizing data.

BUT, Microsoft Excel is not created for gathering data, especially in gathering relational data likemaster-detail structures.

One basic, simple Excel example. You want to gather (or track) Orders in Excel and then for this Orders you want to track Order Details and, for example, Order Payments and all that using Excel.

Not to mention, to do this in amulti-user environment also in Excel

Boy,....., You will have a tough time to do this with Excel, because Excel is simply not created for challenges like this, to gather master-detail data and also in a multi-user environment within the normal Excel environment.

But in this course "Create Excel VBA apps using MySQL database & Virtual Forms",You will learn how you can do this byusing Excel VBAas a front end andMySQL databaseas a backend, whether the MySQL database is on your local machine, your local network, or on the web server. We will do this with help of a small tool called Virtual Forms.

And then you can connect to this data from Excel and use it whether we want to:

I'm Davor Geci the CEO and the Lead Developer of WinPIS, the company that's behind a popular tool that brings to Excel what Access developers are having for decades.

It is the ability tocreate CRUD Forms in Excel, forms tocreate,read,updateanddelete recordsthat are stored in databases likeMySQL,MSSQL,Access(On-premise or on the web) and use the data within Excel VBA and all thatin minutes.

It is similar to what Access can do, but you could also port this Virtual formsfrom Excel VBA to Visual Studio 2017 (C# or VB.NET).

You can not do this with Access VBA or natively with Excel VBA !

So, you just need to create a database and tell the Designer which fields you want on your form that is opened from Excel VBA code.

Once created Virtual Forms can be also used asLookUp forms in Excel VBAwith no extra work, just as you would doVLOOKUPanHLOOKUPin Excel functions & formulas.

All the controls that are generated on this Virtual forms can be accessed with ExcelVBA(or if you use Visual Studio 2017 with C#orVB.NET).

Virtual form control also fires events, so it allows us to interact with it, in a similar way normalUserForms in Excel VBAdo. But in a more data-centric way.

Before you dive in, it's probably a good idea to just check out the structure of the course "Create Excel VBA apps using MySQL database & Virtual Forms".

In this course,You will learn how to quickly create database applications using Microsoft Excel VBA and a MySQL databasethat is hosted somewhere on the internet or in your building (so-called on-premise) and all that with help of the Excel VBA & a small tool called Virtual Forms.

In the first part of this course, You will learn how tocreate your first database appthat will useExcel VBAas a front end, and aMySQL databaseas the back end. You will also learn how to install a MySQL server on your machine or anywhere in your network and use it as a data source. Also, in the first part of the course, you will learn how to install and use MySQL Workbench that help us to create and maintain MySQL databases.

Don't worry, I will go slow!

Not only you will learn how to create yourExcel Virtual Formsand write a few lines of Excel VBAcode to master them,

you will also learn how you can make money with your Excel apps by leveraging an affiliate program from a 3rd party web hosting company where you will host MySQL database.

And then, you will alsolearn how to transform your Excel VBAdatabase applications with MySQL database as the datasourceto C# or VB.NET with almost no change to the Excel VBA code.

How to create with confidence fully-functional Excel VBA Database applications for CRUD (Create, Read, Update, Delete) that connects to MySQL database, with almost no coding

How to easily create MySQL databases with Drag&Drop using MySQL Workbench in minutes, cutting out the useless fluff and filler

Step by step walkthrough on how to make passive income with your Microsoft Excel & Virtual Forms applications leveraging a 3rd Party Affiliate web hosting

How to reuse projects from Excel VBA (created with Virtual Forms Framework) in Visual Studio 2017 VB NET or C#

Master Excel & VBA & MySQL & Virtual Forms

Make your work-life easier with Excel

What knowledge & tools are required?

You need to have Windows version of Microsoft Excel

Fundamentals of Excel & VBA are preferred

A computer with Windows & Excel to install all the free and trial software and tools needed to build your new Excel VBA apps that connect to MySQL database (I provide specific videos on installations for each tool)