Splitter is a Microsoft Access add-in that separates human names stored in a single field into separate components fixing poorly structured tables. Video Overview
If both first and last names are stored in the same field or column in your Access database, Splitter will split the name without disturbing your existing data. FAQ
Splitter works by creating new fields and parsing a copy of the name data into the new columns. A wizard guides you through the process. More detail