Video Rewind
By Richard Rost
4 years ago
Video Rewind for November 19, 2022
It's time for another Video Rewind, which is a quick recap of all the videos I released this past week. If you are interested in any of the topics listed, just click on the links below.
Links
Previous Rewinds
See Also
 Keywords
#shorts, #windows, #mswindows, microsoft windows, 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 In this video, I give a recap of the Microsoft Access and Windows tutorials released in the past week, including how to archive records to a backup table, use the InStr function, store numeric values as text when appropriate, and merge tables from different databases. I also talk about switching between open applications with AppActivate, introduce the new Access Watchdog template, and discuss setting up automatic logon in Windows.Transcript This is Richard Rost with Computer Learning Zone.
It is time for another Video Rewind, which is a quick recap of all the videos I released this past week ending November 19, 2022.
We learned how to archive old records in our Microsoft Access databases to a backup table using an Append query and a Delete query.
We learned how to use the InStr function to find a string within a string and where in that string it appears.
We learned when you should store numeric values as text even though they are numeric values - things like phone number, zip code, text or number. What do you think?
We learned how to merge tables from two databases together. Got two companies coming together? Well, you can merge all their customers.
I will show you how to switch between different open applications using AppActivate.
I released a new template this week called Access Watchdog. It will watch your database and if it locks up, it will restart Access or even reboot the computer.
Last week, we had a Windows video to teach you how to set up your computer to automatically log on when it boots.
Be sure to like, follow, subscribe, thumbs up, all that good stuff. If you want to learn more about anything I mentioned today, just visit my website at computerlearningzone.com.Quiz Q1. What method was taught for archiving old records in Microsoft Access databases?
A. Exporting records as CSV files
B. Backing up the entire database manually
C. Using an Append query and a Delete query
D. Copying and pasting records into Excel
Q2. What is the purpose of the InStr function in Microsoft Access?
A. To sort records in ascending order
B. To find out if a number is odd or even
C. To find a string within another string and where it appears
D. To backup records to a different table
Q3. When is it suggested to store numeric values as text in a database?
A. When values will be used in arithmetic operations
B. Always store them as numbers
C. For things like phone numbers and zip codes that are numeric but do not require calculations
D. Never, all numeric values should be stored as numbers
Q4. What was discussed as a solution for merging customer tables from two companies?
A. Printing both tables side by side
B. Using a split database
C. Merging the tables from two databases together
D. Using Excel as an intermediary
Q5. What does the AppActivate feature allow you to do?
A. Turn your computer off remotely
B. Switch between different open applications
C. Backup your database automatically
D. Restore deleted records
Q6. What is the name of the new template released that watches and restarts Access or the computer if it locks up?
A. Access Monitor
B. Access Guardian
C. Access Watchdog
D. Access Repair Tool
Q7. What was the Windows video from the previous week about?
A. Creating user accounts
B. Setting a new desktop wallpaper
C. Automatically logging on when the computer boots
D. Troubleshooting hardware issues
Answers: 1-C; 2-C; 3-C; 4-C; 5-B; 6-C; 7-C
DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.Summary Today's video from Computer Learning Zone is a Video Rewind where I recap all of the tutorials and content I released over the past week ending November 19, 2022.
Over the last week, I covered how to archive old records in a Microsoft Access database. I explained how you can use both an Append query to copy those old records to a backup table and a Delete query to remove them from the current table, ensuring your database stays organized and efficient.
I also demonstrated the use of the InStr function in Access. This handy function lets you search for a specific string within another string and tells you its position, making it much easier to locate information within text fields.
Another important topic I discussed was when it is appropriate to store numbers as text, even if they are technically numerical values. For example, fields like phone numbers and zip codes are best kept as text to avoid unexpected formatting or calculation issues.
Merging tables from two separate databases was another lesson from this past week. I went over how to combine customer tables if, for example, two companies merge and you need all their customer data in one place.
I talked about how to switch between different open applications using the AppActivate command in Access VBA, which can be very helpful if you often work with multiple programs at once.
This week, I also introduced a new template called Access Watchdog. This tool monitors your database and, if it detects a lockup, can automatically restart Access or even reboot your computer to minimize downtime.
I also released a Windows video last week where I shared how to set up your computer for automatic logon whenever it boots up, which can streamline your workflow if you need quick access to your PC.
If you want to explore these tutorials in more detail, or if you are interested in any of these topics, just visit my website at the link below. You will find complete video tutorials with step-by-step instructions on everything covered here.
Live long and prosper, my friends.Topic List Archiving old records to a backup table in Access
Using Append queries for archiving data in Access
Using Delete queries to remove archived records
Using InStr function to locate a substring within a string
Determining when to store numeric values as text
Merging tables from two different Access databases
Using AppActivate to switch between open applications
Introduction to Access Watchdog template for database monitoring |
