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!

New: Enhanced Directory showing all regular or Extended Cut videos

Date		Title	Summary
2020-09-06		Optimizing Short Text Field Sizes	How To Optimize Short Text Field Sizes and Understand Field Length Importance in Microsoft Access
2020-09-02		Query Criteria	How To Use Criteria In Queries To Filter Records By State Or Date In Microsoft Access
2020-08-31		List Box with Format and Color?	How To Add Formatting and Color to List Boxes and Create Color-Coded Lists in Microsoft Access
2020-08-31		Tab Stop, Order, Cycle	Microsoft Access Tab Stop, Tab Order, Cycle Records on a Form
2020-08-29		Map Location	How To Open Google Maps to Any Location Stored in Your Microsoft Access Database with One Click
2020-08-22		Self Join Relationships	Build a Genealogy Database to Track Family Ancestry. Self-Join Relationships.
2020-08-18		ByRef v ByVal	ByRef v ByVal in VBA. Creating an Increment Operator.
2020-08-17		Count Characters	How To Count Specific Characters and Lines in a String With a For Next Loop in Microsoft Access VBA
2020-08-14		NZ Function	How To Use the NZ Function to Convert Null Values to Zero or Default Values in Microsoft Access
2020-08-14		AfterUpdate & DLookup	AfterUpdate Event & DLookup - Look up Values from Table to a Form
2020-08-13		Turn Off Warnings	How To Turn Off Action Query Warning Messages for Update, Delete, Append Queries in Microsoft Access
2020-08-11		Maximize Application Window	How To Maximize or Restore the Application Window Automatically on Startup in Microsoft Access
2020-08-10		Subform in a Continuous Form	How To Display a Subform Inside a Continuous Form and Sync Record Lists in Microsoft Access
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
2020-08-09		AutoNumbers Good or Bad?	How To Choose Between AutoNumbers and Natural Keys for Primary Keys in Microsoft Access Tables
2020-08-06		Sync Remote Database	How To Sync Two Separate Databases Without Internet Access and Avoid Key Collisions in Microsoft Access
2020-08-06		Customer Codes	Create Customer Codes that Don't Reveal Your Microsoft Access Database Size
2020-08-05		Sequential Numbers	How To Create Custom Sequential Order Numbers Without Gaps for Reporting Purposes in Microsoft Access
2020-08-04		Restore Deleted AutoNumber	How To Restore Deleted AutoNumber IDs and Recover Lost Records Safely in Microsoft Access Databases
2020-08-01		Custom Sort Order	How To Use a Custom Sort Order for Forms and Reports to Display Records in Microsoft Access

More...