Computer Learning Zone

A Common Beginner Design Mistake with Microsoft Access Tables (And the Easy Fix) QQ#77


Listen Later

Today we discuss some of the most common Microsoft Access questions from viewers, focusing on why tracking monthly payments with one field per month is a classic database mistake and how adding a second related table can solve reporting headaches. We also talk about working with tabbed documents vs. overlapping windows, Power Query merge performance in Excel vs. Access joins, locking fields in edit mode, hiding tables with VBA, the continued relevance of Access in 2026, combo box list caching, report footer formatting issues, and more.

Learn more at 599cd.com/QQ77

...more
View all episodesView all episodes
Download on the App Store

Computer Learning ZoneBy Richard Rost