Here's an easy one for you:

What would be the best way to learn SQL2000 for a person coming from an
Access background? (Buy your book? ;^) ) I've used Access for some time as a
DB, but almost always with a VB front-end so I haven't done much "Access
Application" development such as macros, VBA code, etc, just some basic
forms and reports.

I don't need to learn the system admin tasks, as those will be handled by
the IT staff. What I need to learn is how to deploy and maintain a database
on SQL2000. Should I take a class, buy several books, try one of the
CD-based classes, use MSDE first (I won't have access to SQL2000 for several
months) or just sit down with a reference book and start hacking away?