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.
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.










