Re: Database Design

Thanks John for your extensive explanation. I am in Jakarta and we live in a
developing country, so purchasing book is expensive for us, so I will try to
google over the internet website to find out the subject.

There are 124 congragatinos all in the citi of Jakarta and surroundings with
more or 15,000 members of Seventh Day Advntist Church. For the time being, 12
churches have used it.

Thanks & Regards,

Frank

"John W. Vinson" wrote:

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 Design
    ... In practice I know of working, real-life Access databases with 20,000,000 rows ... 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: Software Evaluation
    ... may be an appropriate database program....Microsoft Access. ... return the expensive program you bought and spend the money on fine ... Bummer...then again, more for cigars! ... John ...
    (rec.music.classical.guitar)
  • Re: Congratulations
    ... Most people don't look at the accounting behind SS. ... Current SS taxes taken directly from a dishwashers paycheck are being ... money is entered into the SS ledgers for later repayment to SS ... If the gov tries to screw SS, add pissed off retirees, massed for the ...
    (rec.boats)
  • Re: Congratulations
    ... Most people don't look at the accounting behind SS. ... money is entered into the SS ledgers for later repayment to SS ... If the gov tries to screw SS, add pissed off retirees, massed for the ... There are no funds there. ...
    (rec.boats)
  • Re: acounting question
    ... Quicken and Money are not true accounting programs but rather for ... personal finance which is fine. ... I switched to Money 03 from Quicken ...
    (misc.invest.stocks)
Loading