Access VBA Intermediate: Power Search & Word or Excel Export
4.9 (83 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,738 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access VBA Intermediate: Power Search & Word or Excel Export to your Wishlist.

Add to Wishlist

Access VBA Intermediate: Power Search & Word or Excel Export

Download and learn to use the "Prototype" database that has helped me generate more than $500,000 of consulting income!
4.9 (83 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,738 students enrolled
Last updated 5/2017
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 5.5 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • install the prototype database and use all the basic functions
View Curriculum
  • Students should have a basic familiarity with Access VBA.

Take your basic knowledge of Access VBA to an 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!

From a Student Review -

"The content is really excellent, and comprehensive. The content has really brought to light many techniques that I am finding extremely useful. I am really looking forward to the advanced course!. Many thanks, Bruce!" - Ray McConaghy

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.

Another Review -

"If you are like me wanting to get a better understanding of the power of VBA in Access, then this is the course for you! Bruce is a Guru when it comes to VBA in Access. This course provides a fully developed system and then takes it apart to show how it works. I am having a lot of fun in analysing the code behind the various forms so that I can use it it in other programs. Bruce has an engaging style of presenting and he clearly explains the steps involved. Highly recommended!" - John Ovens

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:

  1. Provide a simple to understand and use menu system that can be used with the mouse or keyboard.
  2. Control the proper addition, editing and deletion of records.
  3. Quickly sort and locate records based on any item of data.
  4. Instantly create letters and/or envelopes for the displayed record using Microsoft Word with two keystrokes.
  5. Allow the user to do highly complex searches without knowing anything about Access.
  6. Instanly Create reports based on those searches with complete descriptions in the title.
  7. Export search results to a new Excel spreadsheet, then format and title it, with just a two keystrokes.
  8. Create a merge document in Word with the search results for bulk mailing.
  9. 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 previews in the first section.

From a Student Review -

"This course is real value for money. I have learned a lot of new skills!" - Johan Kritzinger

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!

Intended Audience:

This course assumes that you have either gone through my "VBA for Non-Programmers" course or you are already familiar with VBA. BUT, the system could be used (but not modified) by anyone that can follow the video instructions for setting it up.

Course Requirements:

You should have Office 2010 or later. The course was created using Office 2010.

Who is the target audience?
  • This course is for students who have some familiarity with Access VBA and are ready to become more productive with Access.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
61 Lectures
Introduction and Feature Demonstration of the Access Prototype Database
10 Lectures 45:18
Download Link for the PowerSearch Database

Rules for Using the Prototype Form

The Form Control Table

Using the Prototype List Form

Using the Prototype Listing Report
How the Function Key Menus Work
4 Lectures 14:46
Why Use These Function Key Menus?

How Are the Buttons Built?

What Does the Menu VBA Code Look Like?

The FormMenu Function and ModeSub Subroutine
How the Basic Menu Functions Work and Access VBA Code
12 Lectures 01:24:14
Examine code behind the ADD selection

Examine code behind MyYesNoBox

Examine code behind the EDIT and DELETE selections

Heads Up On a BUG - See If You Can Find It!

Examine code behind the LIST FORM selection

Coming Back From the List Form to the Full Form

Explanation of the Bug And Prep the Full Form to Send Multiple Open Arguments

Modification of the List Form to Receive Multiple Open Arguments

Make the Same Changes for Going From the List Form to the Full Form

Examine code behind the SORT selection

Examine code behind the SALES PERSON selection

How the NOTES Box Works
Working with WORD 1 - Instant Letter or Envelope with Access VBA.
7 Lectures 29:56
Instant Letter Code 1 - calling the Instant Letter function

Explore References to Other Program's Object Libraries

Instant Letter Code 2 - Examine the PrepInstant function

Instant Letter Code 3 - Opening Word and setup document

Find Command Syntax by Creating Macros in Word

Instant Letter Code 4 - Create the letter and leave Word Open

Examine the Instant Envelope Function
How SEARCH Works - Examining the Access VBA Code
16 Lectures 01:31:35
Tracing the steps to setup criteria mode

Creating the search table if it is not there

The idea behind the search table - all text fields

Finish Inspecting the SetupSearch Subroutine

Revisit Criteria Mode and Test Search

Inspect the Code Behind FinishSearch

Processing Search 1 - Examine the ProcessSearch Function

Processing Search 2 - Using Collections for Field Names, Types and Values

Processing Search 3 - Overview of the CheckFilters Subroutine

Processing Search 4 - Processing a Search Value

Processing Search 5 - Testing for Wildcards and BLANK or NOT BLANK

Processing Search 6 - Review of InStr and Mid Functions

Processing Search 7 - Examine the Comma Criteria for Range of Values

Processing Search 8 - Examine the SemiColon Criteria for Multiple Values

Processing Search 9 - Processing Literal Values and NOT

Processing Search 10 - Why Separate Sections for Numbers, Text and Dates?
Working with EXCEL - Export to Excel and Modify Spreadsheets using Access VBA.
2 Lectures 12:25
Examine the Send Search to Excel Function

Manipulate Excel with VBA
Working with WORD 2 - Creating Merge Letters and Envelopes with Access VBA.
3 Lectures 13:37
Examine the Code Behind Merge Letters

Examine the Merge Engine Function

Examine Merge Envelope
The Access VBA Code Behind the Prototype Forms and Report
5 Lectures 35:24
How Can Prototype Work for All Forms?

What Happens on Form Open?

The VBA Code Behind the SetupFormTbl Function

Review of Open and SetupFormTbl in the List Form

Review of the Code Behind the Prototype Listing Report
1 Lecture 05:45
Bonus Lecture - Learn Even MORE!
1 Lecture 08:05
Bonus Lecture - Expand Your Knowledge!
About the Instructor
Bruce Myron
4.6 Average rating
4,335 Reviews
45,188 Students
17 Courses
Productivity Specialist

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.

"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce

I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.

I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.

In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.

Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.

My goal is to show my students how to create systems that business will value and that will create long term income.

Billy Myron
4.7 Average rating
2,074 Reviews
15,630 Students
14 Courses
Udemy Instructor

Hello, my name is Billy. I was born and raised in the state of Oregon, and still live there.

On Udemy, I primarily assist Bruce Myron as an instructor on his courses. They deal with Microsoft Access, Microsoft Access VBA, and other Microsoft Office programs such as Excel.