Re: Database Design

On Thu, 11 Jun 2009 03:24:06 -0700, Frank Situmorang
<FrankSitumorang@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hello,

I am very thankful to all people here whol helped me. I have finised and
used my church membership database. Now since my specialty is actually
accounting, now I want to try to create an accountinf software:

My question is:

1. Is Access capable of accomodating huge of reccords?

For certain values of huge, yes. A .mdb (.accdb) file is limited to 2 gbytes.
In practice I know of working, real-life Access databases with 20,000,000 rows
in the largest table.

And of course an Access application can be linked to a SQL/Server, MySQL,
Oracle or DB2 database containing terabytes of data.

2. In my try, I only used One to Many table relationship, should there be
Many to Many if it is for accounting software? Waht is the example of many to
many

There will undoubtedly be several many to many relationships in an accounting
application; each many to many relationship will be decomposed into two (or
more) one to many relationships. Just for example, if you have Accounts
containing money, and Creditors who get money, there will be a many to many
relationship since each Account may be used as the source of money to pay
several different Creditors, and each Creditor may in principle receive money
from several different Accounts.

3. The easier way to understand waht the database normalization

Get a good book. You may be able to find a copy of Rebecca Riordan's
_Designing Relational Database Systems_. There are references to lots of books
at http://www.mvps.org/access - look at the Resources link. Find a book that
fits with your learning style and study, study, study, and practice, practice,
practice. It is a very logical set of concepts but it does not come naturally
to everyone!

4. Waht is the important thing to know for accountiong software

I'm no accountant, but data integrity and traceablilty ("where did this
transaction come from and why is it there!?") would seem to be critical.

Thanks in advance for any help.

Frank

Good luck, and glad that your church database is working. How many
congregations are using it now, if I may ask?
--

John W. Vinson [MVP]
.

Relevant Pages

  • RE: database with yearly split data
    ... i am designing a database for a firm that has annual period of the accounting. ... balances of the suppliers and customers accountings ... as the first records in the new database accounting tables and stock tables. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Looking for inventory management and invoicing programs
    ... > Good point Rick, but I think most of the problematic issue with Y2K related ... Accounting program used 4 digits for data in the year ... Database program generated "automatic dates" using Julian ... It simply went nuts trying to report dates after 12/31/1999. ...
    (comp.sys.tandy)
  • Re: Database Design
    ... Thanks John for your extensive explanation. ... Oracle or DB2 database containing terabytes of data. ... Many to Many if it is for accounting software? ... containing money, and Creditors who get money, there will be a many to many ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simply Accounting
    ... It actually turns out that simply accounting uses ms-access files (and the ... counting uses the same database format as ms-access. ... also, and if you don't join that workgroup file, then you'll not be all to ... Dim strTables As String ...
    (microsoft.public.access.modulesdaovba)
  • Earn good money from home - an opportunity for Indians
    ... THIS CAN REALLY MAKE YOU EASY MONEY! ... it said that you send Rs.10 to the Main Database Address stated ... KHAMMAM - A.P-- INDIA. ... postal mail/courier with money to the main member and to the other 5 up ...
    (sci.med.transcription)