how do i set up a club in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set up a database for a rugby club with various details held on
members including type (Ordinary; Associate; Senior Citizen) which affects
how much they pay. Each year I want to re-set status when money is due &
keep a record of dues paid, ideally automatically updating status (& ideally
creating aleeter / form to acknowledge receipt).
I would also like to be able to write to various categories / statuses of
members (e.g. when subs due).
 
I am in business to provide customers with a resource for help with Access,
Excel and Word applications. My fees are very reasonable. By the nature of
your question, it is apparent you need help in creating the database you
want. I can create this database for you. Contact me at my email address
below if you want my help.
 
I am involved with this type of database (club). We're now working on the
second year of development (over 100 emails from here to the UK).
It may seem easy, but I can see you have many of the complications we faced.
This can (and will) quickly grow out of bounds.

My Advice --

1. This is not a project for the beginner

2. Get some professional and/or volunteer help

Ed Warren
 
IainADove said:
I want to set up a database for a rugby club with various details held on
members including type (Ordinary; Associate; Senior Citizen) which affects
how much they pay. Each year I want to re-set status when money is due &
keep a record of dues paid, ideally automatically updating status (& ideally
creating aleeter / form to acknowledge receipt).
I would also like to be able to write to various categories / statuses of
members (e.g. when subs due).
Click to expand...
 
Firstly you need to work out the tables in your system. Example you
will have a members table, but there are probably others.

Then create the relationships between your tables.

From there you can start to sketch out your forms. The table will sit
behind the form or it may be a query.

It sounds like you have a lot of conditions in your database also.


For FREE Access ebook and videos click here
http://access-databases.com/ebook
 
Back
Top