Add User Editable Supplemental Fields to Access

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?

Members

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.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Suggested Course

• Access Expert 7: https://599cd.com/ACX7

Links

• Blank Template: https://599cd.com/Blank
• Relationships: https://599cd.com/Relationships
• RelationalCombo: https://599cd.com/Relational
• Many to Many: https://599cd.com/M2M
• List Items Edit Form: https://599cd.com/ListItemsEditForm
• Helper Data: https://599cd.com/HelperData

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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