An investment in knowledge
pays the best interest.
-Benjamin Franklin
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order  

News      User Comments     History     Notify Me

3/16/2014 1:00:00 AM
Updated Production Schedule
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost
Updated 18 March 2014

This is a guide to what's coming up next, in order of release. Don't ask me (or Denise) for dates, as I never give them (Why? Click here for an explanation). You can find more information or pre-order these courses by clicking on the links below. Your credit card will NOT be charged until the course is actually released.


I'm working on a seminar to teach you how to send EMAIL using Microsoft Access. I'll use both Outlook and Gmail, but I'll show you how to send mail using almost ANY mail provider using SMTP. There will be lots of email list management techniques shown. It will be fun. I hope to have this out in the next couple of days, but with the Holidays upon us, I can't give an exact date.


Access Expert Level 20 - You can pre-order now by clicking on that link. You'll be added to the Waiting List and will receive a discount when it's released. I plan to do my best to release at least two or three new regular Access class every month until all of the old ones are updated. Just how many classes are going to be in the Access Expert series? I'm not sure. I have a lot of material I still want to cover before I make the jump up to the "Advanced" level. Probably 3 to 5 more classes.


I really need to get out the Beginner Level 1 lessons for Office 2013. These will essentially just be re-recordings of Word 2007 Level 1, Excel 2010 Level 1, Access 2010 Level 1, PowerPoint 101, Outlook 101, and possibly new lessons for OneNote and Publisher, although I'm not married to that idea. I know that most of you reading this DON'T need them, but I see that most of my competitors already have 2013 lessons out and I need to do so as well. These shouldn't take very long to make, and I'll give FREE copies to everyone who has purchased the previous Level 1 lesson for those. I'm not making any firm date commitments on these. I'll record them as I have time.


I've been getting a lot of requests for a SHORT lesson that covers all of the Access Beginner material in a quick, one-hour video geared towards 2013 users. LOTS of people ask me if they can just skip over the Beginner stuff and go right to Expert 1. Sure, you can... but there's a lot of GOOD material in there. Unfortunately, there's also a lot of duplication (I don't want to call it "filler" because I believe learning is best when you see some things more than once). So I'm going to make a short, one-hour lesson that goes through ALL of the material from Beginner 1 to 9 for people who don't want to watch 10 hours of lessons just to get the basics. It's going to cost THE SAME as if you were to buy 1-9 separately, so you're not saving any money by skipping the full lessons. I MAY also make one for the Expert series once it's done.


Several months ago, I started work on a seminar to handle personal finance: tracking expenditures, bank accounts, importing data from your bank's web site into Access, checking for duplicates, assigning categories for expenses, and so on. I started this project in early April so I could use it for my own finances to prepare my taxes. I finished the core of it, but it needs some embellishments and polishing. I'm going to try to have this out soon.

WAITING LIST RESULTS as of 14 March 2014:

As you know, I like to use the WAITING LIST as a means to guide what I work on next. Here are the most popular topics ranked IN ORDER on the Waiting List. This order hasn't changed since June.

01. Access 2013
02. Windows 8
03. PowerPoint 2013
04. Outlook 2013
05. Excel 2013
06. Visual Basic 2012
07. Word 2013
08. SQL Server Seminar
09. Access Barcode Seminar

Like I said, I generally use the Waiting List as a guideline, but it tells me what all of you are interested in. I will say that there are FOUR TIMES as many people interested in Access 2013 as there are the #2 items on the list, Windows 8. So that's one of the reasons I've been working so hard to get all of the Access 2013 lessons out. LOTS OF YOU WANT THEM! So if there's something YOU want to see made into a lesson, VOTE FOR IT!

ALSO IN THE QUEUE: (in no particular order)

Alex requested that I make a seminar dealing with Updating an Access Front-End database file in a split-database environment using batch files and other crazy automation. So I may throw this one in at any time.

These are all pretty popular requests. VOTE for them NOW on the Waiting List:

Publishing Access Databases Online with SharePoint
Using Access with SQL Server
Visual Basic 2012 Beginner 1
Using Access with a Barcode Scanner for Inventory
Certifica Gift Certificate Database

I've also got a couple of other requests from clients for additional database work that will most likely be turned into seminars as well, so these can get injected into this schedule at any time. If you have a need for custom database work, let me know. If I can turn it into a seminar that others will benefit from, I give a huge discount on my normal hourly rate. Contact me here.

EXCEL ADVANCED has surprisingly few people signed up for it on the Waiting List. As of right now we only have about 40 people signed up, whereas Visual Basic has twice that, and Access has over 400 people waiting for the next lessons. So you see where my priority has to be right now. YES, I'm definitely going to throw a bunch of advanced Excel lessons in there, but I probably won't get to them until this summer... unless people VOTE FOR EXCEL on the Waiting List.

