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 files from class plus get access to the Code Vault. 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 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors 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