Good database program

Quote:

---

Originally Posted by stooge

Im a DB developer (in SQL and Access) Cheers,

---

Hey, Umm, Stooge,
Are you near me?:angel:
I dabble in access but want to learn more to make my 'homemade' databases actually work properly :mad:

Ralph

Ralph, geographically im not near you (Hobart) but hey, in the world of internet everyone is close :)

The secret to a a DB working properly is a good thought out DB schema, understanding what information you want to colect, why you want to collect it and the relationship between information. This then determines the schema, ie, what tables you need to create and within those what fields and field types.... *****, DB stuff is not that complex once you have the basic understanding.

So what do you need to know Ralph?

Cheers,

Carlos

Quote:

---

Originally Posted by Ralf_the_RR

Mick,

I reckon Excel could do what you want.

Look up:
Filtering,
Conditional formatting,
NOW() or TODAY() function.

---

why reinvent the wheel, for 99 bucks radix does it and more all ready :P

Quote:

---

Originally Posted by incisor

why reinvent the wheel, for 99 bucks radix does it and more all ready :P

---

Why buy a program to make a rounder wheel.
He has Excel!

If it's a flat table and all he is doing is making an inquiry (filter), then he already has the equipment.
It's just applying more features and getting more out of Excel.

I'm not saying that Excel is the ultimate database program, in fact it's far from it. The data he wants seems very simple, and a full on relational database will certainly do it, but is realy not required.

Quote:

---

...who can cost effectively write me some database software to host on my web site

---

"website"

I think that he wants to make it available via his website, so either he stays with FileMaker (which has an intuitive GIU front end) and publishes the db to the web in one stroke of a mouse, or he uses a CMS with a contact module. Both are very easy and presentable over the 'net.

Our company is currently evaluating the Application Express (actually I am the evaluator :D ) and I have just got a presentation from Oracle regarding the Oracle Application Express 2.2. It's worth to have a look in that.

http://www.oracle.com/technology/pro...ess/index.html

The Application Express (known as HTML DB ) is free of charge from Oracle which can be used as a front end tool for Oracle Express DB.

Cheers,

Greg