They're here! More Muvipix.com Guides by Steve Grisetti!
The Muvipix.com Guides to Premiere & Photoshop Elements 2024
As well as The Muvipix.com Guide to CyberLink PowerDirector 21
Because there are stories to tell
muvipix.com

FREE DATABASE

Talk about anything here.

FREE DATABASE

Postby 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 ] Image
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.
User avatar
Little Nac
Premiere Member
Premiere Member
 
Posts: 259
Joined: Mon Jun 08, 2009 10:56 pm
Location: Bribie Island, Australia

Re: FREE DATABASE

Postby 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.
User avatar
John 'twosheds' McDonald
Moderator
Moderator
 
Posts: 4237
Joined: Mon Feb 19, 2007 11:57 am
Location: Cheshire, UK

Re: FREE DATABASE

Postby 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
User avatar
Steve Grisetti
Super Moderator
Super Moderator
 
Posts: 14444
Joined: Sat Feb 17, 2007 5:11 pm
Location: Milwaukee, Wisconsin

Re: FREE DATABASE

Postby rfjg » Thu Oct 28, 2010 8:41 am

I agree, try OpenOffice.org, I think you'll find it will do the job.
User avatar
rfjg
Senior Contributor
Senior Contributor
 
Posts: 270
Joined: Mon Oct 15, 2007 10:36 am
Location: Canada

Re: FREE DATABASE

Postby 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.
User avatar
Chuck Engels
Super Moderator
Super Moderator
 
Posts: 18155
Joined: Sun Feb 11, 2007 10:58 pm
Location: Atlanta, GA

Re: FREE DATABASE

Postby 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.
User avatar
ed
Premiere Member
Premiere Member
 
Posts: 1592
Joined: Thu Feb 22, 2007 9:17 am

Re: FREE DATABASE

Postby 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 ] Image
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.
User avatar
Little Nac
Premiere Member
Premiere Member
 
Posts: 259
Joined: Mon Jun 08, 2009 10:56 pm
Location: Bribie Island, Australia

Re: FREE DATABASE

Postby 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.
User avatar
Chuck Engels
Super Moderator
Super Moderator
 
Posts: 18155
Joined: Sun Feb 11, 2007 10:58 pm
Location: Atlanta, GA

Re: FREE DATABASE

Postby 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
User avatar
sidd finch
Moderator
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