Access or Excel for swim club fees

P

Phil Boorman

I have built a simple database for our competitive swim team that contains
info such as name, address swim group etc. As the registrar I need to pass
along information to the treasurer on a monthly basis that indicates how
much money she is expecting to collect. There are monthly fee's that apply
to individual swimmers and yearly fee's that apply to families. I would love
to build a table/form that links to my list to track in/out payments but I
am coming from a pretty basic level so I have been searching for sample
databases that I could adapt. Would I be better off just exporting my list
to Excel and doing the financial calculations with a spreadsheet?
 
T

tina

you can probably do it in Access pretty easily. please post details of your
tables, and i'll make some suggestions to you. use the following format:

TableName1
FirstField (use PK to indicate the primary key field)
SecondField
ThirdField (use 'FK from table name' to indicate a foreign key field)
FourthField
etc

TableName2
FirstField
SecondField
etc
 
Top