 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2006The design of accounting databases
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 How would you link them on paper? Use the same method for the database design. > 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 [quoted text clipped - 4 lines] > > Thanks > How would you link them on paper? Use the same method for the database > design. [quoted text clipped - 8 lines] >> >> Thanks 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 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. > > How would you link them on paper? Use the same method for the database > > design. [quoted text clipped - 13 lines] > > Regards > Dude(ette?) > [quoted text clipped - 19 lines] >> >> Regards 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 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.  SignatureHTH Van T. Dinh MVP (Access) > 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 [quoted text clipped - 5 lines] > > Thanks > This is a very broad question and the answer can probably fill a book. > Perhaps, you should bet a copy of the book: [quoted text clipped - 5 lines] > and Microsoft Access and then proceed to develop an Accounting System > database going through the different cycles of the accounting system. Thanks very much for that - just what I wanted (I think !). Regards > This is a very broad question and the answer can probably fill a book. > Perhaps, you should bet a copy of the book: [quoted text clipped - 5 lines] > and Microsoft Access and then proceed to develop an Accounting System > database going through the different cycles of the accounting system. Ordered a copy form Amazon for £5 delivered - which seems exceptional value to me - thanks to all fot the advice. Regards 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. SignatureHTH Van T. Dinh MVP (Access) > Ordered a copy form Amazon for £5 delivered - which seems exceptional > value > to me - thanks to all fot the advice. > > Regards There is a template for an Accounts Ledger Database, that could give you a basic idea of how to put such a database together. http://office.microsoft.com/en-us/templates/TC010175341033.aspx?CategoryID=CT011 366791033 > 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 [quoted text clipped - 4 lines] > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.