Microsoft Access Update Query: Values from Another Table to Normalize a Field. Plus add World Flags!
37.6 هزار بار بازدید -
3 سال پیش
-
In this video, I'll show
In this video, I'll show you how to properly normalize the country field in your customer database retroactively by creating a country table, and then saving your existing data with update queries. Then, as a BONUS, I'll show you how to display that country's flag on the customer form.
Louis from Arlington, Virginia (a Gold Member) asks: I've got my state and country fields as text like you show in your videos, however my users are entering values any which way. I've got US, USA, U.S., U.S.A, United States, and others. How can I limit them to just ONE value?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members are going to learn how to create a popup form to allow the users to pick the country flag from a list of world flags and return that selection to ANY form that calls it.
MEMBERS VIDEO:
Microsoft Access Multi-Table Update Q...
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/UpdateQueryMultiTable
LINKS:
Relationships: https://599cd.com/Relationships
Update Queries: https://599cd.com/UpdateQ
Backing Up: https://599cd.com/Backup
Relational Combo Boxes: https://599cd.com/RelationalCombo
Cascading Combo Boxes: https://599cd.com/Cascading
Concatenation: https://599cd.com/Concatenation
IIF Function: https://599cd.com/IIF
IsNull: https://599cd.com/IsNull
Outer (Left) Joins: https://599cd.com/OuterJoin
Images: https://599cd.com/Image
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, multi-table update query, update query from another table, update from other table, CurrentProject.Path, images in a combo box, pictures in combo box, picture drop down, add flag image to customer form, world flags, display country flag, normalize, normalization, use field in one table to update a field in another table, update table from another table, change data in multiple tables
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Louis from Arlington, Virginia (a Gold Member) asks: I've got my state and country fields as text like you show in your videos, however my users are entering values any which way. I've got US, USA, U.S., U.S.A, United States, and others. How can I limit them to just ONE value?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members are going to learn how to create a popup form to allow the users to pick the country flag from a list of world flags and return that selection to ANY form that calls it.
MEMBERS VIDEO:
Microsoft Access Multi-Table Update Q...
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/UpdateQueryMultiTable
LINKS:
Relationships: https://599cd.com/Relationships
Update Queries: https://599cd.com/UpdateQ
Backing Up: https://599cd.com/Backup
Relational Combo Boxes: https://599cd.com/RelationalCombo
Cascading Combo Boxes: https://599cd.com/Cascading
Concatenation: https://599cd.com/Concatenation
IIF Function: https://599cd.com/IIF
IsNull: https://599cd.com/IsNull
Outer (Left) Joins: https://599cd.com/OuterJoin
Images: https://599cd.com/Image
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, multi-table update query, update query from another table, update from other table, CurrentProject.Path, images in a combo box, pictures in combo box, picture drop down, add flag image to customer form, world flags, display country flag, normalize, normalization, use field in one table to update a field in another table, update table from another table, change data in multiple tables
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
3 سال پیش
در تاریخ 1400/01/04 منتشر شده
است.
37,637
بـار بازدید شده