Optimizing Short Text Field Sizes. Is Field Length that Important?
Just how important is it to make sure you specify the correct field size for a Short Text field in your Microsoft Access databases? In this video, we'll take a close look.
Joel from Reno NV (a Learning Connection Member) asks, "In one of the earlier Beginner lessons you showed how to set field sizes to reduce the size of the database. Like reducing the first name field to 20 from 255, etc. In one of the later lessons, I think you said it was no longer necessary to do that - that now Access keeps the database size down without reducing the field sizes. But I wasn't sure and thought I should double check with you before I start creating my database."
Field Sizes: https://599cd.com/acb3
Compact & Repair: https://youtu.be/CXd-6WwPkKY
Short Text v. Long Text: https://youtu.be/yqctePIteXk
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video covers about 3 hours of me building two databases to test the efficiency of short text, long text, compact & repair, and more. See below for a list of all the topics covered in the Member's video.
MEMBERS ONLY VIDEO:
BECOME A MEMBER:
Open Another Database: https://599cd.com/shellex
Sleep Function: https://599cd.com/sleep
Compact & Repair: https://599cd.com/compact
Read & Write Text Files: https://599cd.com/file+io
Get File Size: https://599cd.com/filelen
Delete a File: https://599cd.com/kill
Rename a File: https://599cd.com/rename
FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Email Me: firstname.lastname@example.org
ms access short text, data types, efficiency, size
Please feel free to post your questions or comments below. Thanks.