Well, you could add fields with the correct names, then run queries to update the new columns with the existing column data, then you can whack the existing columns. The columns won't be in the same order, but, they'll be named properly.
Or, Copy the existing table to a new name (backup), delete all records in the new table, rename the fields, and run a query to copy the data from the old table to the new table. Finally, after verifying that all data is correct, rename the old table to a backup name, rename the new table to the old table name, and kill the old table after you're SURE that everything is OK.
Or, ;leave the tables alone & use square brackets around all offensive field names in VBA or forms
i.e. [Customer No], [Tel No], [Booking ID]
Personally, I would go with the second choice.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert