Computer Learning Zone CLZ Access Excel Word Windows

It pays to keep an open mind, but not so open your brains fall out.

-Carl Sagan
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Captain's Log    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Training v Practice
Richard Rost 
           
14 months ago
Let's talk about the difference between training and practice.

Training is what you're doing when you're watching my videos. Reading. Studying. Learning new concepts. That's the training phase. It's where you're filling your head with new knowledge, figuring out how things work, and hopefully saying, "Oh, that's cool... I didn't know you could do that in Access."

But training is only half the story.

The other half is practice. And that's on you.

You've got to take what you learn and go use it. Build something. Make mistakes. Break things. Then fix them. Start your small business database, or your home inventory, or your baseball card collection if that's your thing. Create something that matters to you. It doesn't have to be perfect. It just has to be yours.

Then when you hit a wall, come back for more training. Learn the next thing. Then practice again. The cycle repeats.

The truth is, learning never stops. I'm still learning new things every day. I read, I explore, I experiment. But I also use this stuff every single day. I'm not just sitting in the captain's chair telling you what to do. I'm down in engineering, wrench in hand, getting dirty with the same tools.

I used to try including practice assignments and homework-style exercises in my lessons. But honestly, so few people ever did them that I gave up on that. So now, I just leave the practice part up to you. Build what matters to you, and when you get stuck, ask questions. That's what I'm here for. Between me, the forums, and our awesome moderators, we'll get you pointed in the right direction.

So go out there. Learn. Build. Break stuff. Then build it again. That is how you level up.

Make Scotty proud.

LLAP/RR
Lisa Snider  @Reply  
       
14 months ago
So true.  When I started building this database, I knew very little. Following the advice of a friend, I tried to "learn" by looking at how Northwind was structured.  My interest waned quickly because there was no "connection".  So I flipped, and decided, if I could learn Excel by applying it to my life and interests, I could do the same with Access.  And thanks to your videos, and sage advice, I deliberately broke my database to make it more efficient, and more intuitive.  There is still a way to go, but nearly every broken form is redesigned and working, VBA code is in place to automate some processes, and deleted queries replaced with far more efficient ones. Soon I'll have something that resembles the reports I had envisioned in the first place.  Now, what I'm building may not be of interest to the majority, but it has made my life so much better.  And because my data is based on my life, it's easy to determine what I need, and when something isn't working just right.
Bryan Enbey  @Reply  
     
14 months ago
It does make it more interesting when you do things in Excel or Access about things not only that which you need, but that which is interesting to you.  If you have some personal vision for something you're doing related to a hobby, family info, or just otherwise "cool", you'll be more inclined to play around with it and do more cool things with it, than merely some "boring" something just generated out of necessity.
Richard Rost OP  @Reply  
           
14 months ago
Lisa Snider the original Northwind database that came with Access 2.0 back in the 90s, I tore that thing apart. I learned a lot from that. I had a copy of the Access Bible, which at the time was my bible lol, and then if I wanted to see how they did something, I would just tear it apart.

Bryan Enbey I tell the story in one of my beginner lessons that I first got into computer programming on my TRS-80 Color Computer back in the 80s because I wanted to be able to design my own games and utilities for games. I made a dice roller for Dungeons and Dragons and then a character generator, which got me into programming because it was something that I loved to do. I took one passion and developed another out of it. Same thing with databases. One of the first databases that I built was to store my Magic: The Gathering cards.

And then I actually decided to do real consulting work and make money with it and stuff like that, lol. Yeah.
Thomas Gonder  @Reply  
      
14 months ago
The first "computer" that I could call my own, and afford, was a TI-58. No way to save your programs, that required a much more expensive card reader model. I got pretty good at programming a pseudo assembly on that, but got very tired of having to re-enter programs because of the missing reader.
Richard Rost OP  @Reply  
           
14 months ago
Thomas yeah my first computer had a cassette drive so even saving and loading small programs took forever.
Sami Shamma  @Reply  
             
