The Ultimate Excel VBA Userform with Access Database
4.4 (83 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,203 students enrolled

The Ultimate Excel VBA Userform with Access Database

Build Your Own Real World Program, Learn Real Excel VBA(Macros), Exceed The Limits of Excel with Complete Project
4.4 (83 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,203 students enrolled
Created by M. Mustafa BOLAT
Last updated 8/2020
English
English, German, 1 more
  • Turkish
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 5 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Directly apply to your own work
  • Create Access Databese
  • SQL Queries (Select,Sum,Like,Where...)
  • Master Excel VBA & Macros & Userforms
  • Build Advanced Algorithms and Multi-User Program
  • IF THEN Statements, For Next-For Each Loops...
  • Login Form and User/Password Control
  • Designing Modern Looking Forms
  • All Form Controls
  • Create Advanced Reporting Tool Like Business Object/Business Intelligent(SAP)
Requirements
  • You Should Have 32 Bit of Office or Latest Version of 2016/2019 (64 Bit)
  • Having at least a basic knowledge of VBA will give you a better understanding of this course.
Description

Hello there. I'm Mustafa BOLAT

This is the only complete userform course on Udemy. So far, you've seen courses that only tell you the code, but not how to use it. With this course you will be able to do excellent work with Excel Macro.

In this tutorial, you will learn not only advanced code writing, but also database connections, algorithm development,

multi-user structures and query methods. After completing the training, it will be very easy for you to learn and develop any software language.

This is not an easy course. A very difficult course. But it is so much fun :)

Let's start training now. I'm waiting for you.


***** Please Watch The Preview Video Completely *****

Welcome to The Ultimate Excel VBA Userform with Access Databese, Udemy's only Advanced Userform course!

Imagine developing an advanced program without the need for any other programs or software knowledge other than Excel. I know you have had such a request for a very long time. That's why I decided to make this course.

Unlock Your Talents

  1. Logic of Developing

  2. How to Create Algorithms

  3. Loop Codes in a Loop

  4. Access to Excel Connection

  5. VBA SQL Queries

  6. Add New/Update/Delete Record

  7. Multi-user Program

  8. (SAP)Business Object-Like Reporting System

  9. Charts in Userform

  10. Visually Perfect Software

Who this course is for:
  • Anyone who wants to develop advanced algorithms, build multi-user programs and exceed the limits of Excel can participate in this training.
Course content
Expand all 31 lectures 09:45:49
+ Welcome
3 lectures 13:36
Methodology of the Course
00:39
Information
00:27
+ Introduction
3 lectures 23:46
Excel Versions
00:14
User form Controls
15:45
Use Textbox as Date Time Picker for 64 Bit
07:47
+ MS Access & Connections
4 lectures 33:36
MS Access Basics
12:41
Excel to Access Connections
11:35
Run Time Error 3709
00:35
Some of Basic Queries
08:45
+ Designing/Coding of Forms
21 lectures 08:34:49
Source File
00:01
Login Form/Load Form
35:38
Main Form
26:11
Show Logged in User and Real Time Clock
11:58
Transactions Form Listview
26:09
Transactions Entry Form - 1
34:47
Transactions Entry Form - 2
26:04
Dynamic Invoice Form on Excel Sheet
39:52
Suppliers Form - 1
20:26
Suppliers Form - 2
18:38
Customers Form
27:50
Staff Form - 1
26:17
Staff Form - 2
18:56
Products Form
33:18
Payment Methods Form
12:27
Stock Management Form - 1
22:56
Stock Management Form - 2
34:47
Reporting Tool - 1
26:16
Reporting Tool - 2
42:54
Last Edits - Show Only Forms|Hide Excel - Change Password Form
28:55
Bonus
00:29