simple accounting database

  • Thread starter Thread starter Frances
  • Start date Start date
F

Frances

I am trying to put the simple accounts that I keep for a
small club into a relational database. I can see how the
members can be treated as customers who buy membership of
the club and also certain items such as club magazine, tie
and booklets. Is it possible to incorporate the running
costs of the club in the same database or would I need
another database for this? Is it possible to have two
distinct sets of related tables in the same database. Am
I trying to do something as a first project that is too
difficult do you think. I would really appreciate any
helpful comments.
 
I'm just going to address the "Is it possible to incorporate the running
costs of the club in the same database or would I need another database for
this?"

An .mdb file is sometimes called a "database". An Access table is sometimes
called a "database", and some people go so far as to call an Excel
Spreadsheet, a "database".

Supposing that you are referring to the Access Table as the database, I
would think that a club that sells trinkets would break down like the
following:

Customers
Memberships
Orders
Orders_Items
Expenses
Products
etc.

So, to me, the answer is yes they can reside in the same database
file(.mdb), but there will be several database tables to fulfill your data
storage needs.

Search for Normalization to learn more about proper table design.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thanks very much for your help Steve. I am just having
difficulty getting my head round having individual members
behaving like customers to buy membership etc and also the
club itself as a group spending money on club expenses.
 
Back
Top