14 months ago
Did any of you old-timers ever load a program that was on a punch tape? I am not talking about punch cards. I'm talking about a punch continuous tape.
Sami Shamma  @Reply  
             
14 months ago

Richard Rost OP  @Reply  
           
14 months ago
Nope. That was just before my time. I do remember seeing punch cards, but I never used them myself.
Sami Shamma  @Reply  
             
14 months ago
I worked on a Swiss photo typesetting camera that we programmed with these 8-hole Punch tapes.

lol

This reminds me of the scene from the original "Jaws" When they were sitting in the boat at night trying to one-up each other with their nasty experiences with sharks.
Sami Shamma  @Reply  
             
14 months ago

Thomas Gonder  @Reply  
      
14 months ago
Answer in other posts. I'm not the only one here to punch tape on a teletype.
Bryan Enbey  @Reply  
     
14 months ago
Happy Friday y'all,
Great stories, fellows!  🤣  Kinda telling on your ages, although I'm 48 myself.  I remember seeing punch cards when I was a young one, but never heard of punch tape.  That's actually more brilliant (if it can remain undamaged); no worrying about the cards being in order.  An old boss of mine told me horror stories out at NASA someone dropping a large box of cards back when and had to play 100s of cards pick-up and re-sort them and it wasn't fun LOL.

A 286 is far back as I go, but have seen some crazy stuff from old equipment still in service, etc.  I like to imagine this website running on some huge tape reels with lots of blinking lights like some late 60s sci-fi mad-scientist's warehouse.
Sami Shamma  @Reply  
             
14 months ago
Brian, since you started revealing ages, I can tell you I am 69 years old. And we had to use all kinds of tricks to make sure that putting the deck of cards back in order after we dropped it is a little bit easier. First, we tried to number all the cards, but that wasn't always sufficient because we would insert cards in different locations. Then we revert it using colored markers, and we will go and draw lines in different directions with different colors on the top of the deck. This way you can easily spot cards that are out of place.
Bryan Enbey  @Reply  
     
14 months ago
Good meeting you Sami.  Didn't think about edge-marking them, but that would help lots.  Colored markers are your friend and unlike those ScanTrons we had to use for some tests in schools, stray marks aren't going to get you in trouble.
Thomas Gonder  @Reply  
      
14 months ago
@Bryan My dad was an 8th grade math teacher. When ScanTron first came out (sometime in the 60s), he was estatic! In minutes he would grade a whole class and post the scores before the day ended.  Then he would pass me the worksheets that showed their work, with a red pencil. Ahhh, the life of a teacher back then.
Thomas Gonder  @Reply  
      
14 months ago
@Bryan Much later, at Microdata in the early 80s, we were tasked with making a "computer" that blinked lots of lights and would run the 1/2" tape back and forwards a lot. It was used on a TV series called Riptide. So, what you saw on TV was "enhanced", just like now when you see CCTV images zoomed in from 100 yards to read a license plate and people panning around in the air on holographic screens.
Thomas Gonder  @Reply  
      
14 months ago

Bryan Enbey  @Reply  
     
14 months ago
@Thomas, wow, ScanTron goes back to the 60's?!!  Here I thought it was some cutting edge 80's thing; that's pretty crazy.

Funny you mention the reading the license plate from afar thing; it makes me think about shows like CSI where they take some crap camera vid from the corner of a building and somehow able to read a plate or see a face perfectly a block down the road. LOL.  Love the image too BTW, but dang if I can remember what that is from!  Have a great weekend!
Thomas Gonder  @Reply  
      
14 months ago
@ Bryan
https://en.wikipedia.org/wiki/Riptide_(American_TV_series)#:~:text=The%20men%20have%20several%20other,aerial%20harbor%20tours;%20and%20Cody's

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Captain's Log.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/22/2026 2:28:20 PM. PLT: 1s