Memberships

benc

Registered User.
Local time
Today, 04:46
Joined
Dec 31, 2001
Messages
57
Hi Im trying to create a membership directory for a club but people pay a monthly fee can anyone offer some advice or has an example that i can work from to create this. I need to to just keep there name and address etc and their payment history and then every month print a list of those who havent paid, tick these people off as they pay and then the next month it starts over again. Thanks in advance
 
The best way to do this is to run a query each month that selects active members and appends a dues transaction for each active member. Then as payments are received, the dues for a particular member/month are marked paid. At intervals, you can run a report that selects outstanding dues items and creates printed reminders that you can mail.
 
benc said:
Hi Im trying to create a membership directory for a club but people pay a monthly fee can anyone offer some advice or has an example that i can work from to create this. I need to to just keep there name and address etc and their payment history and then every month print a list of those who havent paid, tick these people off as they pay and then the next month it starts over again. Thanks in advance

I have just purchased Access 2003 for a similar purpose - club membership records. I am not stupid but Access makes me feel like a complete dunce! I have no idea what I am doing, despite buying two huge books and working through them cover to cover. If anyone has somethings as a template which I could use I would be SO SO grateful. This is also the first time I have used a forum so apologies if I am getting something wrong re etiquette. I can provide more details if anyone is out there! Thanks in advance...sue
 
Would you expect to purchase Java and be able to develop an application? The problem is not with Access. The problem is that developing an application is far different from using a word processor to write a letter or using a spreadsheet program to create your grocery list. To develop an application you need to acquire a number of skillsets. You can't just sit down, open Access and expect to be productive.
1. You need to be able to gather requirements and define the business rules.
2. You need to be able to identify the data that needs to be stored and develp an appropriate schema that will efficiently store the data and include referential integrity and data validation rules to minimize data errors.
3. You need to be able to lay out understandable forms and reports so that data can be entered and displayed in a coherent fashion.
4. You need to be able to create queries so you need to learn SQL or at least learn how to use the built in query builder to handle your basic needs.
5. And finally, to produce professional quality applications, you need to learn VBA so that you can write code that does things that you cannot do by simply setting property values and choosing options from lists.

There is a membership template available from the Microsoft templates site. It will give you a start.

Open Access
Look at the templates available in General Templates (from the task pane)
If there is no suitable template (I'm not sure what 2003 comes with) then go to the web by selecting the templates from Microsoft.com option. You will be taken to the main templates page. There are dozens of templates for all the office products. Here is a direct link to the membership db template.

Memberships template
 

Users who are viewing this thread

Back
Top Bottom