HANDBOOKS are generally ready within 1 week of the final release date of a course... unless it's a long seminar. Then it can take longer.

This list has been determined by the voting results on the Waiting List. If you are interested in helping to determine what courses are made next, visit the Waiting List now and cast your votes. There were surprisingly FEW votes for Photoshop. This used to be one of my more popular classes. If you'd like to see new Photoshop classes, click here. I'm also quite surprised that Excel Expert is so low on the list. I've gotten a lot of emails from people asking when more Excel lessons, but perhaps these people aren't signing up on the Waiting List (hint hint).

Now, remember, everyone... if you purchase any of my CURRENT lessons from now until the release date, you will get a FREE upgrade to the new course when it's available. If there's anything else that you'd like to see, please let me know. Comments? Questions? Post them here. Thanks.


I've got a LOT of seminar ideas planned for Microsoft Access, Excel, and more. You can see the full list here. I'm going to release these based on the signups on the Waiting List (see that link). Once any particular seminar gets at least twenty (20) students signed up for it, then I'll start working on that seminar (so they could come out at any time, based on signups). So if you're interested in a specific seminar, sign up for it now! And remember, your credit card won't be charged until that seminar is available. You can back out any time... and you will never be charged more than the amount shown (and sometimes less). If you have any questions, Contact Me. I've also got a few MINI Seminars planned that will only cost a few bucks, but cover something specific that a bunch of people have asked me about... too long for a free TIP video, but not long enough for a normal seminar. Stay tuned.

And, of course, as a disclaimer, NOTHING listed above is set in stone. These are ESTIMATES ONLY. The tutorials I release may change at any time depending on demand, need, customer interest, or even just my whim. I like to keep you guys "in the loop" as best I can, but remember that things may change.

Permanent Link
Keywords: production schedule
Post Reply

Updated Production Schedule Comment from Mars @ 9/29/2013
I'm looking forward to your course with the personal finance and importing data from bank accounts with categories. Will definitely buy that one. I'm excited now
Show Just This Thread        Post Reply
Updated Production Schedule Comment from John Lanigan @ 8/2/2013
Interested in getting the windows 8
material, as soon as it's available.
Thanks (Great Stuff) John Lanigan

Reply from Richard Rost:

I'll post on the site news as soon as it's ready.
Show Just This Thread        Post Reply
Further Windows 8 Courses Comment from Paul Wade @ 7/26/2013
Good Day, Richard,

First, your programs are great. I've seen some bits and pieces about additional learning modules for Windows 8. Are these in the program for production? Bye for now! Paul

Reply from Richard Rost:

Yep. Windows 8 Beginner Levels 2 to 5 are scheduled for production soon. Check the PRODUCTION SCHEDULE for details.
Show Just This Thread        Post Reply
Updating split Access database Comment from Chris B @ 4/8/2013
Hello Rick
I split databases a lot but what concerns me is updating the distributed back ends. Like if a new table is added, fields added to existing tables etc.
Also any slick way of getting a new front end to link to the existing back end.
Any guidance here would be much appreciated.
form Chris on holiday in Hong Kong :o)

Reply from Richard Rost:

Updating table fields on your back-end is best done with a recordset or some SQL. I covered modifying tables in SQL in part 3 of my SQL SEMINAR. I'm planning to cover table manipulation with DAO recordsets in an upcoming lesson.

If you match the SHARE NAME of the back-end's folder then you don't have to worry about relinking. For example, if you call it "//SERVER/Database/" on all machines, then you're all set. Nothing to relink. You can relink with VBA code. I covered that in my Access Security Seminar.

Show Just This Thread        Post Reply
Updated Production Schedule Comment from James Fisher @ 7/7/2012
Hi Richard.
Thanks for the update Richard. Is the Sharepoint seminar hight on the list as you very kindley said you'd push up the order for me?. I'm please SQL server is hight on the list

Reply from Richard Rost:

Yes, indeed, James. I forgot to put the seminars on the web site list. I just updated it.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from James Fisher @ 6/11/2012
Hi Richard. I'd like to see the sql,Sharepoint seminar. Yes I will be voting for thease classes. Please would you include some learning material on error trapping and how to eal with errors. I kind of know the basics. Thank you
Show Just This Thread        Post Reply
Updated Production Schedule Comment from Jmaes @ 6/8/2012
How much longer until Access 4 and 5 are realeased?

Reply from Richard Rost:

Working on it now. I've had some unexpected delays, but I hope to at least have 4 out this weekend.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from James F @ 6/6/2012
Hello Richard. Thank s for the update. Do you have a projected completion date for the Search and Sort seminar?.
Will this still be covered in 3 parts

Reply from Richard Rost:

