Talk about anything here.
by Little Nac » Thu Oct 28, 2010 2:19 am
Hi to all. Does anyone know of a free database I could use to catalogue my DVD Movies. At the moment I am using Excel, but it is a bit of a pain. All I need is for the Movie Name, Running Time and possibly the actor's name. It needs to be able to sort in alphabetical order, and print about 3 or 4 columns to a A4 sheet of paper (Letter size in the U.S. case). The simpler the better. Any advice would be greatly apprecited. I have searched the Internet to no avail. Thanks in advance. [ Post made via Mobile Device ]
If you are faced with a forced landing at night, switch on the landing lights, if you don't like what you see, switch them back off.
-
Little Nac
- Premiere Member
-
- Posts: 259
- Joined: Mon Jun 08, 2009 10:56 pm
- Location: Bribie Island, Australia
by John 'twosheds' McDonald » Thu Oct 28, 2010 4:00 am
Did a quick Google search and I also didn't find any free ones but I did find several at around US$30/UK£30/EU€30 or so.
AMD Ryzen 3900x 12C/24T, ASUS x570 mobo, Arctic Liquid Freezer ll 280, Win11 64 bit, 64GB RAM, Radeon RX 570 graphics, Samsung 500GB NVMe 980 PRO (C:), Samsung 970 Evo SSD (D:), Dell U2717D Monitor, Synology DS412+ 8TB NAS, Adobe CS6.
-
John 'twosheds' McDonald
- Moderator
-
- Posts: 4237
- Joined: Mon Feb 19, 2007 11:57 am
- Location: Cheshire, UK
by Steve Grisetti » Thu Oct 28, 2010 7:39 am
There's always OpenOffice, Oracle's free, open source version of Office. The Word-like, Excel-like and Powerpoint-like files it creates are all compatible with Microsoft Office.
I don't know that it will necessarily be simpler than Office -- but it's certainly cheaper (free).
And then there's always Microsoft Project, a database program that can store and retrieve your list with as many or as few categories of information as you'd like.
I haven't done any experimenting with it, but the OpenOffice package does include a version of it too that may well be worth checking out!
HP Envy with 2.9/4.4 ghz i7-10700 and 16 gig of RAM running Windows 11 Pro
-
Steve Grisetti
- Super Moderator
-
- Posts: 14444
- Joined: Sat Feb 17, 2007 5:11 pm
- Location: Milwaukee, Wisconsin
by rfjg » Thu Oct 28, 2010 8:41 am
I agree, try OpenOffice.org, I think you'll find it will do the job.
-
rfjg
- Senior Contributor
-
- Posts: 270
- Joined: Mon Oct 15, 2007 10:36 am
- Location: Canada
by Chuck Engels » Thu Oct 28, 2010 10:17 am
MySQL is free.
1. Thinkpad W530 Laptop, Core i7-3820QM Processor 8M Cache 3.70 GHz, 16 GB DDR3, NVIDIA Quadro K1000M 2GB Memory. 2. Cybertron PC - Liquid Cooled AMD FX6300, 6 cores, 3.50ghz - 32GB DDR3 - MSI GeForce GTX 960 Gaming 4G, 4GB Video Ram, 1024 Cuda Cores.
-
Chuck Engels
- Super Moderator
-
- Posts: 18155
- Joined: Sun Feb 11, 2007 10:58 pm
- Location: Atlanta, GA
-
by ed » Thu Oct 28, 2010 11:55 am
I would use MySql as Chuck suggested, and connect Excel to MySql. Or, If you know scripting languages, make a web interface with PHP that you run locally on your PC.
-
ed
- Premiere Member
-
- Posts: 1592
- Joined: Thu Feb 22, 2007 9:17 am
by Little Nac » Thu Oct 28, 2010 4:34 pm
Thank you very much to all for your advice. I can't believe that it is so hard to find just a very simple database on line. I have seen the Office Org advertised but never worried about it as I have MS Office 2007 & now 2010. Will also check out MySql. Thanks again for the help. [ Post made via Mobile Device ]
If you are faced with a forced landing at night, switch on the landing lights, if you don't like what you see, switch them back off.
-
Little Nac
- Premiere Member
-
- Posts: 259
- Joined: Mon Jun 08, 2009 10:56 pm
- Location: Bribie Island, Australia
by Chuck Engels » Thu Oct 28, 2010 4:39 pm
If you have Office then you possibly have Access, which is a very simple Microsoft Office Database.
1. Thinkpad W530 Laptop, Core i7-3820QM Processor 8M Cache 3.70 GHz, 16 GB DDR3, NVIDIA Quadro K1000M 2GB Memory. 2. Cybertron PC - Liquid Cooled AMD FX6300, 6 cores, 3.50ghz - 32GB DDR3 - MSI GeForce GTX 960 Gaming 4G, 4GB Video Ram, 1024 Cuda Cores.
-
Chuck Engels
- Super Moderator
-
- Posts: 18155
- Joined: Sun Feb 11, 2007 10:58 pm
- Location: Atlanta, GA
-
by sidd finch » Thu Oct 28, 2010 5:44 pm
If you are using Excel why don't you just create a pivot table in another tab in the spreadsheet. That way you can customize your pivot table link it to the original file then everytime you update your old excel file you just refresh your pivot table and it will update the information. Also if you have the MS office suite you could use access database to upload your excel file and create a managed report. Send me a private message if you would like a detailed set of instructions.
Sidd
"Life moves pretty fast. If you don't stop and look around once in a while, you could miss it." ..... Ferris Bueller
-
sidd finch
- Moderator
-
- Posts: 6542
- Joined: Mon Apr 23, 2007 5:20 pm
- Location: Cyberspace
Return to Water Cooler
Similar topics
Who is online
Users browsing this forum: No registered users and 109 guests
|