Consolidating Multiple Small Tables in Microsoft Access into One Table using a Helper Data Table
Do you have a million tiny tables in your database? Name prefix, suffix, title, lead source, marital status, gender, the list goes on. You want to store this information in a table (properly so) because you want to be able to easily edit the list and use that same list anywhere in your database. However, all those tons of little tables in your Navigation Pane are annoying and clutter your database. In this video, I'll show you how to consolidate all of those tiny tables into one Helper Data table to keep things nice and tidy.
Sara from Osaka, Japan (a Gold Member) asks: Help! I've got way too many tables and linked tables in my database. Most of them are small with only a few records in them, but I need them. I've got tables for: name prefix, suffix, contact type, lead source type, employment status, gender, marital status, the list goes on. Is there any way to consolidate this into ONE table?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to create a popup form where you can quickly edit the items in the combo box that you're working with, and also how to include the supporting helper data in queries and reports.
MEMBERS ONLY VIDEO:
https://youtu.be/UPmn4Vx-Xx4
BECOME A MEMBER:
https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
UPDATE:
I cover the feature where the HelperF passes the new value back to the combo box that called it in my ABCD Part 2 database lessons: https://599cd.com/1387
LINKS:
Get on my Mailing List: https://599cd.com/YTML
Relationships: https://599cd.com/relationships
Combo Boxes: https://599cd.com/combo
ABCD Database: https://599cd.com/ABCD
SQL: https://599cd.com/sql
ADDITIONAL RESOURCES:
FREE Access Level 1: https://599cd.com/Free1
FREE Customer Template Database: https://599cd.com/XCDT
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Survey: https://599cd.com/survey
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
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/
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, consolidate multiple tables, merge many tables, supporting data tables
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Видео Consolidating Multiple Small Tables in Microsoft Access into One Table using a Helper Data Table канала Computer Learning Zone
Sara from Osaka, Japan (a Gold Member) asks: Help! I've got way too many tables and linked tables in my database. Most of them are small with only a few records in them, but I need them. I've got tables for: name prefix, suffix, contact type, lead source type, employment status, gender, marital status, the list goes on. Is there any way to consolidate this into ONE table?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to create a popup form where you can quickly edit the items in the combo box that you're working with, and also how to include the supporting helper data in queries and reports.
MEMBERS ONLY VIDEO:
https://youtu.be/UPmn4Vx-Xx4
BECOME A MEMBER:
https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
UPDATE:
I cover the feature where the HelperF passes the new value back to the combo box that called it in my ABCD Part 2 database lessons: https://599cd.com/1387
LINKS:
Get on my Mailing List: https://599cd.com/YTML
Relationships: https://599cd.com/relationships
Combo Boxes: https://599cd.com/combo
ABCD Database: https://599cd.com/ABCD
SQL: https://599cd.com/sql
ADDITIONAL RESOURCES:
FREE Access Level 1: https://599cd.com/Free1
FREE Customer Template Database: https://599cd.com/XCDT
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Survey: https://599cd.com/survey
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
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/
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, consolidate multiple tables, merge many tables, supporting data tables
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Видео Consolidating Multiple Small Tables in Microsoft Access into One Table using a Helper Data Table канала Computer Learning Zone
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Microsoft Access 2016 Tutorial: A Comprehensive Guide to Access - Part 1 of 2](https://i.ytimg.com/vi/1IA4SeajZRw/default.jpg)
![Overlay Microsoft Access Data on a Map or Image in a Form or Report. Real Estate, Restaurant, Gaming](https://i.ytimg.com/vi/PTlCDzxo1KM/default.jpg)
![Import New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel Spreadsheet](https://i.ytimg.com/vi/RZk6eTJjhGY/default.jpg)
![Build a Context-Sensitive Help System For Your Microsoft Access Databases](https://i.ytimg.com/vi/Lszr-mAgD84/default.jpg)
![Microsoft Access Combo Boxes - Value List and Search Combo Boxes - Find Records](https://i.ytimg.com/vi/Myk3A90Ggzw/default.jpg)
![Microsoft Access Create Your Own Custom Sequential Automatically Incrementing Number with DMAX](https://i.ytimg.com/vi/ZOg4P6v5ewA/default.jpg)
![Convert Query SQL to VBA Code in Microsoft Access. Add Line Breaks, Quotes, vbNewLine, and More.](https://i.ytimg.com/vi/vt7hh3UJ34A/default.jpg)
![An Access Subform Based on a Many-to-many Relationship](https://i.ytimg.com/vi/Ou1zwJunbuA/default.jpg)
![How To Import An Excel Spreadsheet With VBA In Access 2013 🎓](https://i.ytimg.com/vi/WO7Js1Mh13c/default.jpg)
![How to Properly Calculate Age from Date of Birth in Microsoft Access and Excel. Don't Use DateDiff!](https://i.ytimg.com/vi/D7f9x1QXcfQ/default.jpg)
![Don't Delete! Marking Records Inactive. When and When NOT to Hard Delete Data in Microsoft Access](https://i.ytimg.com/vi/efgoZwAg5vQ/default.jpg)
![Power BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰](https://i.ytimg.com/vi/AGrl-H87pRU/default.jpg)
![Access Advanced Tutorial](https://i.ytimg.com/vi/Oq6vMEzTzX4/default.jpg)
![Display LastName, FirstName Together in your Combo Boxes in Microsoft Access (Full Name) Concatenate](https://i.ytimg.com/vi/hKe2Zgq7vLA/default.jpg)
![](https://i.ytimg.com/vi/MHQAPGpHdYg/default.jpg)
![Microsoft Access Times as a Duration HH:NN possibly exceeding 24 hours](https://i.ytimg.com/vi/j-euIR3weng/default.jpg)
![Continuous Forms in Microsoft Access. Product Inventory List Form. Click to Open Specific Product.](https://i.ytimg.com/vi/EJWNnSw0FhA/default.jpg)
![Microsoft Access Customer Database (CRM) MS Access Customer Template - Free Download](https://i.ytimg.com/vi/wWUW3WTMhBM/default.jpg)
![Microsoft Access v Microsoft Excel: Which is Better? When to Use Each. Data Management or Analysis?](https://i.ytimg.com/vi/b67mMjmWhJw/default.jpg)
![Automatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.](https://i.ytimg.com/vi/2yj6x5E4Z_0/default.jpg)