If you can't explain it simply,
you don't understand it well enough.
-Albert Einstein
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

9/22/2018 12:01: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 Production Schedule
Updated 22 September 2018

This is a guide to what's coming up next, in order of release.


I just finished Access Developer 11.


Right now I'm doing my best to release one new Access Developer lesson per week. I'm just now getting over bronchitis, so I've been a little delayed, but I hope to have D12 and D13 ready to go by the middle of next week.

During this time, I'm also going to be updating my Level 1 Beginner courses for all of the Office apps: Word, Excel, PowerPoint, Outlook, and new classes for Publisher. These are long overdue. I also need to make Expert lessons for Word, and VBA lessons for Excel.

Windows 10 has also surprisingly been high on the WAITING LIST so I'm going to try to get some lessons out for that, but Microsoft is planning a new major release for Windows next month in October, so I'll probably wait until that's out.


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

Database Distribution Seminar or mini Seminar Comment from A Rajan @ 11/10/2018
Yes...It will be great if you can arrange a seminar on distributing access projects.
Show Just This Thread        Post Reply
Updated Production Schedule Comment from Verna C @ 3/1/2015
I am looking for something like project management with micro soft. I am sure this would big market, thanks
Show Just This Thread        Post Reply
Access Coverage Comment from Chris Thompson @ 2/8/2015
I don't recall seeing this and perhaps it is already covered; but do you talk to the customization of the Access menus and how to enable / disable them to meet your needs? (e.g., Disabling the print button on print preview,  hiding other buttons and features from users depending on their admin level, etc.)

Reply from Alex Hedley:

I can't remember if Ribbon customisation is covered in the Security Seminar.
This can get quite trick and enabling/disabling can lock you out of the db completely.
You can build up the ribbon using a XML tool or writing it yourself.
Might be a cool mini Seminar.
Show Just This Thread        Post Reply
Dates Comment from David Powell @ 1/10/2015
Hi Richard & compliments of the season.

I owe you a response for your courtesies of a couple of months ago. Will write soon.

Regarding Dates: Hopefully your "all-encompassing" Dates seminar will address issues of non-USA formats. I have spent masny frustrating hours dealing with Dates of dd/mm/yyyy format (my regional Windows setting) granted that Access internally operates as mm/dd/yyyy. I guess there are enough of us to merit attention in this regard. Also, commonly, there are many who operate in yyyy/mm/dd format.
I have fixed the immediate issues that I have had (using '\/' separators). I don't understand why I have had to do this nor, for me, is the interrelationship between Dates used via tables (recordsets), variables and text boxes unambiguous. In many ways internet forums sometimes confuse rather than aid. These days your  clientele is cosmopolitan so I may not be just a lone voice on this subject.

Again Best Wishes
Show Just This Thread        Post Reply
Expert Advanced Access 2013 Comment from EIrik @ 7/28/2014
I see. But 2-6 is good enough for me. Better than 20-30 ;)

Reply from Richard Rost:

There are just SOOOOOO many topics to cover that there's no way I could cram it all into 5 or 6 lessons. However, you don't have to take ALL of them. Once you're beyond Expert 3, feel free to skip lessons if you don't think you need them. By that point you have a solid foundation. Some people, for example, may not need to know the import/export material, so they could skip Expert 19 to 23. It's all about what YOU want to learn.
Show Just This Thread        Post Reply
Expert Advanced Access 2013 Comment from Eirik @ 7/23/2014
How many expert series will you make before you move on to converting advanced and developer access to 2013? I know there is no dates and a floting plan because you work after the waiting list, but what is your thought here?

Reply from Richard Rost:

I can't give you an exact number. I have at least 2 or 3 more Expert classes planned - and every time I think I've covered enough I find 2 or 3 more things that I should put in the Expert classes. Just today, in fact, a customer emailed me a question about something and I said to myself, "oh, that's a good topic for the Expert classes..." so we'll have to see how it goes. I don't want to start the Advanced classes and then have to go back to something that SHOULD have been in the Expert classes.
Show Just This Thread        Post Reply
Database Distribution Seminar or mini Seminar Comment from Uriel R @ 7/19/2014
It would nice if you could make a database distribution/deployment seminar or mini seminar. The material on your classes is great, the way you teach and record your videos is very professional and easy to follow, not to mention when you leave "mistakes" in so that we can understand related concepts and troubleshooting but I think that all the work we put into creating databases can wasted if we do not properly prepare out database to be deploy. I have take several of your classes and these are suggestions of things that you have cover in your classes already that can be include in this seminar:

-Record Locking
-Splitting database
-Reference libraries
-32/64 bit versions of access (and how to know which one you are working with)
-Working between 2003,2007,2010 and 2013 versions of office
-Make ACCDE files

I know some of these are more theory than practice but those concepts that must be take in account while building the database should go first in the course, like the record looking, or the 32/64 version since it will affect the final product (In fact I build a 64 bit 2013 database but didn't work on the 32 bit 2007 access of the computer that was actually intended for). Other topics I would like to see will be:

-how to distribute different versions
-send database updates automatically over your LAN and over the internet
-add signatures, copyright to final versions
-how to add help files and how to in the database itself
-program events or vba code to work when the database is first open
-prompt the user for information to setup the database when it is first open
-automatically add reference libraries
Show Just This Thread        Post Reply
Access Split Databases Comment from Chris B @ 5/12/2014
Hello Rick
I like to split databases to facilitate updating front ends but the two concerns I have for my less techy users are:
Compacting the back end - how can I do that from the front end?
The other concern is when table structure changes, how do I manage that? Is there a clever way to re-link the tables after an update to the front end? Yes, I know about the Link Table Manager but that is too scarey for some of my users.
So a seminar on managing split databases would be very welcome.

Reply from Richard Rost:

Compacting the back-end is something that's done as a weekly maintenance event, by you, manually. There is VBA code I've tried using before to compact it, but it's unreliable in my opinion. This is just one of those things I recommend you schedule some time for, once a week (or even once a month, depending on how much your db gets used), kick everyone offline, and quickly run a compact on the server.

Table changes can be manipulated using DAO (recordsets) which I haven't covered yet, but I will when I get to the Developer series. You can change them with SQL commands (see SQL Seminar, Part 3) but those commands have to be issued on the "server" machine, and not from a linked database. I've done it before using a "main menu" form that stays open on the server and can issue remote commands like this. Kind of tricky, but it works. DAO is much better.

I'll add these two suggestions to the list (along with the other requests I've gotten) and perhaps I'll put together more on this in an upcoming seminar.

Show Just This Thread        Post Reply
Updated Production Schedule Comment from Daniel @ 4/11/2014
Please i will like to buy some of your product but am in Ghana (West Africa)where can i purchase it? Daniel

Reply from Richard Rost:

Right here on the web site. I don't have any retail outlets (yet).
Show Just This Thread        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 3+5:
  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
Change Email
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