Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-17-2019, 01:02 AM   #1
RickT
Newly Registered User
 
Join Date: May 2019
Posts: 3
Thanks: 6
Thanked 0 Times in 0 Posts
RickT is on a distinguished road
New Requirement for Out of School Club

Hello,
1st post on the forum, I have recently started volunteering to assist on the technical side with a local after school club which is a not for profit organisation with 4 staff members looking after a total of 30 children over the course of the week before and after school for a few hours either side.



At present, everything is done manually on paper from the daily registers, parent pickup sign out sheets, invoices and account management to track payments. As you can imagine this is a massive overhead in time to complete so the club could benefit with some automation in place to provide a more efficient process.


Therefore im looking to develop some form database / toolset to simplify process.


At present, i see the requirements are as follows....

  • Child and parent database for contact details including email.
  • Export data to form daily register of children due to attend.(names from a picklist pulled from the contact details)
  • Parent collection signature /sign out form digital or paper to record collection of child and time for audit purposes.
  • Invoice / report creation based on the data taken from the register for those attended to be compiled on a monthly basis.
  • Account summary per child/family detailing sessions attended and current balance based on payments/invoiced amount.
My initial thoughts where to compile some form of Access DB to host this type of request rather than going to a 3rd party company due to the lack of funding available, however in order to start this im really not sure where to start.


Is anyone aware of any open source templates which could be a foundation to work on and customise further to our requirements rather than creating from scratch / blank canvas or offer any advice that MS Access is the right tool for this type of requirement ?



Thank you in advance.

RickT is offline   Reply With Quote
Old 05-17-2019, 02:37 AM   #2
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,628
Thanks: 55
Thanked 994 Times in 961 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: New Requirement for Out of School Club

You could probably use any club membership system as a starting point.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
The Following User Says Thank You to gemma-the-husky For This Useful Post:
RickT (05-17-2019)
Old 05-17-2019, 03:19 AM   #3
RickT
Newly Registered User
 
Join Date: May 2019
Posts: 3
Thanks: 6
Thanked 0 Times in 0 Posts
RickT is on a distinguished road
Re: New Requirement for Out of School Club

Quote:
Originally Posted by gemma-the-husky View Post
You could probably use any club membership system as a starting point.

Problem is finding one at the moment. - i've not used Access for about 10 years so just watching youtube videos at the moment to refresh my memory

RickT is offline   Reply With Quote
Old 05-17-2019, 04:59 AM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 13,566
Thanks: 73
Thanked 1,483 Times in 1,372 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: New Requirement for Out of School Club

Quote:
offer any advice that MS Access is the right tool for this type of requirement
I have no templates to share regarding membership but can confirm for you that Access can do this sort of thing pretty easily. Nothing you listed in your "wish list" looks that tough but I have no knowledge of actually collecting signatures. Everything else in your bullet list should be a piece of cake.

Here's a big hint: Think "Divide and conquer." Each bullet in your list is a focal point for a division of focus - which says you have already done some necessary preliminary work and that's good. Programming is almost always about breaking problems down into individually achievable steps, and your problem at first blush does not appear to be outside that norm.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
RickT (05-17-2019)
Old 05-17-2019, 07:06 AM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 2,094
Thanks: 25
Thanked 543 Times in 531 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: New Requirement for Out of School Club

Hi Rick. Welcome to the forum. For the signature collection part, take a look at this demo from my website. Hope it helps...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
RickT (05-17-2019)
Old 05-17-2019, 08:36 AM   #6
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,786
Thanks: 17
Thanked 341 Times in 338 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: New Requirement for Out of School Club

Welcome Rick!

Something you may want to look at is getting a swipe card reader. Rather than trying to collect signatures, if you capture the track 1 or track 2 data off of a card you may have an easier time.
Mark_ is offline   Reply With Quote
The Following User Says Thank You to Mark_ For This Useful Post:
RickT (05-17-2019)
Old 05-17-2019, 11:37 AM   #7
RickT
Newly Registered User
 
Join Date: May 2019
Posts: 3
Thanks: 6
Thanked 0 Times in 0 Posts
RickT is on a distinguished road
Re: New Requirement for Out of School Club

Thank you all for your suggestions and welcomes..



Plan is to try and pull something basic over the course of the weekend and then take it from there.



I do like the idea of a swipe card too but will start with the basics



thanks

RickT is offline   Reply With Quote
Old 05-17-2019, 12:29 PM   #8
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,786
Thanks: 17
Thanked 341 Times in 338 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: New Requirement for Out of School Club

RickT,

Most of the low end swipe card readers simply read a track and output as text (think automatically keying in) so (hopefully) all you'd have to do is have focus on a text control and it gets pushed right in.
Mark_ is offline   Reply With Quote
Old 05-17-2019, 08:13 PM   #9
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: New Requirement for Out of School Club

Swipe card reader is okay, but if it were me I would prefer it as with contactless credit card.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 05-17-2019, 08:36 PM   #10
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 424
Thanks: 2
Thanked 85 Times in 81 Posts
Micron will become famous soon enough Micron will become famous soon enough
Re: New Requirement for Out of School Club

there's a ton of schemas here http://www.databaseanswers.org/data_models/
Maybe you'll find something under the headings of children or churches. Note that these are not templates or db's , but schemas. If they don't make any sense to you, then consider reviewing

Normalization Parts I, II, III, IV, and V http://rogersaccessblog.blogspot.com...ng-part-i.html
and/or
http://holowczak.com/database-normalization/

Entity-Relationship Diagramming: Part I, II, III and IV http://rogersaccessblog.blogspot.ca/...ng-part-i.html

How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.ca/2009/05/how-do-i-create-application-in.html

Some of these pages have moved but can still be accessed from the target pages. I'll have to update my list. I left off my usual links for naming conventions and other tips. I don't wish to imply you don't know much Access stuff.

__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
The Following User Says Thank You to Micron For This Useful Post:
RickT (05-17-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Database for a strip club. :) Karelis General 9 05-01-2014 02:39 PM
Club Open Day! Uncle Gizmo General 0 03-18-2008 01:02 AM
Cook Club dt01pqt The Watercooler 0 12-20-2005 04:22 AM
[SOLVED] Club Membership system Need Help nextgen General 0 02-12-2004 02:32 PM




All times are GMT -8. The time now is 05:53 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World