The first and most important thing, here, is that your customers' names should not be entered into a single Field! The names should be broken up into the components (Last Name, First Name, Middle Initial, Title Suffix) and each entered into their own, separate, Field.
This would solve most, if not all of your problem, here, and since you're just now creating your Table, shouldn't be a problem.
If you need to have the entire name displayed, such as John Q. Public, at a later date, in a Report, for instance, you can easily do this by Concatenating the various Fields.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007