Simple Access Template

[JDB]

Hi,


I have not used Access for years and looking for a really simple DB.
All the DB needs to do is input the number of products a buyer purchases on a particular visit.
Following a time period the user can select a specific buyer from a group of buyers (drop down list maybe?) and select how much of each product they purchased for the time period and print out a report that states the quantity of each item purchased.
Buyers may purchase many types of product and may come back multiple times in this period.
This is really all it needs to do at the moment, I have been trying in Excel, however cannot filter by buyer.
Assistance is much appreciated.
Thanks

[JamesDeckert]

Have you used 'sort & filter' in Excel?
I think the better path is Access, but you should be able to filter in Excel.
This first step is to figure out what all info you want in the database. Below I've thrown out a start, but there may be other things that need to be included.

tblBuyer
BuyerID (autonumber)
Buyer (text)

tblPurchases
PurchaseID (autonumber
DatePurchased (date)
Product (text) or maybe there should be a Product table containing possible products, in which case this field would be the foreign key to the product table
qty (long)
BuyerID (long) FK to tblBuyer table

[ranman256]

the forum wont upload my example db.
send me an email

[JamesDeckert]

ranman, did you zip the db?

[ranman256]

yes, but still wont upload. and its 22 Meg zipped.
ping me an email

[June7]

Why don't you follow James' suggestion and build one?

What do you mean by 'Following a time period' - you want to limit buyer frequency of purchase?

[JDB]

Hi all thank you everyone for your replies.

I did originally start attempting to build a database, however as it has been so long I couldn't remember how to start and wasted a fair bit of time before coming on here.

I have sent you my email ranman, thanks.

June7 as per your question the buyer may come and buy items on numerous occasions in a time cycle, there is no limit, however during that time period I would like to know what is purchased.

Thanks again everyone for your help.

[June7]

A little refresher training wouldn't hurt http://www.rogersaccesslibrary.com/.

[JDB]

Well I figured out how to do it exactly in Excel however I thought I'd start building a database as well.

I don't want to go too far down the wrong track so I have attached what I have started with. Is this all I need and am I on the right track as I am a bit rusty?

Just the tables and relationships so far.

I would like a form that I can add multiple orders per day for multiple buyers that basically just picks how many of each product the buyer purchases. Need a field for number of certain products purchased somewhere as well?

The report would just export all data that a buyer purchased on a date or set of dates.

I think this is all it needs to do at this stage so should be pretty easy, however I have not done any of this for years.

Thanks for your assistance.

[June7]

That's a good start. Advise no spaces in naming convention (Buyer Name). Also, avoid reserved words as names (Type).

Use a form/subform arrangement for data entry/edit of orders. Main form bound to tblOrder and subform bound to tblOrderProduct.

Could even do form/subform/subsubform - tblBuyer/tblOrder/tblOrderProduct.