As Osgorth comments, Excel can work just fine for entering a music collection. You can create a data entry form or simply enter directly into the cells. And as pointed out, Autofilter is a very powerful tool for seeing subsets of your collection.
Just be aware that Excel will allow you to sort columns independently of each other, thereby destroying your data integrity. I had that happen to me once with a client address file, and it's not a fun experience. As long as you learn how to sort your data and keep rows together, Excel can be great tool to use.
That being said, I use Access for my collection of several thousand classical LPs. Because Access is a database, data integrity is assured and "lookups" and other features reduce typing for quicker data entry and improved consistency. Once the data has been entered, however, I'm almost as happy searching within Excel as searching within Access, with one exception. Access allows for a "filter by selection" so one can filter based on any portion of the data in a given cell. For classical and jazz, this can be very useful when looking for multiple works that include a particular performer, or for works with similar, but not identical, titles.
Good luck,
Just be aware that Excel will allow you to sort columns independently of each other, thereby destroying your data integrity. I had that happen to me once with a client address file, and it's not a fun experience. As long as you learn how to sort your data and keep rows together, Excel can be great tool to use.
That being said, I use Access for my collection of several thousand classical LPs. Because Access is a database, data integrity is assured and "lookups" and other features reduce typing for quicker data entry and improved consistency. Once the data has been entered, however, I'm almost as happy searching within Excel as searching within Access, with one exception. Access allows for a "filter by selection" so one can filter based on any portion of the data in a given cell. For classical and jazz, this can be very useful when looking for multiple works that include a particular performer, or for works with similar, but not identical, titles.
Good luck,