Add Anything You Want to a Record in a Microsoft Access Database. User Editable Supplemental Fields

In this Microsoft Access tutorial, I will show you how to add a set of supplemental data fields to your database. This will allow you to enter any kind of additional information that you want to any table, and your users can specify new fields if they want to.

Wayne from Bismark, North Dakota (a Platinum Member) asks: One thing I love about my Android cell phone is that if I want to add more phone numbers, I can. Want to add a few extra email addresses? No problem. Want to add a birthday and anniversary? You got it. Any way to do this with Access?

Silver Members and up get access to an Extended Cut of this video. Members will see how to specify data types for the supplemental fields. We'll add numeric and date fields and check to make sure the user entered the correct type of data.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

RECOMMENDED COURSE:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, add any data field, add new data types, add random fields, user defined fields, supplemental data, User-Defined Types, How do I add a user-defined field, Create User-Defined Fields, Supplemental Data Tables, android contacts, extra data, extra fields

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[MrBobloblaws]

Good choice for Rush as a favorite band :) Great tips, thanks!

[ilyasawan]

I wanted to make a table and form on medical expenses and with the help of your video I made a table and form on medical expenses.
One field has medical types and the other field has medical expenses. How to sum medical expenses in the table?
If 6 medical types are used any one patient, how will it be sum in the table with the medical expenses?
How would a few things about this sum the total expenses of a patient in the table?
Your videos help me a lot.
Thanks

[oppositeistrue]

Hi Richard, thanks for your free videos, your paid videos are well worth the few dollars for great full-on seminars, you mention as a rule if you have more than three of anything make a table for it/them, would you still do that or use this instead?
I can see myself using this method everywhere.

[laurentmeus]

Hello thank you for sharing Richard
It's very useful, there are always thousands of things to add, that we hadn't thought of.
Personally for very simple lists like these, I do not use the "tool" ListeItemEditForm, but an external function.
The user enters the text in the list directly and the input is added after a confirmation request.
This avoids manipulation(opening the form, entering, closing the form), and above all this #@@#& icon that remains display ;o)

[raulgonzalez]

"Any Anything" title and thumbnail