Databse for sales figures for multiple customers and multiple vend

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

Guest

Let me first start off by saying this is my first post ever in a message
board and I apologize if this has been addressed somewhere else. Please
advise on where I can find this information if it has already been answered.

I am using Access 2003 and I am trying to come up with a database that will
allow me to track and input monthly sales figures for my customers for
multiple years. I have around 500 different customers that are all assigned
unique numbers to store them in our system.

I also have around 10 -15 vendors that my customers can order from. I am
wanting to set it up where I can look up customers sales figures for certain
years (i.e. 2003,2004,2005,etc....) for all of the different vendors.

I was trying to set it up as a seperate database for each vendor and then
within that database a table for the customer information and a table for all
of the sales figures for each customer. Am I able to setup multiple years
within a single table? How can I set it up that when I put in the year it
pulls up all of the values for that particular year for that customer. I
would also like to be able to total up all the sales for each particular
vendor.

Should I just set this up in an Excel spreadsheet? It seems that a
spreadsheet would just get exponentially bigger with each passing year.

Any help that anyone can give me would be greatly appreciated.

bsitterle
 
You may want to look at the sample database that comes with Access, called
Northwind Sample Database. It seems to have a structure very much like your
business, with products that you purchase from suppliers to sell to your
customers. You may be able to modify that database to fit your needs.
 
Back
Top