Camp

CAMP DATABASES
Please enter your database wish list here and also the types of reports you would like to generate. Also collect hard copies of the reports you print now. Click **Edit this Page**, make your entry then click **SAVE** in the upper right.

Camp uses Microsoft Access and Blackbaud. Both are located on the in-house camp server.

Access is used to create individual databases for storage of data for campers, staff (return and new), swimming lessons, Rising Star Sports, Aftercamp, and prospective families. Our largest database for Day Campers contains approximately 55-60 fields of data.

Blackbaud/Student Billing is a database for every child in Day Camp, Aftercamp, the Swim Lesson Program, and the Rising Star Sports program. Data such as family information and billing information is recorded and tracked.

What We Do
• Data Entry • Mail Merges o Labels o Name Tags o Envelopes o Letters o Medical Reminder Notices • Millions of Lists (sometimes on a daily basis) - Examples below o Campers leaving and arriving each session o zip code/carpool listing for families o Group lists o T-shirt size lists o Medical information list for the nurse o Counselor notes by group • Queries/Sorting • Scripts for age of campers/staff, phone numbers o Most everything we do comes from a query/sorted info. • Accounting (Receivables – no general ledger) o Create Bill Codes/Fee Codes each year o Generate revenue, itemize charges, print bill statements (at any point) o Create deposits, deposit revenues, create deposit reports o Record and track payments & deposits on an on-going basis to be disseminated to the business office and camper families o Generate multiple records/accounts or individual record/account o Pre-generate records/accounts to cross-ref with camper application information o Edit/Change/Delete billing information (fees/codes) for withdrawals & changes to enrollment o Create both Manual and Set Fees o Calculate Deposits, Payments, and Tuition Refunds o Transfer monies from one account to another

DREAM DATABASE
• Import current databases (access) into the new database • Secure Information • Create labels, envelopes, letters, e-mails • Create targeted direct mail and email campaigns to help us stay in touch with families and staff • Eliminate the use of Blackbaud, and instead have just one database that does it all! • Spell check • Deposit Monies, Generate Billing, Create Bill Statements, Create deposits, enter deposits onto accounts, run reports, deposit receipts • For each summer program, financially tracking of balances, refunds, transfer of $$, payments • Queries, Sorting • Ability to create & change the prices and descriptions of each fee code • Ability to create & change bill codes • Create Financial Reports • Ability to Purge • Track withdrawals • Export database info into Word or Excel • Great flexibility with creating/adding/changing/deleting the fields • Fields without character limitations • Ability to customize the database on-site • Manual and set charges • Web-based (security?) • Scheduling • Create billing/account numbers for each child (within each program) • Print Options (query) • Copy selected record information to create a new record for the same child (to eliminate the need for entering the info again) • Ability to charge an interest/late fee (after a specified date) • Payables • Vendor Account Payables w/ check writing capabilities