Workshop 3: Access VBA, Design and Advanced Methods

Workshop 3: Access VBA, Design and Advanced Methods, available at $74.99, has an average rating of 4.55, with 23 lectures, based on 203 reviews, and has 3589 subscribers.

You will learn about Perform several advanced Microsoft Access techniques that will enable them to create more robust database systems Use the SendKeys function and manipulate selection size with SelStart and SelLength Create and run a StopWatch program to calculate elapsed time. Create an AutoKeys macro to call programs with keystroke combinations. Generate random values and use them to populate data sets. This course is ideal for individuals who are A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods. It is particularly useful for A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.

Enroll now: Workshop 3: Access VBA, Design and Advanced Methods

Summary

Title: Workshop 3: Access VBA, Design and Advanced Methods

Price: $74.99

Average Rating: 4.55

Number of Lectures: 23

Number of Published Lectures: 23

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Perform several advanced Microsoft Access techniques that will enable them to create more robust database systems
Use the SendKeys function and manipulate selection size with SelStart and SelLength
Create and run a StopWatch program to calculate elapsed time.
Create an AutoKeys macro to call programs with keystroke combinations.
Generate random values and use them to populate data sets.

Who Should Attend

A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.

Target Audiences

A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.

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..

I can’t guarantee your success – learning the concepts in this course and then 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�

Course Curriculum

Chapter 1: Introduction and Overview

Lecture 1: Introduction

Lecture 2: Important NOTE on DOWNLOADABLE RESOURCES

Chapter 2: Using SendKeys and SelStart

Lecture 1: What is SendKeys and How and When to Use It

Lecture 2: Using SelStart Instead of SendKeys

Lecture 3: Fix the Customer Prompt

Lecture 4: Using SelLength and SelStart with Text Boxes

Chapter 3: Creating a Stopwatch Program

Lecture 1: Create a New Module and the Stopwatch Function

Lecture 2: Finish the StopWatch and Test

Chapter 4: Understanding and Using AutoKeys

Lecture 1: What Is AutoKeys?

Chapter 5: Generating Random Values

Lecture 1: Setting Up a Random Values Example

Lecture 2: Finish and Run the Plug Customer Type Function

Chapter 6: Create a Generic Three Button Form

Lecture 1: Create the New Form and Add Controls

Lecture 2: Create the Open and Click Subroutines

Lecture 3: Create the Add Customer Button

Lecture 4: Modify the Three Button Form

Lecture 5: Finish the Add Customer Subroutine

Chapter 7: Design Challenge – Cleaning Phone Number Data

Lecture 1: Examine Records and Create FixPhone Function

Lecture 2: Start building the FixPhone Function

Lecture 3: Finish the FixPhone Function

Lecture 4: Final Fixes on the NewPhone Data

Lecture 5: Modify FixPhone Into a Generic Tool

Chapter 8: Conclusion

Lecture 1: Conclusion and Review

Lecture 2: BONUS Lecture! Learn Even More!

Instructors

Bruce Myron
Productivity Specialist

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 10 votes
4 stars: 51 votes
5 stars: 141 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu