My DVD collection is getting ridiculously huge and I want to make an inventory database for it so I can keep track of it all. I'd like to make it complex, like you can organize it anyway you want (alphabetical, whether it's widescreen or fullscreen, the rating, etc.), you can search for a DVD, and all the bells and whistles. I'm just wondering what I should do it in. The only thing I know how to do that in is PHP/MySQL, but I don't know if I want to do that. It'd be nice to have it in something like Excel or whatever, but I'm not familiar with Excel, so I don't even know if you can do that. My question is what program do you all think I should use to make this complex database? Thanks!

What do you have? Excell is a bad idea. There's Access, if you already have it.

However, why do you call this a "complex" database? The attributes you mentioned above have nothing to do with the complexity of the database. Those are just different manners of retrieving/displaying the data. It's a pretty simple design actually - unless you want to go to the trouble of entering actors, directors, etc. for every movie and having them cross-referenced. Then it would start to gert complex.

However, if you want a ready made solution I would suggest Movie Track. It will automatically fill in data from imdb.com for you. At the very least it would get all the data you need to import into your database if you create your own.
Michael J

VB 2005 Express edition and and an access file will give you a lot of options for creating a nice little app to do this.

Two good suggestions so far. Michael's right...As far as complexity goes, this barely registers on the meter in the database world.

Bare easiest to just get the job done? Access beginning to end (not counting any pre-made software). Coolest and most educational way? VB or C# 2005 Express with SQL Server Express 2005. Both express products are free, Access is not.

-SN