Help w/ Building Database

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

Guest

Hello,

I am fairly new to access; and I need an easy way to keep track of a couple
things.

I was thinking of doing it in excel, but it would be more complicated in
excel I was told.

So, here I am in access. This is what i need; I had explained it better in
excel but here goes:

I need to track salesman information. But only certain salesman; and by state.

So someone would enter the salesperson, the company sold to; the state the
company was in, and the amt of pairs sold to that customer.

Then I need it to be put somewhere to be analyzed, like out of 2000 pairs
michigan bought 20% of that which is 400 pairs.

I think that is about it. If you have any questions please let me know.

Thank you.
 
Jeremy

Did the person who told you it would be hard to do in Excel have an agenda?
(I.e., were they selling Access?<g>)

Access is a relational database. It has a fairly steep learning curve.

If you only need to sort/filter by some category(ies), and take
totals/percentages, by all means reconsider Excel (or some other
spreadsheet).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top