Video Rewind
By Richard Rost
4 years ago
Video Rewind for November 12, 2022
Welcome to my first ever Video Rewind. I've decided that my teaching style and the tutorials that I make don't really work well as short-form videos. I need at least 10 minutes to cover most topics enough, and the vertical "phone" format doesn't really work well for my tutorials either. I don't want to miss out on the short video craze, So... I figured I'd put together a weekly(ish) Video Rewind where I briefly review the videos I've released in the past week and if you're interested in watching any of them, just click on the links below.
Links
 Keywords
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #videorewind
Subscribe to Video Rewind
Get notifications when this page is updated
Intro This page features the first Video Rewind, where I recap the past week's Microsoft Access tutorials. Topics this week include dealing with the new security risk warning in Access databases, setting up and using random auto numbers, understanding the difference between null values and zero length strings, counting words in long text fields, creating a custom navigation bar that displays your current record position, and extracting the time portion from a date/time value. If you missed any recent videos, you can find summaries and links to the full tutorials here.Transcript Hey there, this is Richard Rost with Access Learning Zone. Welcome to my first ever video rewind.
I've decided that my teaching style and the tutorials that I make don't really work well as short form videos. It's kind of hard to cover anything Microsoft Access related. I need at least 10 minutes to cover most topics well enough. Plus, the vertical phone format doesn't really work well for my tutorials either.
I also don't want to post regular videos and have to make you rotate your phone. That's kind of dumb too.
Now, I don't want to miss out on the short video craze. So I decided I'd put together a weekly-ish sort of video rewind where I briefly cover all the videos I've released in the past week or so.
If you're interested in watching any of these, just head over to my website and you can watch the full videos there.
So, what did we do this week? We talked about the new security risk warning that pops up in Access databases now if you download something off the web or it is sent to you in email. In this video, I show you how to deal with that.
I personally love random auto numbers and they have a lot of uses. In this video, I teach you how to set up random auto numbers and what they're good for.
Lots of people always ask me this one: what's the difference between a null value and a zero length string and how can we tell the difference? This is a great video.
A lot of applications like Microsoft Word can show you a word count. What if you want to do that in your Access database if you've got a long text field or a memo and you want to count the number of words in it? I'll show you how to do that in this video.
Here's a developer level tip video. If you want to mimic that navigation bar on the bottom of the screen, this guy right here where it says four of 29, I'll teach you how to do that in this video. We'll make it say one of six or however many records you have, and as you move through the records, we'll use the record count and absolute position properties to display that value.
A couple of weeks ago I showed you how to get just the date part of a date/time value. In this video, I'll show you how to pull the time part out so you can get just 5 p.m. or whatever with time value.
So that's it for this week. Be sure to like this video and follow me if you want to learn more about Microsoft Access, and don't forget to visit my website and sign up for my free four hour Access course.
AccessLearningZone.comQuiz No quiz available.Summary Today's video from Access Learning Zone introduces something new called the "video rewind." I've realized that my usual teaching style and most Microsoft Access topics really need more time than short form videos allow. It is difficult to cover Access concepts in just a few minutes, and the vertical video format doesn't fit well with tutorials that require more screen space. At the same time, I do not want to produce standard videos for shorts because having viewers rotate their phones is not practical either.
Instead, I decided to create a weekly or so video rewind. In these segments, I briefly recap all the videos I released over the past week. If any of the topics interest you, you can always visit my website to watch the full, in-depth tutorials.
Here is what I covered this week. First, I addressed a new security risk warning that can appear when you open an Access database downloaded from the internet or received as an email attachment. In that video, I explained how to handle that security message and make sure your Access files are safe to use.
Another tutorial focused on random auto numbers, which are one of my favorite features. I demonstrated how to set up random auto numbers in your tables and covered some of their most effective uses.
One of the common questions I get is about the difference between a null value and a zero length string in Access. In this lesson, I explained what sets them apart and how you can tell which is which.
For anyone who works with long text fields or memos, I showed how you can add a word count feature to your database. This is similar to the word count tool in Microsoft Word and lets you see how many words are in a particular field.
I also shared a developer-level tip for those who want to replicate the navigation bar that displays your current record number, like "4 of 29." In this video, I walk you through how to create your own, so you can display information such as "1 of 6." The tutorial uses the record count and absolute position properties to make that happen as users move through records.
A couple of weeks ago, I explained how to extract just the date part from a date/time value. This time, I followed up with a video showing how to get just the time part, like extracting 5 p.m. from a full date/time field.
That wraps up this week's rewind. If you would like to learn more about Microsoft Access and watch the complete video tutorials for these topics, you can find them all on my website, listed at the link below. I also encourage you to sign up for my free four-hour Access course.
Live long and prosper, my friends.Topic List Dealing with the Access security risk warning
Setting up random auto numbers in Access
Understanding null values vs zero length strings
Counting words in a memo or long text field
Creating a custom navigation bar display (record count and position)
Extracting the time part from a date time value |
