Simple Purchase and Sales Db

[ypma]

To anyone who can advise.

I am trying to build a simple non commercial data base for my son who is starting a venture by buying old golf buggies and refurbishing them ,which are then sold or if cannibalised he sells the component parts. I have looked at the Northwind database, which is far too complex for what I am trying to achieve and I am hoping that there is a book available to help me understand the process of buying , selling and having a stock level .Failing that, is there a sample database on the web that I could down load ? Any guidance would be appreciated .

Regards Ypma

access 2010 - 32 bit

 

[jdraw]

Have you looked at any of the "similar threads" suggested at the bottom of the page?

Here is a link to a free video re:Stock Control Database from Software Matters that should give some guidance.

Here is a link to more info/articles on Database Planning and Design.

Good luck with your project.

 

[ypma]

draw: Thank you for your suggestions , I will certainly view the links you provided, as I approach my Eighties I find my brain is like an elevator that works but does not stop at all floors! . I have not tried creating a stock control database before and tried to reinvent the wheel and dug a big hole for myself. “Still No fool like and old fool." As the saying goes
Thanks again for taking the trouble to respond to my post.

Regards Ypms

 

[jdraw]

No problem, happy to help. We are all getting older.
I have found that getting/creating a good description of your proposed business is the most efficient starting point for designing a database. Too many try to start with physical Access. The analogy is building a house ( or perhaps a new jet aircraft) without a blueprint. Database design doesn't start with DBMS software.

Good luck with your project.