2. misc-audio
  3. 1188776540

Microsoft Excel for LP, CD, Tape inventory?

Do a lot of people use these spreadsheet type programs that are (or have been in the past) included in software packages that come with home computers for this purpose? What are the downsides to using this type of computer program for a music media database? We recently catalogued a ton of old VHS tapes going into attic storage with this program on my wife's laptop and it seemed like a natural for this application without having to go out and purchase another software pkg. Thought I'd better ask around though as I'm no computer science major and wouldn't want to wind up with something that might delete 20 or 30 hours worth of keyboarding if someone sneezed the wrong way!...
lg1

Showing 1 response by elevick

elevick
2,636 posts
 
Use Access, not excel.
You can set up fields for title, artist, songs, type of music...
That way you can cross reference by anything. Access will allow you to search by the artist, the group, type of music, year, song name, or any other field you can think of.
If you have the time to kill, put it in access-it's no harder than excel and way better for this purpose.
More to discover