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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is Excel good for storing data that constantly updates? 2
New Access user needs database for small bookshop 8
access or excel 2
Is Access right for what I want to do? 0
Paramater box pop up even if customer selected in combo box 1
Switching from FileMaker Pro 9 to Access '07 4
Use icon sets relatively in a pivot table 1
How do I Group by LocID and Month while totaling sales for each month 1

Back
Top