A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do i set up a club in Access?



 
 
Thread Tools Display Modes
  #1  
Old January 18th, 2005, 11:23 PM
IainADove
external usenet poster
 
Posts: n/a
Default how do i set up a club in Access?

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).
  #2  
Old January 19th, 2005, 02:02 AM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"IainADove" wrote in message
...
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).



  #3  
Old January 19th, 2005, 03:57 AM
Ed Warren
external usenet poster
 
Posts: n/a
Default

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" wrote in message
...
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).



  #4  
Old January 19th, 2005, 05:37 PM
LeAnne
external usenet poster
 
Posts: n/a
Default

Office.microsoft.com has an Access template called "Membership" that you
might be able to adapt to your needs. Check it out at

http://office.microsoft.com/en-us/te...185841033.aspx

hth,

LeAnne

IainADove wrote:

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

  #5  
Old January 20th, 2005, 04:55 PM
IainADove
external usenet poster
 
Posts: n/a
Default

Thank you - it will be a good start but looks like a steep learning curve!

"LeAnne" wrote:

Office.microsoft.com has an Access template called "Membership" that you
might be able to adapt to your needs. Check it out at

http://office.microsoft.com/en-us/te...185841033.aspx

hth,

LeAnne

IainADove wrote:

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


  #6  
Old January 20th, 2005, 05:01 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

Suggest you reread Ed's response and heed his advise!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"IainADove" wrote in message
...
Thank you - it will be a good start but looks like a steep learning curve!

"LeAnne" wrote:

Office.microsoft.com has an Access template called "Membership" that you
might be able to adapt to your needs. Check it out at

http://office.microsoft.com/en-us/te...185841033.aspx

hth,

LeAnne

IainADove wrote:

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




  #7  
Old January 20th, 2009, 07:31 AM posted to microsoft.public.access.gettingstarted
rystali'2yahoo.com.
external usenet poster
 
Posts: 1
Default how do i set up a club in Access?



"IainADove" wrote:

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

  #8  
Old January 20th, 2009, 09:54 PM posted to microsoft.public.access.gettingstarted
troy23
external usenet poster
 
Posts: 55
Default how do i set up a club in Access?

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


On 20 Jan, 06:31, rystali'2yahoo.com.
wrote:
"IainADove" wrote:
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).


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get data from Analysis Services cubes into Access General Discussion 2 December 4th, 2004 03:21 PM
is Access 2003 any better than XP? Gorb General Discussion 4 November 11th, 2004 10:44 PM
is Access 2003 any better than XP? Gorb Using Forms 2 November 11th, 2004 10:20 AM
MICROSOFT INVESTING HEAVILY IN ACCESS Mike Painter General Discussion 39 October 15th, 2004 03:56 PM
Access 2000 DB in Access 2002 Tony_VBACoder General Discussion 2 July 28th, 2004 01:23 AM


All times are GMT +1. The time now is 08:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.