[Roy Dennis]

Not recommended but,
You can remove leading spaces in Access by selecting the column then use find and replace. From the Match selection drop down box select Start of field, in the find enter a blank space, in the replace leave blank then hit replace all. If you try this bear in mind that if you ever rebuild the songbook all the changes will be lost.

However as Skybird stated, it is best to do all your editing in Hoster Edit dialog, if you click on a column header all the leading spaces will appear at the top for you to manually edit them one at a time but the change will be permanent.

You can change the case easy for your songbook in Microsoft Word processor.
It depends on your version of word but in my Word 2000 that I still use, from the format menu is an option for change case, I always select "Sentence case" this will change the whole book in a matter of minutes.