asked on

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

Chris B

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

thenelson

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

SOLUTION

Chris B

membership

This solution is only available to members.