How do I set up yearly sales tables for multiple stores in access?

L

Lallo

I've been trying to decide if Microsoft Access would be better than Excel for
storing large amounts of weekly, quarterly, and yearly sales reports for my
restaurant business. I'm not sure if Access is the best fit ... any advice?

Thanks.
 
J

Jeff Boyce

Lallo

Advice ... what do you intend to do with the data after "storing" it?

If you'll be "massaging" the numbers, Excel excels at that.

If you'll be creating reports and running queries/searches, Access may meet
your needs.

NOTE: if you decide to put data in Access, you will NOT get full benefit
from Access features and functions if you simply copy your Excel
data/structure over into Access. Access is a relational database tool, so
you'll want to look into normalizing your data structure if you want to use
Access' strengths.
 
Top