Which Is Better Excel or Access?
This age old question inevitably comes up for users of Excel. Whats the answer??? Well a good link is Daily Dose of Excel: "Wrench vs Screwdriver" and follow the through link to Microsoft for what I think is a very clear and useful explination of the differances and really gives you the answer you need.
In a nutshell, if your focus is calculation and detailed analysis then use Excel, if your focus is on management of relational data then Access. It may not be that simple some of the time but read the article and make up your own mind and experiment!