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."

Members

There is no Extended Cut for this video, but watch the Extended Cut for the Compact Importance video!

Links

Compact Importance: https://599cd.com/CompactImport
Text Field Sizes: https://599cd.com/TextFieldSizes
Short v Long Text: https://599cd.com/ShortVLongText
Field Sizes: https://599cd.com/acb3

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 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.