I have worked at a job where ColdFusion was used with Oracle as backend. I was the DBA and never worked directly with ColdFusion, but they do work well together and there are probably plenty of jobs out there for it.
If you have already had experience with Web design, I would think you'll be fine. Go for it!
I dont' know what training is out there for ColdFusion, but I've been told it's fairly easy to learn. As for the Oracle end, learn SQL and PL/SQL, if you don't already know it. SQL tuning and optimizing is critical in deploying an effective application system. Learning the basic architecture of Oracle would be beneficial too. Those would be the places I'd start if I were you.
I work myself with ColdFusion and Oracle. If you know VB or VBScript, you will need a day to learn ColdFusion. ColdFusion is a strong language, the only one 100% portable, but less used anymore than asp. ColdFusion do anything than ASP can do. In my opinion is a language for artists, who want to become programmers in only one day, and is not so elegant than ASP because is not procedural. So go for it, it's simple.
For PL/SQL you need to buy a book in Oracle Press edition about PL/SQL. But how to return cursors from strored procedures on recordsets you will find in websites like
P.S if you do simple select from tables, there are no difference if the DB is Oracle or Access the ODBC is the seem, the difference is on back-end processes, triggers, procedures if you have any.
YOU must subscribe on a mailing list like firstname.lastname@example.org, to get help from asp-oracle developpers (subscribe on [url]http://www.asplists.com[/url] site) but for ColdFusion I do not know if there are any communities.
Thank you all for your responses. I will continue to look for help and support. I got a hold of ColdFusion's SkillBuilding CD Tutorial, and it has helped a lot. Access seems easy enough to start, but I know eventually I will need to get involved with Oracle.
Thanks again, and any other advice or tips are more than welcomed.