Video Rewind
By Richard Rost
4 years ago
Video Rewind for December 11, 2022
It's time for another Video Rewind, which is a quick recap of all the videos I released this past week or so. If you are interested in any of the topics listed, just click on the links below.
Links
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, we'll recap several recent tutorials covering a range of topics in Microsoft Access and Excel, including how to select the top X records in a query, use date-changing buttons, move windows with keyboard shortcuts, and speed up form loading with a timer event. We also look at preventing accidental edits by using an edit mode, calculating pro-rated rent and leap years, finding the number of string occurrences within another string, and using expressions with conditional formatting. Additionally, we'll see how to perform a double lookup in both Microsoft Excel and Microsoft Access, and learn about the new Save Position template for Access.Transcript This is Richard Rost with Computer Learning Zone. It is time for another video rewind, which is a quick recap of my recently released videos. To watch any of the videos mentioned, just visit my website.
We learn how to select the top X records, top 10 records, and top 20 records in a Microsoft Access Query with numbered rows. We learn how to change the date using little buttons in Microsoft Access so we can click on them to go up or down a day or a week or whatever.
I showed you how to move windows around on your screen with keyboard shortcuts. This is great if you have a multi-monitor setup and you move a window where you cannot get to it with the mouse. I taught you a little trick to make your forms seem to load faster to the user by using a timer event.
I released a new template that will allow your Access databases to open exactly where you want them on your screens. If you have two or three different databases that you work with, you can have one that opens up over here, another one that opens up over there, and when they open up next time, they will remember where they were. This is my save position template.
We learn how to prevent accidental edits and deletions by requiring users to go into edit mode. So if the user wants to change the data on the current record, they have to click a little button that says edit, and then they can click a little button that says save or cancel to cancel those edits or save them. Lots of new users do not understand that when they type in stuff in Access, it is editing that record. You do not have to save it like you do with Word or Excel.
I showed you how to pro-rate stuff. We calculate pro-rated rent in Microsoft Access, so if someone is moving out on the 10th of the month, how much rent do they owe you for those 10 days?
We learn how to calculate leap years, determining if a particular year is a leap year using the isdate function. We learned how many times a string occurs inside another string.
I finally finished Microsoft Access Developer Level 41, which includes form zooming in and out. A lot of people ask about that when anchoring and the form on error event.
We learn how to use an expression in conditional formatting. This allows you to use functions and do all kinds of things, like see if a string occurs inside the field.
We learn how to do a double lookup in Excel. That is when you are looking up a value based on multiple criteria, not just a single cell. Then I showed you how to do the same thing in Microsoft Access, a double lookup using a DLookup with multiple criteria and an or.
That is it for my videos. Do not forget to check Mike Wolf's Weekend Review.
If you found this video helpful, be sure to like, follow, subscribe, thumbs up, and all that good stuff. If you want to learn more about anything I mentioned today, visit my website at computerlearningzone.com.
Of course, if you want to learn more about Microsoft Access, be sure to sign up for my free 4-hour Access course at accesslearningzone.com.
Thanks for watching. See you next time.Quiz Q1. What method was covered for selecting a specific number of records in a Microsoft Access Query?
A. Sorting records alphabetically
B. Selecting the top X records with numbered rows
C. Filtering by date only
D. Calculating percentages of records
Q2. What feature in Microsoft Access allows users to increment or decrement the date easily?
A. Drop-down calendar only
B. Little buttons for changing the date by day or week
C. Manual typing of the date
D. Automatic date updates from the system clock
Q3. Which technique was shown for moving windows on your screen without a mouse?
A. Using a stylus
B. Keyboard shortcuts
C. Right-click menu only
D. Task Manager
Q4. What does the "save position template" for Access databases help with?
A. Saving data layout
B. Opening forms in design view
C. Opening databases in the desired position on the screen
D. Backing up databases to the cloud
Q5. How does Richard suggest preventing accidental edits and deletions in Access?
A. By limiting user permissions in Windows
B. By forcing users to enter edit mode with a button before making changes
C. By using encrypted data fields
D. By hiding data in the database
Q6. What calculation example was given regarding proration in Access?
A. Dividing invoices by quantity
B. Calculating pro-rated rent if someone leaves mid-month
C. Computing product discounts
D. Estimating overtime pay
Q7. How did Richard demonstrate calculating whether a year is a leap year?
A. By checking if divisible by 5
B. By using the isdate function
C. By subtracting months
D. By comparing string lengths
Q8. What feature was discussed for counting the number of times one string appears in another?
A. Conditional formatting only
B. A string occurrence function
C. Page Breaks
D. Data validation rules
Q9. What was a new feature covered in Microsoft Access Developer Level 41?
A. Printing reports only
B. Form zooming in and out
C. Creating tables
D. Importing XML data
Q10. What does using an expression in conditional formatting allow?
A. Changing background color using fixed colors only
B. Using functions and logic for advanced formatting
C. Printing only filtered data
D. Preventing form loading
Q11. In Excel, what is a double lookup?
A. Looking up two values at the same time in one column
B. Looking up a value with multiple criteria
C. Finding the largest number in a range
D. Using pivot tables for data analysis
Q12. How was a double lookup accomplished in Microsoft Access?
A. By using a filter by form
B. By using DLookup with multiple criteria and an OR clause
C. By creating a subform
D. By linking to an external database
Answers: 1-B; 2-B; 3-B; 4-C; 5-B; 6-B; 7-B; 8-B; 9-B; 10-B; 11-B; 12-B
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 another Video Rewind, where I offer a brief recap of the latest tutorials and content I have recently released. If you want to explore any of the topics I mention here in more detail, you can find them all on my website.
One of the recent lessons covers how to display the top X records in a Microsoft Access query, such as the top 10 or top 20, and how to use numbered rows to organize your results. I also explain how to navigate dates efficiently in Microsoft Access by using small buttons that allow you to increment the date by a day, a week, or another interval.
There is a handy tip on moving windows around your screen using keyboard shortcuts. This is particularly useful if you work with multiple monitors and a window ends up somewhere that is not easily accessible with your mouse. I also share a useful trick to help your forms appear to load faster by making use of the timer event, giving a smoother experience to your users.
I released a new Microsoft Access template designed to set the startup position of your database windows. If you use more than one database, this template lets you set a specific position on your screens for each one, and the databases will remember where you left them for the next time they open. I call this the Save Position Template.
Another practical topic is about preventing accidental edits or deletions in your Access forms. To help keep your data safe, I show you how to require users to enter an edit mode before making any changes. Users must click an Edit button before modifying a record, and after editing, they have the option to save or cancel their changes. Many new users do not realize that editing data in Access happens immediately, without the explicit need to save like in Word or Excel.
I explain how to calculate prorated values, like figuring out prorated rent in Microsoft Access. For instance, if a tenant moves out on the 10th of the month, you can compute exactly how much rent is due for those 10 days.
Additional topics include checking whether a year is a leap year with the IsDate function, and counting how many times a specific string appears inside another string.
I also completed Microsoft Access Developer Level 41, which introduces features like zooming forms in and out, something many people ask about. It also covers anchoring and handling form error events.
Another instructional video demonstrates how to use expressions within conditional formatting in Access. With this, you can use functions in your formatting rules, such as checking if a field contains a particular string or value.
Switching to Excel, I discuss double lookup operations, which enable you to find a value based on more than one criterion. I also walk through performing a similar double lookup in Access using DLookup with multiple criteria, including the use of the OR condition.
That sums up the latest batch of videos. For more in-depth guidance, you can find complete video tutorials with step-by-step instructions on my website at the link below.
Live long and prosper, my friends.Topic List Selecting top X records in an Access query
Adding numbered rows to Access queries
Changing dates with buttons in Access forms
Moving windows with keyboard shortcuts
Improving form load speed with timer events
Saving and restoring Access window positions
Preventing accidental edits with edit mode
Pro-rating rent calculations in Access
Determining leap years with the isdate function
Counting substrings within a string
Implementing form zoom in and out in Access
Using the form on error event in Access
Applying expressions in conditional formatting
Performing double lookup in Excel with multiple criteria
Performing double lookup in Access using DLookup with OR criteria |
