Need help with designing and buildig an Access database quickly
Posted on 2004-11-02
I'd rather be developing this in ASP.Net but the client won' wait - they want it now nd they want it in Access. I'm building a simple database to manage several entities inluding badges, units, people, etc. I'm comortable developin in ASP.NEt but I'm not an Access guru so I need tips, tricks, or pointers please.
I'm looking for someone to tell me how to design my forms to use with a switchboard, or without, and end up with a simple little database that the end users can use as if it was a regular application with a user interface. I want it to be idiot-proof.
Specific example of what I mean:
I want to create forms that allow users to add,edit, and delete entities in any of about 12 tables. Instead of using a default form that Access generates, I obviously need to make some sort of custom form with only very specific capabilities and do things like hide the menu bar, etc. In other words, for example, I want a form that is used to add new people into the tblPeople table. But I want this form to do nothing else - make it a painfully simple form.
This is my question: How do I build these custom forms and are there "form templates" I can download to get this databse created even faster?
I hope this is enough to convey my question appropriately. Let me know if you need more detail and thank you for your help.