Computing.Net > Forums > Database > Free / cheap / efficient DB

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

Free / cheap / efficient DB

Reply to Message Icon

Original Message
Name: jefton5
Date: September 7, 2007 at 06:23:25 Pacific
Subject: Free / cheap / efficient DB
OS: XP Home
CPU/Ram: 448 MB RAM
Manufacturer/Model: Fujitsu Siemens
Comment:

Hi Everyone

First I want to say that I know absolutely nothing about databases except how to use an existing one. I've recently took a job at a new company and we are looking into the possibility of moving all our data into a database. I've looked into previous posts but could not find any specific recommendations.

My question: Does anyone have a recommendation for a cheap / free database that will be good for sales data etc. E.g. quotations, orders, previous orders, client details etc. All the basics really. But what would also be a big benefit is if I can find something that you can add the product you sold as well - like maybe a photograph of the last product sold etc. Is this even possible?

Thanks very much


Report Offensive Message For Removal


Response Number 1
Name: wizard-fred
Date: September 7, 2007 at 14:36:28 Pacific
Reply:

What you are asking for is not a database but an application. Sales or contact management. If you are willing to program, you can construct your own out of the numerous open source or free databases available. MySql is one.


Report Offensive Follow Up For Removal

Response Number 2
Name: seawatch1
Date: September 8, 2007 at 05:53:18 Pacific
Reply:

You could try OpenOffice's database called Base: http://www.openoffice.org/product/b...

Which has a data base. I'm not sure that you can use photos, but I assume you can as it accepts embedded objects.

File Maker Pro is relatively inexpensive and is very user friendly.

Microsoft Access comes with older Office versions, but you need a book to get you up an running if you're not real familiar with databases.

It usually takes more than three weeks to prepare a good impromptu speech.
- Mark Twain


Report Offensive Follow Up For Removal

Response Number 3
Name: jefton5
Date: September 10, 2007 at 05:31:57 Pacific
Reply:

Hey guys

Sorry about the late reply. Thanks very much for your advice. I'll go to the openoffice site now.

Thanks again


Report Offensive Follow Up For Removal

Response Number 4
Name: seawatch1
Date: September 15, 2007 at 14:00:18 Pacific
Reply:

Did OpenOffice work out OK for you?


I think that God in creating Man somewhat overestimated his ability.
- Oscar Wilde


Report Offensive Follow Up For Removal

Response Number 5
Name: jefton5
Date: September 17, 2007 at 01:19:31 Pacific
Reply:

Hi seawatch1

Sorry, my fault for not posting back sooner. I've just been looking at the OpenOffice suite really. I downloaded the whole OpenOffice suite. The Base does look good but so hard to configure. If possible, can you have a look at the Filemaker Pro database suite and tell me what you think of it?

Link
http://www.filemaker.com/solutions/...

There's a Business Productivity Kit also.

I find it hard initially setting up the database. Do you have any guidance on that?

Thanks


Report Offensive Follow Up For Removal


Response Number 6
Name: seawatch1
Date: September 17, 2007 at 06:07:54 Pacific
Reply:

Well, with any database, the hard part is setting it up.

You should probably lay out on paper what sort of information you need. Customer Name, Address, Zip Code, Phone Number etc.

The more columns you have, GENERALLY, the easier it is to sort and filter your data.

Before buying something I would go thru the FileMaker pro web pages and look at how their examples are laid out. File Maker Pro uses a lot of drag and drop which can save you hours of fiddling with your data.

You may also want to pick up an older book on Microsoft Access, almost any version, but one of the 'bible' type books and look at the early chapters on how to layout data so you have an idea of what you can and cannot do with data.

Databases can do amazing things and really provide you with really cool ways to look at your data, however, the most important part is to layout your data in advance. If you don't, you are going to have problems later.

As far as the productivity Business pack, I would wait until you have the basics down before you start trying to link everything to a web page.

The more you do at the beginning, the boring part, the more fun your database will be.

Larry

It usually takes more than three weeks to prepare a good impromptu speech.
- Mark Twain


Report Offensive Follow Up For Removal

Response Number 7
Name: jefton5
Date: September 17, 2007 at 06:47:51 Pacific
Reply:

Hi seawatch1

Thanks again for your valuable advice an guidance mate. And don't worry I won't just buy it. I'll probably first try something 'easier' as you pointed first looking into the MS Access route. And yes, for me the hard part is the initial setu as I'm sure it will be for most people.

I've worked with DATABASES alot in the past but only as a user thereof. I've never even thought of developing one myself.

One route I'm looking at is having a Sales Database with the usual features - client details, what products we've sold them etc. ne important thig for me - if at all possible - is if I can insert a picture of the products sold to the client for future reference. For instance if they need repairs etc. we'll know exactly what the have.

The reason for this is that we want to set our website up so that clients that fall under warranty might 'log' the faults with their product we sold them and then we can respond to it automatically etc. Well, more than that even.

Anyway not to take up too much of your time. Thanks very much


Report Offensive Follow Up For Removal

Response Number 8
Name: seawatch1
Date: September 17, 2007 at 08:24:44 Pacific
Reply:

OK.

Pick up a book on Access, any used one will probably do, but for a person just starting out, I would probably use File Maker Pro which will save you many hair pulling hours.

I use Access and a friend of mine has File Maker Pro and he could do everything we needed to do much faster than I could.

Make sure you contact your web site host to find out what database file types they accept first. You don't want to develop a full data base only to find your provider doesn't support that type of file on their web site.

I think that God in creating Man somewhat overestimated his ability.
- Oscar Wilde


Report Offensive Follow Up For Removal

Response Number 9
Name: seawatch1
Date: September 17, 2007 at 08:48:06 Pacific
Reply:

And you may want to watch this demo: http://www.filemaker.com/downloads/...

It will give you quick over view.

Larry

I think that God in creating Man somewhat overestimated his ability.
- Oscar Wilde


Report Offensive Follow Up For Removal

Response Number 10
Name: davidbrock
Date: November 4, 2007 at 10:22:25 Pacific
Reply:

Hi,
You can make your work much easier by using one of these advanced database tools:

http://www.outyard.com/Mall/Databas...

Hope I helped you,
David.


Report Offensive Follow Up For Removal

Response Number 11
Name: jefton5
Date: November 5, 2007 at 02:48:19 Pacific
Reply:

Hi David

Thanks for your advice. I'll have a look at it sometime today or tomorrow and post again.

Thanks


Report Offensive Follow Up For Removal






Use following form to reply to current message:

Not Logged In!

You will not be able to post.

Register | Login
   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Free / cheap / efficient DB

Comments:



Results for: Free / cheap / efficient DB

.db file
    Summary: Oracle, but there are others that end in .db. You can download Oracle XE for free. ...
www.computing.net/answers/dbase/db-file/10.html

There isn't enough free memory?
    Summary: I'm receiving the same messages - and when just creating a query with a tiny DB with one table. When switching between results view and design view I receive the message. Plenty of free memory, only 4...
www.computing.net/answers/dbase/there-isnt-enough-free-memory/331.html

ACT!6 Data dictionary
    Summary: Hello all, I have 2 databases in ACT!6 and I am trying to regroup them into one since I cannot have them both open at the same time. I have around 40-50 fields in each db and I am wondering if Act all...
www.computing.net/answers/dbase/act6-data-dictionary/163.html








Which MP3 player do you have?

iPod/iPhone
Zune
Something Else
None


View Results

Poll Finishes Today.
Discuss in The Lounge
Poll History






Data Recovery Software