If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Accounting Database
I am not sure if when designing an Accounting Database should there be a
seperate table for Charges and Payments, or rather a single table called Transactions. Can anyone comment on Pros and Cons? Thanks |
#2
|
|||
|
|||
A good general rule for table design is that you can describe the table in
one sentence without using the word "and". Consider that if each charge can be associated with an indefinite number of payments then it is best (essential, really) to keep payments in a separate table linked to the charges table. In form view Payments would be a subform of Charges, which in turn could be a subform of Clients (or whatever). "Gary B" wrote: I am not sure if when designing an Accounting Database should there be a seperate table for Charges and Payments, or rather a single table called Transactions. Can anyone comment on Pros and Cons? Thanks |
#3
|
|||
|
|||
The answer to your question may depend on whether you plan to use Double
Entry accounting or Single Entry accounting. If you need a full fledged Double Entry accounting application then you will probably be better off by using separate tables. Single Entry can be handled easily with a single table. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Gary B" wrote in message ... I am not sure if when designing an Accounting Database should there be a seperate table for Charges and Payments, or rather a single table called Transactions. Can anyone comment on Pros and Cons? Thanks |
#4
|
|||
|
|||
Why would you want to do Accounting in Access? There are many very good and
simple to use accounting programs and most will integrate with Access for specific querying and reports. "Gary B" wrote: I am not sure if when designing an Accounting Database should there be a seperate table for Charges and Payments, or rather a single table called Transactions. Can anyone comment on Pros and Cons? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cannot change password | Richard | General Discussion | 13 | November 14th, 2004 10:00 PM |
Database Corruption | Lawrence | New Users | 1 | October 28th, 2004 05:08 PM |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |
Please Help, The database is in an unexpected state; Microsoft Access can't open it. | Gary A. Hollenbeck | New Users | 2 | May 20th, 2004 05:42 PM |