Hi Ed,
You should be able to redesign the form's layout in InfoPath Designer to make it look beautiful. The data is separate, so the view modifications won't affect the underlying database connections.
I recommend just replacing the whole view. Put your cursor in it, press ctrl-a to select all and hit the delete key. Then, start adding layout tables and dragging and dropping fields into them from the data source.
This will take a few hours, but you'll have a much better looking form.
Cheers,
Patrick