Change Between UPPER, lower, and Proper Case in your Microsoft Access Databases
18.8 هزار بار بازدید -
3 سال پیش
-
In this Microsoft Access tutorial,
In this Microsoft Access tutorial, I will teach you how to convert strings (such as names) to UPPER CASE, lower case, and Proper Case. You will learn how to use the StrConv function in your queries. We'll create an update query to change all of the names in your customer table.
Mira from Hamburg, Germany (a Gold Member) asks: My people are horrible at data entry. Half of them type in ALL CAPS and the other half don't know where the Shift key even is. I've got names of all kinds in my Customer table. How can I clean this up?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a MyProperCase function which will convert names that have been typed in all caps or all lowercase, but will leave names that already have mixed case in them alone, such as McDonald or D'Angelo.
MEMBERS VIDEO:
Change Between UPPER, lower, and Prop...
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/ChangeCase
LINKS:
Update Queries: https://599cd.com/UpdateQuery
After Update Events: https://599cd.com/AfterUpdate
More Case Stuff in Access Expert 13: https://599cd.com/ACX13
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, uppercase, ucase, upper-case, upper case, lowercase, lcase, lower-case, lower case, propercase, pcase, proper-case, proper case, strconv, strcnv, mixed case, mixed-case, convert, string, function
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Mira from Hamburg, Germany (a Gold Member) asks: My people are horrible at data entry. Half of them type in ALL CAPS and the other half don't know where the Shift key even is. I've got names of all kinds in my Customer table. How can I clean this up?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a MyProperCase function which will convert names that have been typed in all caps or all lowercase, but will leave names that already have mixed case in them alone, such as McDonald or D'Angelo.
MEMBERS VIDEO:
Change Between UPPER, lower, and Prop...
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/ChangeCase
LINKS:
Update Queries: https://599cd.com/UpdateQuery
After Update Events: https://599cd.com/AfterUpdate
More Case Stuff in Access Expert 13: https://599cd.com/ACX13
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, uppercase, ucase, upper-case, upper case, lowercase, lcase, lower-case, lower case, propercase, pcase, proper-case, proper case, strconv, strcnv, mixed case, mixed-case, convert, string, function
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
3 سال پیش
در تاریخ 1399/12/19 منتشر شده
است.
18,830
بـار بازدید شده