Small Business Accounts (Northwind Traders Sample) Advise

[RoyLittle0]

Hi, I am fairly new to Access and would like some advise on a small business products database and accounts system.



I am thinking of using the Northwind Traders database as a starting point as it seems to have most of what I need.

The business is a part time company that my wife has started with her sister, selling items at craft fares so I will need to include:-

Suppliers details
Customer details
Products
Stock levels
Invoices
Weekly, Quarterly and yearly sales
Order history

All of the above I think I can do in the Northwind Traders sample database, but what I want to add to this is:-
Money paid in to the company (set-up)
Money out (Payments back for set-up)
Money out (wages, at some point)
Payments (stock, equipment, other purchases)

What is my best way of doing this, am I able to link this into the Northwind Traders database (I am sure this must have been done before) or should I look for a accounts package, i really need to do this at limited cost as its a very small business with limited income, any advise would be appreciated.

I would really love to be able to link it into the Northwind Traders database if possible, but definitely want to try and do this in access, didn't realise how versatile this software was for saying I have had it for 2 years and not used it before, I did try something similar in Visual Studio, with limited effect or usability.

[ssanfu]

Have you looked at the free Access templates at Microsoft?

http://office.microsoft.com/en-us/te...=access&av=zac

[RoyLittle0]

Hi, thanks for the reply.

yes I have looked at the Microsoft templates, this is where I got the Northwind Traders template, but I couldn't find anything close to what I wanted, which I found quite surprising as I would have thought that this would be the perfect software for a small accounts database.