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

In this video, 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. This is part 77.

Yonatan from (a Developer Student) Is it possible in Microsoft Access to use overlapping windows by default but have some forms open as tabbed documents at the same time?

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
Quick Queries #77: https://599cd.com/QQ77

PREREQUISITES:
Quick Queries Listing: https://599cd.com/QuickQueries
Quick Queries #76: https://599cd.com/QQ76

LINKS:
SourceObject: https://599cd.com/SourceObject
Random Quotations: https://599cd.com/a?119045
Relationships: https://599cd.com/Relationships
Access Memory Lane: https://isladogs.co.uk/memory-lane/index.html
Are You Sure?: https://599cd.com/AreYouSure
Command Buttons: https://599cd.com/CommandButtons
Value From a Form: https://599cd.com/FormName
Alive & Well In 2026: https://599cd.com/Alive
Can Grow, Shrink: https://599cd.com/CanGrow
Access Day 2026: https://www.jstreettech.com/access-day/

UP NEXT:
Quick Queries #78: https://599cd.com/QQ78
Captain's Log: https://599cd.com/Log
Merch Store: https://599cd.com/Merch
Access Day: https://www.jstreettech.com/access-day/

RECOMMENDED COURSES:
Access Beginner 1: https://599cd.com/ACB1
Access Developer Courses: https://599cd.com/Developer

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

DIAMOND SPONSORS:
More info on our Sponsors: https://599cd.com/DiamondSponsors

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Merch Store! Get your swag here: https://599cd.com/Merch
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, beginner table design mistake, related payments table, tabbed documents vs overlapping windows, navigation form tab control, end of day deposit report, Excel Power Query merge performance, lock fields in edit mode, hide tables VBA, Access in 2026, combo box list caching

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

Видео A Common Beginner Design Mistake with Microsoft Access Tables And the Easy Fix QQ#77 канала Computer Learning Zone