The Mudcat Café TM
Thread #79392 Message #1438368
Posted By: Barbara Shaw
19-Mar-05 - 01:26 PM
Thread Name: Music Data Base Wanted
Subject: RE: Music Data Base Wanted
I really like Access for database files, Excel for number crunching and Word for text and graphics (or Illustrator when necessary).
You can paste Word tables into Access to convert to a database and then use the information very efficiently for reports and queries and lists. One of the nice things about Access is that you can create several different tables on one database -- for example a table of sheet music, a table of cd recordings, a table of composers, etc. and tie them together by joining a common field such as e.g. composer name. Then you can print out common elements in a report, for example a report of all your sheet music by John Lennon, recordings you have by him and any information you've collected about him on your composer table.
All of this of course would require some knowledge of database design, which is one of the things I did in my former life. But you could certainly set up a simple table in Access to hold all the things asked for in the original post.