Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Front end options & database design
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