Database "Frontend" for Access or Excel? Like Genifer was to Dbase IV

Long time ago I used Borland DBase III and DBase IV. I am NOT a programmer. I DO need a fairly simple but elegant database. I don't want to take the time to learn Access or become proficient in Excel. Is there available a "drag and drop" type of frontend for Access or Excel that I can just specify number of fields, types, length and if they are indexed or not? Also it should be simple to place the fields wherever I need them. This would be used for "simple" databases of less than 20 fields and under 3000 records. Can anyone recommend a VERY VERY easy to use frontend designer and report creation piece of software for this purpose. PLEASE remember that I do NOT want to do any programming. I want to design on paper. Create by filling in the blanks, moving fields where I want them and begin to enter data. Possible? Mary
Need -a- ClueRESEARCHERAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris BRetiredCommented:
Anything is possible. If you want an outcome without input, hire a database designer to build it for you. If you want to do it yourself, you can build a simple Excel spreadsheet with labeled columns and data and import this directly into Access to create your first database. Simple queries and reports follow pretty easily, but some time in the help files or a beginners book will be required.

Chris B
thenelsonCommented:
You can link an Excel spreadsheet in Access.  In Access, Goto file, Get external data, Link tables.  Change files of type to Excel, Locate and select the Excel spreadsheet.  Follow the wizard.  Now any changes done in either Access or Excel with show up in the other.

As far as report generators in Access:
http://www.dbxtra.com/
http://www.intelliview.com/index.php
http://www.aadconsulting.com/ezplusoff.html
Chris BRetiredCommented:
If you would like to do a design on paper - well a word doc, and email it to me, I will build you a quickie as a starting point no charge. After that it is up to you. Click my username  after "Comment from" to see my email address.

Chris B
thenelsonCommented:
Also look at Ezy Access 2000:
http://www.aadconsulting.com/ezacc2k.zip
"Access is intimidating for new users and the learning curve is steep. Here is a new tool that makes using Access a WHOLE lot easier: an Access database for retail MS Access that lets you easily create Access databases with little or no knowledge of Access."
cquinnCommented:
Access has table and screen design wizards that you can use to get you started and create simple databases quickly

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.