Personal Database project for scouting: generals tips/advice appreciated!
This may belong in some other area, but I like it here, so here's where I'm posting.
I have decided out of madness to try and build a database, to better manage my scout group.
Scout HQ in the UK has promised us a software suite to do this for the best part of a decade; personal info, badge records, attendance, subs payment, event planning, all of it. But they've yet to release anything, even a beta version!
Lacking anything else, I planned to start at the bottom, and simply build an access database for it.
With time I'd love to make it a proper web based front end that I can package and give to others to install either locally or on a web server and all that jazz, but first thing's first is build the database!
Now the snag is, I've never learnt Access beyond flicking through some awful books/guides over the years, though I have a good understanding of the maths/theory behind it due to some degree level computing study. I've never made, in fact any style of database before...
So I'm looking for any hints/tips the experts out there might have that I can implement straight away. Any suggestions, since I'm starting with a literal clean slate for other programs that would work better from the get-go (free, I'm not buying a whole new application package just for this!), or whatever.
If there's some fellow scout leaders here, make a few suggestions for what I might include in it! ;)
I suspect this will take me many months/years to get fully completed, but gotta start somewhere!