• Home
  • About
  • Piano
  • Drums
  • Blog
  • Composer for Hire
  • Contact
  • Music Store
    • Erstes Quartett
    • Ave Maria - Brass
    • Cushman Music Zazzle Shop
  • Copyright Music For Sale
  • Group Theory Classes
  • Student Tutorials
    • ABPL Level 1A
    • ABPL Level 1B
    • ABPL Level 1C
    • ABPL Level 2
    • ABPL Level 2/3
    • ABPL Level 3
    • Alfred's Adult Level 1
    • Alfred's Adult Level 2
  • Podcast: Three Ps of Piano
    • Podcast 5.27.2020
    • Podcast 5.28.2020
    • Podcast 6.2.2020
    • Podcast 6.3.2020
    • Podcast 6.5.2020
    • Podcast 6.6.2020
    • Podcast 6.9.2020
    • Podcast 6.16.2020
    • Podcast 6.24.2020
    • Podcast 7.8.2020
    • Podcast 7.16.2020
    • Podcast 7.26.2020
  • Home
  • About
  • Piano
  • Drums
  • Blog
  • Composer for Hire
  • Contact
  • Music Store
    • Erstes Quartett
    • Ave Maria - Brass
    • Cushman Music Zazzle Shop
  • Copyright Music For Sale
  • Group Theory Classes
  • Student Tutorials
    • ABPL Level 1A
    • ABPL Level 1B
    • ABPL Level 1C
    • ABPL Level 2
    • ABPL Level 2/3
    • ABPL Level 3
    • Alfred's Adult Level 1
    • Alfred's Adult Level 2
  • Podcast: Three Ps of Piano
    • Podcast 5.27.2020
    • Podcast 5.28.2020
    • Podcast 6.2.2020
    • Podcast 6.3.2020
    • Podcast 6.5.2020
    • Podcast 6.6.2020
    • Podcast 6.9.2020
    • Podcast 6.16.2020
    • Podcast 6.24.2020
    • Podcast 7.8.2020
    • Podcast 7.16.2020
    • Podcast 7.26.2020
cushman music
  • Home
  • About
  • Piano
  • Drums
  • Blog
  • Composer for Hire
  • Contact
  • Music Store
    • Erstes Quartett
    • Ave Maria - Brass
    • Cushman Music Zazzle Shop
  • Copyright Music For Sale
  • Group Theory Classes
  • Student Tutorials
    • ABPL Level 1A
    • ABPL Level 1B
    • ABPL Level 1C
    • ABPL Level 2
    • ABPL Level 2/3
    • ABPL Level 3
    • Alfred's Adult Level 1
    • Alfred's Adult Level 2
  • Podcast: Three Ps of Piano
    • Podcast 5.27.2020
    • Podcast 5.28.2020
    • Podcast 6.2.2020
    • Podcast 6.3.2020
    • Podcast 6.5.2020
    • Podcast 6.6.2020
    • Podcast 6.9.2020
    • Podcast 6.16.2020
    • Podcast 6.24.2020
    • Podcast 7.8.2020
    • Podcast 7.16.2020
    • Podcast 7.26.2020

Fearless Music, Adventures of Sound

    Welcome!

    If you have a comment, we'd love to hear it. Be sure to SHARE this blog!

    Author

    Doniell Cushman loves to use her teaching experiences to inspire ways to improve music, teaching, and learning.

    Archive

    February 2023
    July 2022
    May 2022
    June 2020
    June 2019
    January 2019
    August 2018
    April 2018
    March 2018
    January 2018
    November 2017
    September 2017
    August 2017
    July 2017
    March 2017

    Categories

    All
    Piano Methods

    View my profile on LinkedIn

    RSS Feed

Back to Blog

Create a Music Database

1/6/2019

 
The five essential entrepreneurial skills for success: Concentration, Discrimination, Organization, Innovation and Communication.  ~ Harold S. Green

I had a dream years ago when we lived overseas in Germany. Part of it was due to boredom, part of it aspiration, and part of it convenience. This dream was catapulted by a class I took in college called Information Systems Management. 

I've always loved Access by Microsoft. I'm an odd duck, what can I say? But seriously, the ability to organize and filter things, create forms and reports ... it did what Excel can do, yet so much more. I wanted to see everything I owned and was (and still am) acquiring in key signatures, difficulty levels, publishers, cost, etc.

The benefits of creating a database of your music library are manyfold. So, let me give you a lending hand as to what you can do.

Database Ideas:
  • Music Pieces - for individual songs, works, whatever you want to call them.
  • Music Books - for every book you own filled with music
  • Methods - for every book that is a method (i.e. Alfred's Basic Piano Library, Piano Adventures)
  • Albums - for all records, discs, MP3s, and other formats of music you know
  • Educational Materials - for books about composers, treatises, theory, pedagogy, etc.
  • Your compositions and works in progress

Now how can you sort this material? By this I mean, what information do you want accessible at your fingertips? Make primary indexes to be book numbers or ISBNs. Titles of books and pieces should be written with overly specific information. Have two sources for the Moonlight Sonata? Use Opus numbers or organizational systems (WoO, K. numbers, etc.), or you could even put a parenthetical note for the arranger, book, and so forth, or editions.
  • After primary indexes, make sure you include things like:
  • Composer
  • Arranger
  • Key Signature (if applicable)
  • Accompaniment as a yes/no
  • Duet as a yes/no
  • Cost (if applicable)
  • Year purchased (if desired)
  • Year published
  • Publisher
  • Book Numbers or Levels
  • CD as a yes/no
  • Pages
  • You difficulty level rating
  • Instrument
  • Genre

The next step would be to create a form to fill out for each database, and reports. These should automatically update in the software you use, so that as soon as you fill out a form, the information is added. 

Ideas for Reports would include:
Music by Composer (and make sure composer names are entered consistently with first and last names)
Music by difficulty level
Music by key signature
Duets
Pieces with accompaniment 
Music by instrumentation

As a teacher, this is super useful. I can filter my results or pull a report for a student at a certain level, in a certain key signature and by a specific genre without having to leaf through hundreds of my books and materials.

I hope this post gives you excellent ideas on how to organize your library, studio, office, or classroom. I know it seriously helps me. Yes, it takes some time setting up and getting through entering everything you own ... but in the end, you have something like this to look forward to:
Picture
0 Comments
Read More
Proudly powered by Weebly