Education is the most powerful weapon
which you can use to change the world.
-Nelson Mandela
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

News      User Comments     History     Notify Me

7/5/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
 
text
Updated 5 July 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.

WORKING ON RIGHT NOW:

Update to Windows 8 Level 1 to cover the Windows 8.1 changes, followed immediately by Windows Levels 2 and 3. If you've previously purchased Windows 8 Level 1, you'll get a free upgrade to the new 8.1 version when it's available. I've had my Windows 8 Level 1 class available for a very long time now, but never got around to making Level 2, so there are a TON of people on the Waiting List for it, and I'm going to satisfy you all very soon.

MORE OFFICE 2013 LESSONS:

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.

MORE ACCESS:

Of course, my goal is to release a new Access class at least every week or two. I hope to continue this throughout the summer as there is still a LOT of material to cover, and Access is - by far - the most popular topic.

COMING SOON:

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

NOTE: SEMINARS:

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

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


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

Regards

David


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

Selby  
ps - all your lessons are the best - thanks


Reply from Richard Rost:

Thanks!
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?
Al


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)
Regards
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
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 4+6:
  
  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

 

 
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
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