Results 1 to 11 of 11
  1. #1
    Bkper087 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2014
    Posts
    81

    Summer Camp Management Database - Any Suggestions?


    I am still a newbie when it comes to Access. I pretty well mastered excel without it being my full time job, but it has some limitations. I can see a huge benefit to using access. I am the camp director of a non-profit, mid-sized summer camp with 85 seasonal employees and 3,000 visitors during the summer. My goal is to create a database that would track applicants through the job application process, manage salaries, budget projections, and schedules for employees including time off. I have looked at some classroom database templates, but they all lack the ability to manage the financial side. Does anyone have a template they wouldn't mind sharing or know of a good place to look for something similar that I can edit for my own use? I'm not really in the market to buy something, since it is a non-profit and is a would be nice to have deal. Thanks for any suggestions or help!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,546
    I doubt you will find a single template encompassing all that functionality. That really is a LOT!

    For scheduling, you might find this of interest https://www.accessforums.net/databas...ses-18459.html

    Payroll accounting is a challenge because of tax and labor laws. Recommend QuickBooks or similar OTS software. Considering the time and effort you would have to devote to developing db, OTS is a cost effective option.

    I worked for Camp Fire and we paid a contractor at least $60,000 to customize and maintain a registration program based on Access. Our accounting software was Great Plains and it cost thousands for each module purchased.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,284
    I too have a fully functional db for summer camp. I can send if you want.

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You could check out this site.
    http://www.databaseanswers.org/data_models/

  5. #5
    Bkper087 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2014
    Posts
    81
    Thanks for the feedback. That website could be my new favorite database resource! Thanks a ton.

  6. #6
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Your Very Welcome. Good Luck With Your Project!

  7. #7
    Fatbiker is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    3
    Can you send me what you have?

  8. #8
    Hsingfoo is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    1

    Looking for summer camp database.

    Quote Originally Posted by ranman256 View Post
    I too have a fully functional db for summer camp. I can send if you want.
    I'm running a summer camp in Taiwan and am taking the winter season to work on streamlining the system. I'd sure appreciate it if you could share the database you mentioned. My email is "david" and then the ending "@englishcamptaiwan.com".

    Thanks!

  9. #9
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,284
    the db was sent to your email.

  10. #10
    Join Date
    Jun 2020
    Posts
    1
    Can you send me the db as well thank you,
    eversworldtv@gmail.com

  11. #11
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    330
    Hi ranman

    I would be interested in a copy as well please.

    mike.s23 at outlook.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Designing db for a day camp
    By mordecai98 in forum Database Design
    Replies: 3
    Last Post: 11-11-2013, 01:07 AM
  2. Asset Management Web Database
    By gemadan96 in forum SharePoint
    Replies: 2
    Last Post: 05-01-2013, 02:36 PM
  3. Examiner Database Design Suggestions
    By seth1685 in forum Database Design
    Replies: 1
    Last Post: 01-05-2012, 10:11 AM
  4. Search engine result database suggestions
    By PIHA520 in forum Access
    Replies: 0
    Last Post: 05-29-2011, 05:44 PM
  5. Replies: 3
    Last Post: 06-24-2010, 07:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums