Latest Courses
Full Web Development Course - HTML, CSS, Bootstrap and ReactCheck course
Build a WordPress plugin instead of using theme's functionsCheck course
Hands on Introduction to C Programming in the TerminalCheck course
Simply NFTCheck course
Java 2021:Complete Java Masterclass:Zero to Hero ProgrammingCheck course
Python Programming Practice for CBSE Class 11th & 12thCheck course
Full Stack Web Development 2021 Guide with NodeJS & MongoDBCheck course
Full Stack Web Application Development with Django FrameworkCheck course
Unreal Engine 4 game development training for beginnersCheck course
Build a Mobile App without Coding in 2 HoursCheck course
Full Web Development Course - HTML, CSS, Bootstrap and ReactCheck course
Build a WordPress plugin instead of using theme's functionsCheck course
Hands on Introduction to C Programming in the TerminalCheck course
Simply NFTCheck course
Java 2021:Complete Java Masterclass:Zero to Hero ProgrammingCheck course
- 86% Create Excel apps with MySQL & Virtual Forms & Excel VBA

Create Excel apps with MySQL & Virtual Forms & Excel VBA

$94.99 $12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 1
Add to compare
9.0/10 (Our Score)
Product is rated as #6 in category Excel

Microsoft Excel & Microsoft Power BI are 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 like master–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 a multi–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 FormsYou will learn how you can do this by using Excel 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. 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.

Instructor Details

Davor is a veteran programmer with 20 years of being a professional programmer and 15 years of building companies as CEO or helping others as an HR consultant in employee recruitment. Specialties: VB, VBA, Error Handling, Google Analytics, Azure Application Insights, SQL, Databases, Excel, Access, MySQL, MSSQL. Currently: CEO & Founder at WinPIS Recent projects: Virtual Forms for Microsoft Excel VBA (NEW UserForms for Excel VBA) VBA Telemetry (connect VBA & Google Analytics or (and) Microsoft Azure Application Insights) Recent projects in detail: Virtual Forms for MS Excel VBA: Simple but powerful Userform control for Excel VBA so that anyone can use it, even without a single line of Excel VBA code! Create few sheets in Excel Workbook, or create few tables in the database like MySQL. Tell the Virtual Form Designer which fields you want that UserControl will use. And you re done. ##################################### VBA Telemetry: Log & Track Events, Metrics & Errors from VBA (Excel, Access, Word, Powerpoint, ...) projects in real-time using Google Analytics or (and) Microsoft Azure Application Insights. VBA TELEMETRY: Allows us to log and track events, metrics and errors from VBA in real-time. Track usage of your VBA (Excel workbooks, Access projects) from around the world. Example: You have created a killing Microsoft Excel Workbook or Access project. Then you distribute this Excel Workbook or Access project to your users or customers. But how do you know if there are any errors, what parts of your VBA project is used the most, which function, routine or part of the code is executed faster or slower on your users or customers computers, or is it used at all? Now you can, with help from VBA Telemetry and Google Analytics or (and) Microsoft Azure Application Insights. IN A NUTSHELL: Add online Error Tracking, Usage Tracking of your Excel Workbooks, Access projects or any VBA project, from around the world.

Specification: Create Excel apps with MySQL & Virtual Forms & Excel VBA

Duration 8.5 hours
Year 2020
Level Intermediate
Certificate Yes
Quizzes Yes

13 reviews for Create Excel apps with MySQL & Virtual Forms & Excel VBA

4.6 out of 5
9
3
1
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Wiola

    Love this course. It is useful guide how to work with virtual form. I met first time with this tool on udemy and I think it is great solution for excel GUI. Good job codesigners!!!

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Jon A

    Excellent teaching approach.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Santiago C. Gloria

    It’s somehow exciting and what a great experience! Indeed, this would help me significantly in Managing our logistical & Statistical data in our office. What Great a inputs!

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Warren Hall

    Good pace, thorough, sufficient detail. Easy to follow. Enormous amount of information presented, but with complete detail.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Wendell Keithan

    Not to far in to but already feel i am learning a lot. great teacher with a down to earth way about him. if you love excel and databases as i do thinking you will love this course. thanks you Davor i finished the course the only thing is sad i did Davor you are a great teacher. i am now going tru again to see what i might have missed. and practice and use it to remake some of my other programs better.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Johan Lambrechts

    Very interesting.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Ben Narbutas

    Couldn’t get MySQL to extract as a program. It extracted as a folder and couldn’t work out how to run it as a program file. Eventually went to another website and downloaded as a program file and ran.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Danish Ali

    wonderful experience, Learned some new things that are explained in this course in simple and easy steps.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Antonio Tiu

    Easy to understand

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Miguel Villegas

    Excellent choice for beginners.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    Probyncope

    early yet

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    Moreida

    Very easy to follow really excited!!!

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    Michele Smith

    You are wonderful! You explain everything very easy and make it easy for me to follow along. Thank you so much!

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Create Excel apps with MySQL & Virtual Forms & Excel VBA
    Create Excel apps with MySQL & Virtual Forms & Excel VBA

    $94.99 $12.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare