Access TechHelp

This is a listing of all available Microsoft Access TechHelp videos. Looking for something specific? Search for it. If you've got a question, post it below, or visit the Ask a Question page.

Also, don't forget to check out my special Quick Queries videos. Enjoy!

Date		Title	Summary
2023-12-13		Next Leap Year	How to Calculate the Next Leap Year Following a Given Year in Microsoft Access VBA
2024-01-03		Next Payment Date	Calculate Next Credit Card Payment or Reporting Dates in Microsoft Access
2022-08-05		No Data	On No Data Event. Displaying a Message if a Report Has No Records in Microsoft Access.
2023-04-21		No Orders 30 Days	Create a List Showing All Customers Who Have Not Placed an Order in 30 Days in Microsoft Access
2022-02-11		Normalizing Data	Normalizing Data in Microsoft Access Databases. What Normalization Means. How To Fix Bad Tables.
2021-02-20		Not Updateable	Why Does My Form or Query Say This Recordset is not updateable in Microsoft Access?
2022-04-27		Notes Anywhere!	Put Notes in a Long Text Memo Field on Any Form in your Microsoft Access Database
2022-04-14		Null	What is Null in Microsoft Access? How to use Is Null, Is Not Null, IsNull, and Not IsNull. Query Criteria and VBA.
2022-02-01		Null Math	How to Use Null Math Along With String Concatenation
2022-05-12		Number Field Size	Microsoft Access Number Field Sizes. What To Do If Your Number Values Keep Rounding Off.
2024-08-27		Number Pairs	How to Break Years Up Into Two-Digit Number Pairs for Speech Synthesis in Microsoft Access
2024-08-28		Number Pairs 2	How to Break Years Up Into Two-Digit Number Pairs for Speech Synthesis in Microsoft Access, Part 2
2025-03-11		Numbered Form Items	How to Automatically Number List Items in a Form in Microsoft Access
2024-02-21		Numbered Images	How to Display Numbered Images in a Database Based on a Field Value in Microsoft Access
2025-03-10		Numbered Report Items	How to Automatically Number List Items in a Report in Microsoft Access
2022-11-16		Numbers As Text	When to Store Numbers in a Text Field in Microsoft Access. Val Function.
2020-08-14		NZ Function	How To Use the NZ Function to Convert Null Values to Zero or Default Values in Microsoft Access
2024-05-10		Object Dependencies	Using Object Dependencies in Microsoft Access to Safely Delete Queries
2020-08-09		Odd or Even	How To Determine If a Number Is Odd or Even Using the Mod Operator and IIF Function in Microsoft Access
2023-08-24		On Activate	Use the On Activate Event to Highlight Active Form in Microsoft Access

More...