how do i set up a club in Access?

I

IainADove

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).
 
R

rystali'2yahoo.com.

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...
 
T

troy23

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
 
Top