Alright so it took me longer than I expected. Of course I did encountered some bumps that basically made me stop developing it and sorts.
Developing an app in MS Access may seem simple but without proper planning you may end up like me. Recreating the whole application from scratch.
First hurdle : the naming conventions, I got so mixed up with text1 and label99 that I had to restart the whole app and basically do what I’ve learned in school. It’s good to practice putting prefix for easy identification even on smaller projects, like putting txt for text boxes, lbl for labels, etc. Well, you get the idea.
Second Hurdle : 1 table for the whole project without any lookup tables. It’s clean doesn’t clutter much, easy to remember, but the problem is it takes a long time to load. It’s good at small projects but with a big project with a data entry, record viewer, reports, queries all accessing 1 table. it will soon grow big and will load up so slow. My Database loaded for 25mins total with 15,ooo plus entries.
Third Hurdle : Hubris. I thought that since this is MS Access it should be easy I can make that app in like 2 hours. I was wrong. Really wrong, I had to remake from scratch didn’t even make backups, no standardization, no naming conventions.. a shitload of mess.
Thank you for the Internet, I was able to make research on how to do this and that, like using dcount, dlookup, making queries and all that headache.
Thanks to a couple of sites, that been a good source of info, like Access World Forums, Jegworks.com, oooh and I even tried and tested Opengate Software’s UI Builder for MS Access – you should try this too, It can save you a lot of time instead of focusing on the UI you can immerse yourself in the back end of your application.What I’ve learned. Access is easy to use, but without proper planning, naming conventions, flowcharts, db relationship, minimal VBA knowledge. You’ll easily get lost with the unbound textboxes, wizards, reports that makes no sense. and button that don’t do anything. You won’t go far you’ll only get confused.
- Playing with Microsoft Access in A Civil Registry Application approach (jaren.cudilla.net)
- Help with Ms access tables and forms (daniweb.com)
- Automatically fill in textboxes in MS Access depending in combobox selection (community.spiceworks.com)
- Infinite Skills’ “Advanced Microsoft Access 2013 Training Tutorial” Teaches Advanced Concepts in Database Functionality (hispanicbusiness.com)
- Query Does not include specified expression ERROR (stackoverflow.com)
- Accessing Excel in Access (thorkolner.com)
- Working with the MDB File (pc.answers.com)