Your application of course will need to support it, and SQL server doesn't have a native "attribute" that I know of to say that "NULLs aren't allowed, but zero-length strings are...", you could ...

Learn how to use SQL in Microsoft Access with this step-by-step guide, complete with examples, FAQs, and tips for better database management.