Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Front end options & database design

Front end options & database design

From: <anasttin_at_excite.com>
Date: 1 Feb 2006 18:10:52 -0800
Message-ID: <1138846252.384739.179300@z14g2000cwz.googlegroups.com>


Hi,

I need to set up a generic table in Oracle that allows users to enter data that can later be retrieved in reports.

I was thinking of a 3 column table in this structure:

DATE,ITEM,VALUE figuring that you can store anything in this way because ITEM can be anything and you can have multiple instances of a particular value by having a new date.

Does that seem reasonable?

In any case, what are my user front end options? I was thinking a Microsoft Access database but its not ideal because not everyone here has Access?

Can you do it with Excel? Or what other options are there as a simple user front end to enter the data?

Thanks for any advice.

Kim Received on Wed Feb 01 2006 - 20:10:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US