Thank you for the kind words, Rick. (Awesome name, BTW).

Yes, I often go online to watch tutorials on YouTube myself. Not only do I also learn things that way on topics I don't know much about, but I admit, I do check on my competitors from time to time to see what they're doing. I've found many tutorials are full of GOOD information*, but the presenter is hard to understand, like you said. I know a lot of them don't speak English as a primary language, but that makes it difficult on the listener. I had college professors like that, and I hated their classes. They were brilliant professors, but that didn't help me learn. I try my best to be easy to understand and entertaining, while teaching you at the same time. Comes from years of experience in the classroom (and in a rock band in my early 20s. LOL)

I know what you mean about the Beginner lessons being a little boring if you have experience with Access. I've been meaning to do this for some time, but I want to put together a quick Beginner Overview lesson. This would be for people who already have some Access under their belt and want to make sure they're not MISSING anything from the Beginner lessons, but don't want to watch 15 hours of video. I can condense most of that down into about 2 hours if I run through it quickly.

Cropping the screen! I know what you mean. I used to hate having to bounce around so much. Those lessons were recorded years ago when keeping video sizes small was important. Not everyone had high-speed Internet and huge monitors. All of my new lessons are recorded in full HD. I will re-record all of those older lessons eventually, but I've got so much on my plate already keeping up.

I strongly recommend AGAINST storing documents INSIDE your database. It makes the database big, fat, and slow. I teach a technique in my Access Imaging Seminar that you can use with ANY file object. The user picks the file, Access copies it to a specific folder on the server, and stores a LINK to that file in the database. Much more efficient.

Relationships are covered in detail in my Access Expert 1 and 2 classes, and of course my Relationships Seminar which goes into MUCH more detail.

Inventory control was originally covered in my old Access 320-329 classes. I will be redoing this again soon in the new Developer series.

Splitting and Encrypting your database into an ACCDE file is covered in Access Expert 21. If your end user already has Access, that's all they need. Distributing your database with the Access Runtime to give to people who don't have Access is something I haven't covered yet, but I will be soon.

Naming conventions are important! One thing I didn't use to stress years ago that I try to follow now is also to keep all of your field and table names SINGULAR. I'm still paying that price. I've got a table on my web site (where this conversation is actually stored) called CommentsT. I've referred to it in a million pages so it won't be easy to change, and every now and then I code something and type CommentT. Drives me nuts! I built this table back in 2008 I think, and it's too ingrained to change now.

* Just remember folks, if you take information from ONE source, it's plagiarism. If you take information from multiple sources, it's RESEARCH. :) Seriously... how do you think I've learned everything I know? Books, YouTube, and Google.