No, and probably. :)  No, I do not have a date for the seminar yet. I'm still trying to get through Access 4 and 5. Yes, the seminar will PROBABLY be in 3 parts, MAYBE just 2. I haven't decided yet because it's still in outline form. I have to see how long the videos for part 1 are first.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from David @ 12/29/2011
Hi Rick

I have not yet, but expect very shortly to purchase Access tutorials from you.

I will also soon be very interested in the processes necessary to bring an Access database "to market". ie How to commercialise a software product. For instance how to exclude source code and only to ship an object version.  How to exclude other features of access which are necessary for development (eg Navigation panel, Properties etc. etc.) from a shipped product.  And how to place an Access product on the market for sale etc etc

Might such tutorials as this fall within your ambit?



Reply from Richard Rost:

I do talk about most of these things in my lessons, yes. The database we build in my numbered classes (101 to 329) is built with end-user distribution in mind. I talk about encrypting your database and securing it for release in my Security Seminar.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from Mimi @ 11/8/2011
I would like to see either lessons or seminar in creating an Access database for web if possible.

Reply from Richard Rost:

Wow. I can't believe I haven't added this to the Waiting List yet. The best way to get an existing Access 2010 database online for a limited number of users is to use a Sharepoint server. I will be making a seminar on this in the future. If you'd like to vote for it on the Waiting List, click here.

Of course, if you want to make a publicly accessible database with an Access back-end database powering it, I still recommend my Web Database Seminar and ASP.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from Bill Turner @ 10/23/2011
PLEASE Rick try to get to the Windows 7 Beginner 1 - 5 courses soon. Have been waiting patiently for months and it keeps getting put back on the list. Need to find my way around on Windows 7 and desparately need your courses. Thanks  Bill Turner.

Reply from Richard Rost:

OK, Bill. I'll do my best.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from Ramon Salvo @ 9/16/2011
Photoshop courses are too complicated.  IMHO, needs simplification or further categorization.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from jimmy @ 6/11/2011
i think that it's will be a good idea to make some photoshop courses,  (and of curse  add a few tips in you tube for advertisement) and then you will be able to see if there is a demand for photo shop courses, i supposed that most of the  potential customers are passive and they are not voting in the vote list
Show Just This Thread        Post Reply
Updated Production Schedule Comment from jimmy @ 5/17/2011
thanks for your excellent courses...
but please try to stand on your scheduled times, (or to let us know if there is any delay  and to give a update your schedule)....
best regards
Show Just This Thread        Post Reply
Access 307 Comment from Selby @ 5/14/2011
Dear Richard,
Thankyou very much for this great lesson (307). It is great that you donot delete any portion of a video to 'make it better', it is great to learn all the things that make access.To learn what you do when you try and solve a problem, many thanks

ps - all your lessons are the best - thanks

Reply from Richard Rost:

Show Just This Thread        Post Reply
Updated Production Schedule Comment from Delaware @ 4/15/2011
I would use make few hours of tutorials about definitions.  Modules are comprised of related task routines.  Components include data structures, utilities, Microsoft messaging, etc.  Then move to issues of coupling and granularity.  I find the detail is based on the sample project in 599CD series.  More study of standard(s) and/or definitions and very basic impementations in real world programs  would be good basic tutorial material.  Only that it would have less practical reference for a video.  The first tutorial would be on layers of design, and structured programming concept.  Title is Wind powered technology, used in new Space shuttle air bag.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from Alex Hedley @ 2/24/2011
Has the Access Seminar been put on the backburner?
It was on the schedule for a while but now has gone?

Reply from Richard Rost:

It's on the side burner. I'm actually working on Excel Expert AND the Access seminar at the same time. I'm still in the research gathering phase for the Access seminar right now... making an outline. Gathering notes (i.e. stealing ideas from other books). LOL
Show Just This Thread        Post Reply
Future Purchases Comment from Alan Hill @ 1/18/2011
I saw the price of some software and nearly fainted, but when my daughter returns to school after the Christmas break. She will have a student ID card.
With that card the picture is far rosier. So
Visual Studio 2010 is now on the list
Abobe CS5 Student Edition is now on the list
That will keep me quiet for an hour or two.
Best wishes
Alan Hill

Reply from Richard Rost:

Remember, you can download the Visual Studio 2010 Express Edition for FREE from Microsoft. There are some limitations, but for LEARNING the language, it's just fine.
Show Just This Thread        Post Reply
VB Comment from Chris Bezant @ 1/11/2011
Hello Richard
Happy New Year.
My time is currently dominated by the fantastic Access and VB in Visual Studio 2010 so I'm glad to see both of those subjects featured in the list :o)
Chris Bezant

Reply from Richard Rost:

Coming very soon... :)
Show Just This Thread        Post Reply
Comment from Richard @ 1/9/2011
Oh, and I might throw in the occasional advanced Access Seminar in there as I have been known to do in the past. Again, this is determined by customer need... which is why my schedule is so fluid.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 4+3:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP