Access 2003 Question?? Hi - If you know if I can or can not do

Hi - If you know if I can or can not do this - or have any gentle of suggestion how I could - I would GREATLY DEEPLY and GREATLY again appreciate it. What I am looking to do is have a schedule of inventory parts that stores my on hand count. They will respectively have an item code, price, and cost. What I would approaching to do is at the end of respectively day - be capable of enter in what I hold sold for the day, along next to reducing my own hand count correctly. Anything that could show me my profit contained by anyway would also be a huge plus. If this isn't possible - any suggestions of some way of affordably doing this would be great. Thanks

Answers:    this is a adjectives need within a database. it is a bit more complex than this forum provides for. you will want to follow the basic wants you described with several table in access
- items
- customers
- sale orders
- purchase directions
- prices
- transaction registry

then design forms to support background entry into all the table. you will also want reports for invoices, etc. if you are good near databases and form/report design go for it. otherwise find a friend that can assistance or a contractor to get the brass tacks in.

moral luck!
More question :
Small Business Q&A


Copyright 2009-2012 Small-Business-FAQ.com All Rights reserved.     Contact us