"All the fields were entered in ALL CAPS, and I need to convert them to Title Case."

You can use an update query. This example fixes the Company name in tblTable:

UPDATE tblTable SET Company = StrConv([Company],3);