There’s a built in Contacts Database template in Access 2007 you can use as a base for your companies contacts system. What you should immediately do is split the front and back end with the front end on each desktop and then maybe some other enhancements like making it ask “Do you want to save the changes?”, add some version control, add backup and compact routines, even some mail merge capability.
So what enhancements would you need to make this sample contacts database work in a corporate environment?
- CREATING THE CONTACTS DATABASE
- CONVERTING MACROS TO VISUAL BASIC (VBA)
- SPLIT THE DATABASE INTO FRONT AND BACK ENDS
- CREATING A LOGIN FORM
- CREATING THE LOGIN CODE
- AUTOEXEC MACRO
- FINDING THE BACKEND IF IT GOES MISSING
- THE TEMPORARY TABLE FOR MULTI USER ACCESS
- THE SAVE CHANGES BUTTON – UPDATE
- THE SAVE CHANGES BUTTON – INSERT
- POWERFUL LISTBOX
- CUSTOM VCR BUTTONS
- ADDNEW BUTTON AND ROUTINE
- AFTERUPDATE ROUTINE
- COLOUR SCHEME/THEMES PICKER
- VERSION AND AUTO-UPDATE ROUTINE
- REPORT BUILDER AND PREVIEWER
- ADD BACKUP, COMPACT &Â REPAIR OPTION
PURCHASEÂ THE BOOK (Â£17.99) FOR TRANSCRIPTS, SUBFORMS, WORD, PDF & EMAIL
So that’s quite a lot then. Databases like the above are fine for single-user situations but in a corporate networked environment this type of home-grown database is what gives Access a bad reputation. Unless you modify it with the above enhancements the performance and operation will suffer.