Free database software

strudey · 23 Jun 2009 at 20:41

Can anyone recommend some good free database software? Is any included with windows? Or is there an easier way of doing this? I just want to make a very simple database of quotes that I like. Needs to work on Vista x64. Thanks

adren · 23 Jun 2009 at 21:08

SQLExpress is free from microsoft, not sure if that is what your after... or something where you can also create forms etc like access?

strudey · 23 Jun 2009 at 21:14

What's a form? haha. Basically I have a load of quotes, I want to be able to easily enter them, with keywords, so that I can bring up a list of ones with a certain keyword when I want it. I'm trying it with Excel but I don't know how to make it just show me the ones with a certain keyword.

adren · 23 Jun 2009 at 21:29

Ok, you can do it in excel, you would just do a lookup. If you want something more database oriented and you don't have access then I think openoffice has a free equivalent.

http://www.openoffice.org/

Skeeter · 23 Jun 2009 at 21:52

If you have Excel do you not have Access?

oldbag · 23 Jun 2009 at 21:56

MySQL?

eXor · 23 Jun 2009 at 21:58

.

MySQL

.

RickST · 23 Jun 2009 at 23:14

Use Excel - or open office version

Supertaff · 23 Jun 2009 at 23:22

If you want a simple database system then if you want to pay for something use MS Access, if you want something free and similar use Open Office Base.

If thought you want to learn about databases and items like SQL, then go for SQL Express or MYSQL.

Taff

Skeeter · 23 Jun 2009 at 23:55

I cannot understand how he cannot already have Access if he has Excel....? Just use that

rpstewart · 24 Jun 2009 at 09:02

Skeeter said:
I cannot understand how he cannot already have Access if he has Excel....? Just use that

Most editions of Office don't include Access.

Ucof · 24 Jun 2009 at 10:16

I wouldnt suggest SQL - its genuinely far too powerful, feature rich and complex for what the OP is looking for. It's a kin to buying a Bugatti Veyron for nipping down the shops in.

As already suggested, I'd recommend open office's Database tool so you dont have to pay for Access.

Ev0 · 24 Jun 2009 at 11:40

Skeeter said:
I cannot understand how he cannot already have Access if he has Excel....? Just use that

Because access is included in Office Professional, so if he has Office Standard (I'm talking pre 2007 versions here) he won't have it.

Think Office 2007 had a version Pro Professional which has Access with it (and so does Enterprise), again the standard base version won't have it.

strudey · 24 Jun 2009 at 15:48

I have office 'home and student' 2007. I'll give that openoffice one a whirl! Thank you

whitecrook · 24 Jun 2009 at 22:44

if that's really all you want to do, just use a text file. Put each quote on one line. And then to get a quote based on a keyword type this in:

Code:

type quotes.txt | findstr "keyword"

to add a quote
type this:

Code:

>>quotes.txt echo this is the new quote

Simples!

Skeeter · 24 Jun 2009 at 23:47

strudey said:
I have office 'home and student' 2007. I'll give that openoffice one a whirl! Thank you

Home and Student has Access....

EDIT: Correction, no it doesnt, how useless and crap is that!