How can I create an accounting system using Access 2003?

S

sebross

I want to create an accounting system using Access 2003.
How can this be done? I have only basic skills in Access, but I want to
learn more.

Sincerely,
Sebross
 
D

David H

Don't!

The integrity checks and the testing involved in building an accounting
system are far too complex. If you need an accounting system then buy one.

As a start in Access build something like a Club Membership system which can
include subscription management - setting the fees due each year, the
subscriptions paid the amount outstanding, reminder and chasing letters.
This can get quite complex, but will give you a feel for dealing with money
transactions.
 
J

James Hahn

Start small, and grow it. Create one table for your chart of accounts and
one table for journals. Create a simple form for entry of journals - assume
a single Dr entry and single Cr entry for each journal initially. Later, you
can upgrade it to allow multiples for each. Create a simple Trial Balance
report and a Ledger report. Later, add Balance Sheet and P&L reports.- that
will indicate what extra data you need in the Chart table for controlling
report formatting. Add subsystems as the need arises, such as cash
receipting and cheques, or Debtors and Creditors. These will involve their
own tables, forms and reports, but they will ultimately create journal
entries that are exactly the same as the ones you created manually in the
initial system.

If you have a solid understanding of double-entry bookkeeping then a system
such as this is an excellent exercise for learning how to build a functional
database system.
 
A

Albert D. Kallal

As others have mentioned, you might find it much better to purchase
something.

In fact, the ever popular Simply Accounting uses the JET engine, and in fact
the files can be opened, and read directly by ms-access!

(they changed the file extensions to fool you a bit...but simply accounting
does in fact use ms-access files).

When you think that you can purchase a whole accounting system for a few
$100, it is hard to imagine that making your own system is worth it.

However, for some simply type GL ledgers, and perhaps something that tracks
donations etc, then ms-access is certainly a good solution.

You can see some screen shots here of some things I done, and one is from a
system that tracks donations, and has a GL ledger. But, I can certainly say
this system is nothing close to a accounting system.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
 
Top