It's been a few years since I've had to work with Access but I don't miss it much. There were several shortcomings such as 1) Trying to do complex queries in that awful query designer, 2) the database expanding everytime a temporary table is created and having to contract it manually, and 3) The possibility of the entire database becoming corrupt and unusuable.

Given a choice and especially with the advent of Reporting Services, I would never choose a career in Access as opposed to SQL Server.