The design of accounting databases

I

Isis

Anyone have any good links to info on how general accounting databases are
set up ? I am putting something together in Access to link my inventory and
invoicing system with but would like an idea of the general layout of the
various Tables etc used in accounts systems.

Any help appreciated.

Thanks
 
I

Isis

How would you link them on paper? Use the same method for the database
design.
Click to expand...
Thanks for the reply but I don't know how they do link up on paper - I
was hoping for a but of help there.

Regards
 
D

Dennis

Dude(ette?)

Accounting theory is kind-of beyond the scope of these newsgroups. In
reality, you should discuss these issues with your company accounting dept.
They can probably explain it pretty well for you.
 
I

Isis

Dude(ette?)

Accounting theory is kind-of beyond the scope of these newsgroups. In
reality, you should discuss these issues with your company accounting
dept. They can probably explain it pretty well for you.
Click to expand...

It was more the 'practice' than the "theory" that I wanted to get to
grips with !

I don't work for a company so do not have access to an accounting dept -
I sort of understand the concept of ledgers but wanted a few pointers
about the Tables that would be associated with them. I know from building
my inventory and invoicing DB that these things are not always what they
seem.

I wanted an example of how the 'double entry' bits work. Is there no
basic template that I could look at that you know ?

Thanks for the reply again anyway.

Regards
 
V

Van T. Dinh

This is a very broad question and the answer can probably fill a book.
Perhaps, you should bet a copy of the book:

Building Accounting Systems Using Access 2002

by Perry & Schneider published by South-Western (a div of Thomso Learning).
This books goes through the basics of an accounting system and Microsoft
Access and then proceed to develop an Accounting System database going
through the different cycles of the accounting system.
 
I

Isis

This is a very broad question and the answer can probably fill a book.
Perhaps, you should bet a copy of the book:

Building Accounting Systems Using Access 2002

by Perry & Schneider published by South-Western (a div of Thomso
Learning). This books goes through the basics of an accounting system
and Microsoft Access and then proceed to develop an Accounting System
database going through the different cycles of the accounting system.
Click to expand...

Thanks very much for that - just what I wanted (I think !).

Regards
 
I

Isis

This is a very broad question and the answer can probably fill a book.
Perhaps, you should bet a copy of the book:

Building Accounting Systems Using Access 2002

by Perry & Schneider published by South-Western (a div of Thomso
Learning). This books goes through the basics of an accounting system
and Microsoft Access and then proceed to develop an Accounting System
database going through the different cycles of the accounting system.
Click to expand...

Ordered a copy form Amazon for £5 delivered - which seems exceptional value
to me - thanks to all fot the advice.


Regards
 
V

Van T. Dinh

Good value. I think I paid quite a bit more when it first came out in 2003.

Even though it was for Access 2002, the concepts and structure are still
exactly the same for Access 2003.
 
Top