Access VBA Intermediate Prototype System & Export to Excel

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 5 Hours | 851 MB

Genre: eLearning | Language: English

Download and learn to use the "Prototype" database that has helped me generate more than $500,000 of consulting income!

Take your basic knowledge of Access VBA to a entirely new level! You've built many useful VBA programs in my first Visual Basic course, but this is your opportunity to work with a FULLY FUNCTIONING SYSTEM that is ready to install RIGHT NOW!

Once you have been exposed to Access VBA a logical next question is "What could I create with VBA?". This course will give you an answer to that question by providing you with a finished system that you can start using right away. Rather than lead you through building parts of databases, this course examines the workings of this finished database that I have used in my consulting business for years.

Most of the employees in my client businesses know nothing about Access and the ribbon and navigator are always hidden, yet these people usually get more work done faster than experienced Access users! For instance, they don't have access to the filter functions on the ribbon, but they can quickly do searches using the "Power Search" programs in this database that would be challenging for anyone using the ribbon.

The database you receive as a download with this course is my "prototype" database that I built over the years after realizing that, no matter what the client or the job, there were a lot of very similar things that had to be done with the data. Why not have a database that does these things to start with, instead of building databases from scratch every time?

As I built up the prototype, I realized that it could also be the "closer" for new clients! I could use it to establish my credibility and also explain that I had built up an extensive "library" of programs that were contained in this system. With new clients, I found I could easily charge $500 when starting their first project for their access to this library of programs.

After more than ten years of billing $50,000 to $60,000 per year to clients who started with this prototype system, I realized that it had helped me create over a half million dollars of consultant income!

In preparation for this course, I have thoroughly reviewed the prototype database and updated it using Access 2013 and the database is usable by Access 2007 or later.

Inside the course I will show you a different approach to take with menu buttons and how you can setup the "Power Search" for any table in just a matter of minutes! You will also learn how to, with one click, create merge letters in Word with the search results or how to create and title a new Excel sheet.

Follow along as I take you step by step through the inner workings of this simple to understand, yet very powerful platform that is very understandable to any prospective client, whether they are computer savvy or not.

This system contains all the code to:

Provide a simple to understand and use menu system that can be used with the mouse or keyboard.

Control the proper addition, editing and deletion of records.

Quickly sort and locate records based on any item of data.

Instantly create letters and/or envelopes for the displayed record using Microsoft Word with two keystrokes.

Allow the user to do highly complex searches without knowing anything about Access.

Instanly Create reports based on those searches with complete descriptions in the title.

Export search results to a new Excel spreadsheet, then format and title it, with just a two keystrokes.

Create a merge document in Word with the search results for bulk mailing.

Allow you to add all these functions to an existing form in less than one minute.

If you take the time to master doing a demo with this database, you will instantly impress potential clients with your capabilities.

There will be no question of your computer background or certifications - this database provides your credibility. In fact I usually tell prospective clients that I have ZERO computer education and NO certifications, THEN I demo this system. BANG! New Client almost every time!

For a visual walk through of the prototype database, view the preview of the first lecture!

Once you have done that, clicking the Take This Course button is the logical next step in your VBA journey. Exporing this system will expand your abilities with VBA faster than anything else you could possibly do. Think of it! In just HOURS you could be ready to go find your first client!