udmy-mavbadaw3.nfo
Udemy - Microsoft Access VBA Design and Advanced Methods Workshop 3 (2017-02)
URL: https://www.udemy.com/access-vba-workshop-3
Learn new secrets to creating awesome Microsoft Access databases and VBA coding
not covered in any of my other courses!
Lectures: 23
Video: 2.5 Hours (720p : 1280x720)
Skill level: Intermediate Level
Language: English (AAC : 2.0 192 kbps)
Subtitles: N/A
Instructed by: Bruce Myron, Billy Myron
Size: 472 MB
Container: MP4
Description
NOTE: Two New Sections will be added on Tuesday, Feb 28th! The first will guide
you through creating a generic 3 Button Form where you can specify the captions
on the buttons and the user prompt. The last section will take you through
building a VBA function that cleans a large amount of phone number data in
seconds!
After creating more than a dozen courses on Microsoft Access databases and
programming in VBA, many students have contacted me with discussions on specific
problems and scenarios. From these discussions, I have created videos reviewing
the details of the most useful techniques that everyone will eventually need.
I have made sure that every detail of these techniques is recorded in the videos!
BUT you should be somewhat familiar with VBA since there are lots of coding
examples in the course. There are MANY tips and tricks in this course that you
will not find an ANY of my other courses!
I also include a specific design challenge from a student and then go over the
details of how I would handle it. If you are willing to take the time to go
through this course you could easily be much more productive with Microsoft
Access in just a few hours!
This course is "hands on" and has exercise files for every section. This is not
a course you just watch - you learn new techniques by watching each lecture
step, then doing them yourself!
There is a HUGE need in the marketplace for people who REALLY know how to create
Microsoft Access databases and use VBA. This is your opportunity to break away
from the pack of people who struggle to create effective systems. Stop being
like everyone else and and learn how to use Access MUCH more effectively than
just about anyone else!
__________________________________________________________________________
In addition to the Udemy 30-day money back guarantee, you have my personal
guarantee that you will love what you learn in this course. If you ever have any
questions please feel free to message me directly and I will do my best to get
back to you as soon as possible!
__________________________________________________________________________
What I am NOT able to do for you in this Course..
applying them WILL take work on your part. But You Can Do It! AND it will be
well worth it!
________________________________________________________________________
This course will not remain this price forever! It's time to take action!
Click the "Take This Course" button at the top right now!
...every hour you delay is costing you money...you could become the goto person
for Microsoft Access VBA!
See you in the course!
Sincerely,
Bruce Myron
Who is the target audience?
- A person who has some exposure to Microsoft Access VBA, but wants to learn
more advanced methods.
===============================================================================
SECTION - 01 Introduction and Overview
01. Introduction - 2:17
SECTION - 02 Using SendKeys and SelStart
02. Link for Downloading the KEYS Database - 0:00
03. What is SendKeys and How and When to Use It - 8:33
04. Using SelStart Instead of SendKeys - 11:13
05. Fix the Customer Prompt - 3:00
06. Using SelLength and SelStart with Text Boxes - 4:26
SECTION - 03 Creating a Stopwatch Program
07. Create a New Module and the Stopwatch Function - 7:40
08. Finish the StopWatch and Test - 3:57
SECTION - 04 Understanding and Using AutoKeys
09. What Is AutoKeys? - 3:53
SECTION - 05 Generating Random Values
10. Setting Up a Random Values Example - 6:30
11. Finish and Run the Plug Customer Type Function - 3:53
SECTION - 06 Create a Generic Three Button Form
12. Create the New Form and Add Controls - 8:44
13. Create the Open and Click Subroutines - 8:33
14. Create the Add Customer Button - 9:07
15. Modify the Three Button Form - 4:44
16. Finish the Add Customer Subroutine - 8:20
SECTION - 07 Design Challenge Cleaning Phone Number Data
17. Link for Downloading the FixPhone database - 0:00
18. Examine Records and Create FixPhone Function - 6:09
19. Start building the FixPhone Function - 8:02
20. Finish the FixPhone Function - 8:03
21. Final Fixes on the NewPhone Data - 9:24
22. Modify FixPhone Into a Generic Tool - 6:48
SECTION - 08 Conclusion
23. Conclusion and Review - 2:58
|
|