 The Clarinet BBoard
|
Author: RichA
Date: 2010-02-15 15:14
I have a nice collection of clarinet jazz music, mostly LP's and some CD's. I would like to archive my collection so I can print the results by album, artist, songs, etc. Has anyone used a software for similar reasons that they would recommend? Since most of my collection is comprised of old LP's I will be inputting the data manually and therefore not interested in the "auto-search" some products feature.
Thanks in advance
|
|
Reply To Message
|
|
Author: Bob Phillips
Date: 2010-02-15 15:39
I used Microsoft Access to build a simple database for my 1400-or so pieces of sheet music. I can sort by composer, title, arranger/editor, instrumentation, Opus, ...
Each piece has an "accession number" that is automatically (can be over ridden) supplied by Access, and the music is stored in file drawers by that number.
It is a life saver, but I have yet to build the discipline to put the music back in "accession number order".
Dang, I'm missing that marked-up-with-my-teacher copy of Mozart Kv 622, ...
Bob Phillips
|
|
Reply To Message
|
|
Author: GeorgeL ★2017
Date: 2010-02-15 18:58
As a self-taught Microsoft Access user, I agree with the idea behind Bob's answer, but not the specifics. Access might be a simple database to a knowledgeable person, but not to a novice. In addition, most Office packages do not include Access, which will cost on the order of $200.
The fall-back for most database-challenged people is a spread sheet. Put everything is a different column, and sort on the columns as needed. But a database is much better for this application than a spread sheet,
The easier answer is to do a Google search for "simple database" and get one. I found one at http://www.databaseoasis.com/ that sells for $70 and looks like it is a lot easier to use than Access. A video on their web site indicates it also has a sample database for tracking 'CDs', so all you may have to do is change the titles on that one to cover the subject you want to track.
There may even be freeware databases that will handle your task.
|
|
Reply To Message
|
|
Author: kdk ★2017
Date: 2010-02-16 02:13
If you want to try going the general database manager route, the Open Office suite (which is completely free of charge) includes a DBMS (relational, if you want to get that far into it) that works pretty well for simple data collections. You can probably just Google "Open Office" to get a link to the download - or go to the Sun Microsystems website and find it there.
I did my first catalog of my LPs years ago using Access. After a virus wiped out both the file and the backup, I tried the Music Collector program from CollectorZ. It does automatic searches for CDs and anything with a bar code (if you have a barcode scanner), but you can easily input LPs manually.
Karl
|
|
Reply To Message
|
|
Author: RichA
Date: 2010-02-16 20:58
Thanks again everyone. It looks like the Music Collector program best fits my needs. As always, this forum is tops.
|
|
Reply To Message
|
|
The Clarinet Pages
|
 |
.jpg){kind=small}
.jpg){kind=small}
.jpg){kind=small}
.jpg){kind=small}
.jpg){kind=small}
.jpg){kind=small}
