[Beavis]

both questions pertain to MS access:

is there a way in MS Access to change the case on all the song names at one time?

is there a way to delete a blank space before the song name begins (by this i mean some songs the spacebar was hit before typing the first letter) i want to delete all the blank spaces with one click.