PDA

View Full Version : Simple - Free DVD database for my mate ?


Tempest
07-10-2004, 16:45
Guy at work would like to catalogue his (100+ currently) DVD collection.

You know the kinda thing:
Title, Type, Actor, etc etc

Also perhaps his music CD collection.
He was using word (but not great to do sorts with)

Then tried Exel, but over complicated really.

Can anyone recommend a nice (SIMPLE) easy to use little proggie for doing this kinda thing.

It's just a really simple database that looks pretty and can do printing and sorting.

Had a look at a couple and they were way way OTT. Just need something nice 'n simple.

effpee
07-10-2004, 16:56
Excel was overcomplicated :thinking:

How about using some crayola crayons writing the names down on different coloured cards then asking the nurse to sort them for him.

Tempest
07-10-2004, 17:03
Excel was overcomplicated :thinking:

How about using some crayola crayons writing the names down on different coloured cards then asking the nurse to sort them for him.

Well, not that's it's overcomplicated as such, but it can do ten million other things as well.
We are talking non computer literate here (how you you change font size in word kinda stuff!)
Which is fair enough, not everyone is into computers.

Just want something pre set up, just a simple database for writing in the details of your DVD's and Audei CD's.

Paul
07-10-2004, 17:20
I couldnt really begin to think of anything easier than Excel (other than maybe Word??)

I would imagine dvdprofiler would be well over his head then!

Inigo Montoya
07-10-2004, 17:30
I would imagine dvdprofiler would be well over his head then!

Web site for dvdprofiler :

http://www.intervocative.com/

Would have thought most internet dummies could use this quite easily

DM
07-10-2004, 17:34
dvdprofiler is as simple as it gets. If your 'mate' can't use that, sell your, oops, sorry, his pc. :D

splobber
07-10-2004, 17:36
moving to computing

Tempest
07-10-2004, 17:54
I couldnt really begin to think of anything easier than Excel (other than maybe Word??)

I would imagine dvdprofiler would be well over his head then!

It's not that it's complicated.
It's MESSY.....

Even I have always thought that exel LOOKS messy.
Though I think if you know enough you can design things that hide all the junk and just leave a pretty front end.

Tempest
07-10-2004, 17:58
Web site for dvdprofiler :

http://www.intervocative.com/

Would have thought most internet dummies could use this quite easily

Thanks for the info and link.
Just had a look.

Looks very good.
It's a bit of a shame it does about 10 million more things than he needs (screenshots, barcodes, reviews, loaned DVDs, Charts, graphs etc etc)

But does look nice.

Does no-one actually write anything simple these days :(

I shall suggest this product to him.

Bapapapa
07-10-2004, 18:07
dvdprofiler is as simple as it gets. If your 'mate' can't use that, sell your, oops, sorry, his pc. :D :lol:

Tempest
07-10-2004, 18:38
dvdprofiler is as simple as it gets. If your 'mate' can't use that, sell your, oops, sorry, his pc. :D

Ahem.... Only just got that :suspect:

Honestly it IS a mate.

I don't have enough DVD's to catalogue!

He loves fishing and is near retirement and only got a PC cos his missus is some nursing matron trye thing and needed it for her courses she keeps going on.
he even cancelled the internet as it was costing too much (think he got a dialer/virus on it) he got a £60 bill for 1 phone call !

Anyhow.........

Will pass on any comment made here (or any new ones that get posted)

giger
07-10-2004, 19:08
It's not that it's complicated.
It's MESSY.....

Even I have always thought that exel LOOKS messy.
Though I think if you know enough you can design things that hide all the junk and just leave a pretty front end.


It's not messy, you just don't know how to use it. Excel is very powerful and is very easy to build basic and even complicated things. What you need though is a database and while there's a few things you could piece together in Excel you want to be using MS access.

Access is very straight forward to use (or at least I think it is :thinking: ). If you are not fussed about setting it all up properly just create 1 new table in a new access database. Put 1 field for each bit of info you want into the table, give them a data type of text and somewhere between 50 -255 characters long. Save the table. There is even a wizard when you create a new table that will do this for.
Go into forms, select new, choose a wizard to automatically create a form for you. The next bits depend on the version of access, but at some point you want to choose your new table as the datasource for the form. The wizard will then create a screen with lots of fields on linked to your table. You will be able to view and add info in the form to update the table. Viola, a simple DVD database.

If you can get it working your mate can start playing around with it and creating queries to filer and display data, create reports maybe even dabble in a bit of VBA coding.

That might sound complicated but if you are looking at MS Access while reading this it'll make more sense.

Hope it helps you in some way, shape or form :thumbs:

adam
16-10-2004, 18:29
How do you change your email in dvdprofiler, just checked my link and said its dead, been years probably...try and change email from the old one and says username already exists even though I logged in successfully?

BlackJedi
16-10-2004, 22:20
It's a bit of a shame it [dvdprofiler] does about 10 million more things than he needs (screenshots, barcodes, reviews, loaned DVDs, Charts, graphs etc etc)

But it couldn't be simpler to use. Type in the barcode number, and it adds the DVD to the database. All the other features are available, but you don't have to use them. And it does some much automatically for you.

Hex
17-10-2004, 01:42
he even cancelled the internet as it was costing too much (think he got a dialer/virus on it) he got a £60 bill for 1 phone call !

dvdprofiler will be no use without an internet connection. As giger said, the likely one to use would be Access, once you get past the setting up of a new database it's very easy to use.