In this Microsoft Access tutorial, I will teach you about multivalued fields: what they are, how to use them, and when you should avoid them.
Craig from Brattleboro, New Hampshire (a Platinum Member) asks: I inherited a database from my predecessor. In it, she used multivalued fields to track the sales reps assigned to a customer, as there can be several. I've watched many of your videos where you say not to use them, but in all honesty, they seem to work just fine. What's the deal?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to programmatically access the elements of a multivalued field using a recordset loop. I will also show you how to add selections.
MEMBERS VIDEO:
• Microsoft Access Multi...
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/MVF
LINKS:
Evil Access List: 599cd.com/Evil
Many to Many: 599cd.com/ManyToMany
Custom List Box: 599cd.com/CustomListBox
Relational Combo: 599cd.com/Relational
SUGGESTED COURSES:
Many to Many: 599cd.com/ACX7
Multi-Select List Box: 599cd.com/ACD15
Referential Integrity: 599cd.com/ACX2
MULTIVALUED FIELD REFERENCES:
access.mvps.org/access/lookupf...
www.isladogs.co.uk/multivalue...
tinyurl.com/yyxvx7h6
www.accessmvp.com/thedbguy/dem...
OTHER COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
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
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, multivalued field, mvf, lookup field, allow multiple values, lookup wizard, many to many relationship, junction table, got geddy
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет Microsoft Access Multivalued Fields: What They Are, How to Use Them, and When You Should Avoid Them
Пікірлер: 31