Simple clear advice in plain English

How can I personalise a database?

Use Openoffice Base to give your database that personal touch

q-a-logo

Q Can you recommend a database program that can be personalised to keep records on any subject? Something like Lotus Approach would be good, but I’d prefer a free one. I have searched for a free program online, but without success.
John Tooth

A The free Openoffice software suite includes a database program called Base. The Openoffice database, like Lotus Approach (a professional-level program with a price tag to match) is what’s called a relational database. Without getting into the specifics, this means it’s extremely powerful and can handle databases with millions of entries quite easily. It also means it can be quite complicated to get started, particularly if you’re new to databases or to programming.

If your requirements aren’t as complex as that, you may find that a well-put-together spreadsheet will do the job just as well. Of course, this will depend on what you need from your database. If you don’t have Microsoft Excel or Works, Openoffice also includes a spreadsheet called Calc.

Should you go down the full database route and need some help, look in your local library or bookshop for books on SQL, which is the name of the language used to communicate with many databases. There will be quite a lot and many of them will be aimed at experienced professionals, so make sure you flick through them first to see whether they’re pitched at the right level.

Article tags

Reader Comments

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Get anything free online illustration

Find free films, music, television, videos and software online

We show you where to find all the movies, music, videos, phone calls and software you’ll ever need online – and you won't have to pay a penny for any of it

Using Wizard to create a form

Create a good Base for your data

Databases may sound very dreary but they are behind almost everything we do. We explain how to go about starting one of your own using Libre Office Base

337-f3-lp

How to sort lists easily in Word, Excel and Open Office columns

Microsoft Office and Open Office word processing and spreadsheet programs have simple ways of sorting lists of data in tables and spreadsheets

Question & Answer

Q.How do I store musician and other information about...

> Read the answer

Q.Why can't my browser find the website address I typed...

> Read the answer

Q.All updates have been downloaded, so why won't Windows...

> Read the answer

Best deals on the web

img

Apple MacBook Pro (MC724LL/A)

£999.99- Buy it now

img

Sony Vaio VPCF23P1E/B

£679.98- Buy it now

img

Sony Vaio VPCEH1J1E/W

£349.99- Buy it now

Great benefits for subscribers!

Poll

Which is your preferred web browser

Jargon Buster

Computing terms explained in plain English

CAD

Computer Aided Design. Software used to create 3D models.

Great shopping deals from Computeractive