Dear Computer Lady,
I am trying to find a simple database program that will let me enter all of my movie DVD’s. All of my movies are on shelves in numerical order.
I need to enter the movies into a database starting with the number and then the title of the movie. After all of this is done, I would then like the database to be able to put the movies in alphabetical order (which would put the numbers out of sequence) in order to print out a list of all my movies. I have over 550 DVD’s which makes it hard to find a movie I want to watch.
I have checked out numerous databases on the web but they all show cover pictures, info on movies, etc. I don’t want any of this, just a simple one to do what I want. Do you know of any simple database program that would work for my needs?
You could do this with a simple spreadsheet.
Microsoft Excel is a spreadsheet program, but if you don’t have it on your computer, you can also use OpenOffice Calc, which is free at www.openoffice.org
First, set up your spreadsheet. Make a column with the number of the DVD in the first column and the title of the DVD in the second column. When you start, you will probably enter them in numerical order.
Make sure that each line across is one DVD. It should look something like this:
0002 Veggie Tales
0003 Sesame Street Movie
Don’t worry if the numbers are automatically be changed to 1, 2, and 3.
When you want to put them in alphabetical order, highlight all the cells in the spreadsheet by clicking upper left area of the spread sheet. It is the small box above the number 1 and to the left of the letter A.
Once all your cells are selected, click on “Data” in the menu bar, then click on “Sort”.
In the sort box that opens, go to the “Sort by” section and change “Column A” to “Column B” using the drop down arrow.
Click “OK” to save your changes.
Your movies are now in alphabetical order and you may print the list.
These directions work in both Excel, and Calc.