Paul Stanley - bespoke software development services
Paul Stanley Software
Bespoke Software Development, Lancashire, UK

Bespoke Membership Software

Membership : Software for Theatre Group

A Membership Database created for Burnley Youth Theatre, Lancashire, written in Access 2007.

The theatre runs over 80 classes or projects a year for young persons aged 4 to 25. Projects typically run for a term, but can have any number of sessions and attendees (fig 2). A health and essentials report includes emergency contacts and important medical information for the project leaders.

Details of members attending projects include:

  • Contact Details - name, address, email, phone
  • Emergency Contacts
  • Consent for publicity
  • Membership payment and expiry
  • History of workshops attended
  • Disability
  • School
  • Health Notes (see fig 1)

Old member's details can be archived and later recalled.

List selection allows users to easily build a list by adding different searches together. Searches can be performed by age range, category, postcode, and gender. Lists can be printed or used to generate mailing labels or emails.

Attendance is recorded session by session. Register sheets are printed for recording at the workshops.

Reports required by funding bodies like the Arts Council are produced:

- total sessions attended
- unique participants
- ethnic background
- disability, gender and age reach

Reports can be selected on multiple criteria : postcode, date range, production/workshop, how they heard about the theatre.

Payments received are recorded, annually, term by term, on a project basis or weekly by session. Reports can be produced over a selected date range.

"We were impressed with how Paul understood all our requirements and delivered exactly what we needed"
Gareth Davies General Manager - Burnley Youth Theatre

figure 1 Member Details

Burnely Youth Theatre - Members Details

Figure 2 Project Details

Burnley Youth Theatre Project Details

Figure 3 Attendance and Payment

Burnley Youth Theatre Attendance

Keywords: Theatre Database, Attendance Records, Membership Software, Performance, Arts

Copyright © 2016 Paul Stanley Software 7 Needham Way, Skelmersdale, Lancashire, WN8 6PR
UK Bespoke Software Development; Custom Business Applications; Web and Database Solutions; Software Developer; Lancashire, North West
Manchester, Liverpool, Warrington, St Helens, Southport, Preston, Blackburn, Bolton, Blackpool, Lancaster, Skelmersdale, Runcorn