Aero Club Members Database

  • sydc
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
23 Mar 2014 18:49 - 23 Mar 2014 18:57 #1 by sydc
Aero Club Members Database was created by sydc
Hi,
Please go easy with me this is my first post.
I wondered if any members of the forum would be interested in an Aero Club Members Database?
I initially wrote the database to 'look after' the club members details of my club and the database has functioned without any problems for the last 3 years.
The database is written using Microsoft Access 2010 and requires both Office Excel and Outlook to function correctly. The database is structured in such a way that all data may be accessed from a single form, full backup utilities together with a full reporting system and an integrated textual help system are also available.
PM me if you would like to try out the database, it is fully configurable for club name and logo, the database is free to use without license.
Regards,
Syd.
Last edit: 23 Mar 2014 18:57 by sydc.

Please Log in or Create an account to join the conversation.

More
23 Mar 2014 18:57 - 23 Mar 2014 19:11 #2 by Phil Wood
Replied by Phil Wood on topic Aero Club Members Database
No problem about it being your first post Syd, you have done it twice, so I'll just delete one of them for you,..... no problem.

Pol.

I just own the forum .... you guys make it great thanks.
Last edit: 23 Mar 2014 19:11 by Phil Wood.

Please Log in or Create an account to join the conversation.

More
23 Mar 2014 19:13 #3 by Phil Wood
Replied by Phil Wood on topic Aero Club Members Database
You've lost me with the computer jargon sorry Syd, ... what exactly does this database do?
Please excuse my ignorance.

Pol.

I just own the forum .... you guys make it great thanks.

Please Log in or Create an account to join the conversation.

  • sydc
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
23 Mar 2014 19:31 #4 by sydc
Replied by sydc on topic Aero Club Members Database
Hi Polyphilla,
This database records and saves all the model club members details in one location, this would include address details for that member, whether junior or senior member, BMFA proficiency details, model noise recordings, club achievements, club subscriptions, the list goes on. Printed reports are also available together with the ability to e-mail details direct from the database.
I did try to attach a PDF document to the post explaining what the database is capable of but this did not appear to materialize.
Hope this helps.
Regards,
Syd

Please Log in or Create an account to join the conversation.

More
23 Mar 2014 20:20 #5 by Phil Wood
Replied by Phil Wood on topic Aero Club Members Database
I'm not sure about attaching a PDF file ... I'll ask my son Mike, who also happens to be our forum builder, or you can PM him yourself & talk computers. .... he's on the user list as "admin" .
I like the idea of the database, let's go with it.

Pol.

I just own the forum .... you guys make it great thanks.

Please Log in or Create an account to join the conversation.

  • Garry Pollard
  • User
  • User
More
23 Mar 2014 20:21 #6 by Garry Pollard
Replied by Garry Pollard on topic Aero Club Members Database
Hi Syd
Is this something that other clubs can use without infringing any licence issues ? If so it could be a good thing to put before your committee for consideration. They may have their own method, but could certainly consider it

Garry

Please Log in or Create an account to join the conversation.

More
23 Mar 2014 20:24 #7 by alan cantwell
Replied by alan cantwell on topic Aero Club Members Database
Would the public--modellors and all, have access to the info there?

i have 2 sides
no you dont,
yes i do,

Please Log in or Create an account to join the conversation.

  • Garry Pollard
  • User
  • User
More
23 Mar 2014 20:35 #8 by Garry Pollard
Replied by Garry Pollard on topic Aero Club Members Database
You ask that question Alan , but dont give your views on it . As the membership details are not available except to admin members. Should it be used on here, I would expect that to remain . The individual member can put as much or as little as he wants on his profile, but would not like to see the membership listed details made for general viewing

Garry

Please Log in or Create an account to join the conversation.

More
23 Mar 2014 23:05 - 23 Mar 2014 23:07 #9 by Eric
Replied by Eric on topic Aero Club Members Database
Microsoft Access 2010 and requires both Office Excel and Outlook to function
I don't have these on my pc! I do have open office, which is more or less compatible with MS office.
It's a long story, but I refused to pay a second time for something that was already installed on my new pc, so it was blocked by ms. The pc has since been replaced, but I still won't have ms office.

If you start storing people's data on a drive somewhere, you have to comply with the Data Protection Act.

if you are calm and collected when all about you are going berserk - you've missed something important!
Last edit: 23 Mar 2014 23:07 by Eric. Reason: added a comment
Thanks: The Beard

Please Log in or Create an account to join the conversation.

  • sydc
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
24 Mar 2014 14:34 #10 by sydc
Replied by sydc on topic Aero Club Members Database
Hi All,
I will try and answer your queries as simple as possible.
The database was written to correlate the details of an Aero Club membership. When there are 80+ members in the aero club it would be a daunting task for the membership secretary to maintain all the relevant members data on hard copy, with this database all the members data is stored in one place on the database, the members data may be retrieved instantly and if required printed reports are available.
Garry,
Yes, you may use this database without infringing any licencing laws, I wrote this database myself and it is free to use without licence, you will of course require a registered copy of Microsoft Office 2010/2013 to run the database.
Alan,
The database is encrypted and a password is required to open the database. Because the data held in a club database is personal information it may only be used within the club and may not be distributed publicly otherwise this may contravene the 'Data Protection Act 1998'. I originally wrote this database for my club membership secretary to use and it has proved invaluable since its' inception. Also available in the database are numerous reports available for hard copies.
Eric,
This database may work with the free version of Sun Java Open Office but I have not tried this.
Hope this helps,

Regards,
Syd.
Thanks: Eric

Please Log in or Create an account to join the conversation.

More
24 Mar 2014 14:53 #11 by Phil Wood
Replied by Phil Wood on topic Aero Club Members Database
Blank e-mail sent as requested Syd, best of luck. ;)

Pol.

I just own the forum .... you guys make it great thanks.

Please Log in or Create an account to join the conversation.

More
24 Mar 2014 16:50 #12 by alan cantwell
Replied by alan cantwell on topic Aero Club Members Database
i didnt give my views on it? i didnt know i had to, :( :(

i have 2 sides
no you dont,
yes i do,

Please Log in or Create an account to join the conversation.

  • Garry Pollard
  • User
  • User
More
24 Mar 2014 16:58 #13 by Garry Pollard
Replied by Garry Pollard on topic Aero Club Members Database
There was no computation to answer Alan, I was maybe thinking you may be worried if your details were put on public view, I certainly would be.

Garry

Please Log in or Create an account to join the conversation.

More
24 Mar 2014 18:20 #14 by alan cantwell
Replied by alan cantwell on topic Aero Club Members Database
Thats exactly what i was thinking, :woohoo:

i have 2 sides
no you dont,
yes i do,

Please Log in or Create an account to join the conversation.

  • Ex-Member
  • User
  • User
More
24 Mar 2014 18:45 #15 by Ex-Member
Replied by Ex-Member on topic Aero Club Members Database
I think you may have misunderstood one of the questions Syd.....what I would be concerned about is any infringement of the data protection act and who the information would be available to?

....and welcome aboard Syd, by the way.

Please Log in or Create an account to join the conversation.

Time to create page: 1.223 seconds