Create Excel VBA apps using MySQL database & Virtual Forms [100% Off]

Step-by-step Masterclass: Create desktop Excel apps using online MySQL database in minutes with Virtual Forms & VBA
Instructed by: Davor Geci | Subject: Development, Microsoft

Description

Microsft Excel & Microsoft Power BI are the most popular and used tools for analyzing and visualizing data. BUT, Microsft Excel is not created for gathering data, especially in gathering relational data like master-detail structures. One basic, simple example. You want to gather (or track) Orders and then for this Orders you want to track Order Details and, for example, Order Payments. Not to mention, to do this in a multi-user environment. Boy,....., You will have a tuff time to do this in Excel, because Excel is simply not created for challenges like this, to gather master-detail data and also in a multi-user environment. But in this course, You will learn how you can do this by using Excel and VBA as a front end and MySQL database as a backend, whether the MySQL database is on your local machine, your local network, or on the web server. And then you can connect to this data from Excel and use it. We will do this with help of a small tool called Virtual Forms. Hello, 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 to create CRUD Forms, forms to create, read, update and delete records that are stored in databases like MySQL, MSSQL, Access (On-premise or on the web) and all that in minutes. It is similar to what Access can do, but you could also port this Virtual forms from Excel VBA to Visual Studio 2017 (C# or VB.NET). You can not do this with Access. So, you just need to create a database and tell the Designer which fields you want on your form. Once created Virtual Forms can be also used as LookUp forms in Excel VBA with no extra work. All the controls that are generated on this Virtual forms can be accessed with VBA (or if you use Visual Studio 2017 with C# or VB.NET).

@https%3A%2F%2Fwww.udemy.com%2Fcreate-excel-vba-apps-using-mysql-database-virtual-forms%2F%3Futm_medium=linkshare%26couponCode%3DVFFREE1

Course Info

• 42 Lectures
• 4.5 Hours
• Language: English
• Subject: Development, Microsoft
• Instructed by: Davor Geci
• Platform: Udemy