Build a Flexible Inventory Management System with One-to-Many Relationships in Microsoft Access @599CD
Build a Flexible Inventory Management System with One-to-Many Relationships in Microsoft Access  @599CD
Uploaded November 2026 | Updated November 2026, 3 days ago
In this lesson, we will begin organizing inventory in Microsoft Access by designing a flexible four-level location hierarchy: locations, areas, subdivisions, and items. We will walk through creating the related tables, assigning primary and foreign keys, entering sample records, and using one-to-many relationships to track where items are stored without repeating location information for every item.

Michael from Nottingham, England (a Silver Member) asks How can I organize the tables and relationships to track exactly where each item is stored without creating separate tables for every type of storage furniture?

CHAPTERS:
00:00 Introduction
01:03 Designing a Flexible Inventory Hierarchy
02:23 The Four-Level Location Structure
04:57 Applying the Structure to Different Storage Types
07:54 Planning Tables and Relationships
09:22 Prerequisites
10:43 Creating the Location Table
12:19 Creating the Area Table
15:22 Creating the Subdivision Table
17:52 Creating the Item Table
21:29 Using Sample Data for Testing
23:19 Recommended Courses
25:00 Conclusion

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

LEARN MORE:
Organizing Inventory: 599cd.com/OrganizingInventory

PREREQUISITES:
Access Beginner 1: 599cd.com/ACB1
Relationships: 599cd.com/Relationships
Relational Combo Boxes: 599cd.com/RelationalCombo

LINKS:
Referential Integrity: 599cd.com/Referential
Outer Joins: 599cd.com/1455
Cascade Delete: 599cd.com/2809
Cascading Combo Boxes Without VBA: 599cd.com/5695
Cascading Combo Boxes with VBA: 599cd.com/1749
Multiple Cascading Combo Boxes: 599cd.com/3545

UP NEXT:
Organizing Inventory, Part 2: 599cd.com/OrganizingInventory2

RECOMMENDED COURSES:
Access Asset Seminar: 599cd.com/Asset
Access Barcode Seminar: 599cd.com/BarcodeSeminar

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

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

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
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, inventory location database, item location tracking, inventory database design, hierarchical storage locations, location area subdivision item, inventory table relationships, one-to-many relationships, asset location tracking, storage location management, relational combo boxes

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Build a Flexible Inventory Management System with One-to-Many Relationships in Microsoft AccessReuse Access Forms Across Multiple AppsThe Access Regex Version GotchaWill Microsoft Access Ever Run On Android?Theres no magic setting to force Access to always start databases in new processes.Why Your New Combo Box Item Is MissingMicrosoft Access Account Balances Template - Release Update 3Regex Cannot Tell You If A ZIP Code ExistsWhat Happens Assigning DLookup Null to a Long Variable in Microsoft Access? Video Quiz D3.1Validate A Five-Digit ZIP Code With RegexPatrick Stewart: The Captain Who Helped Raise MeDont Make This Access Field Unique
Computer Learning Zone |

Build a Flexible Inventory Management System with One-to-Many Relationships in Microsoft Access

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER