SO YOU WANT A CONTACTS DATABASE?

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?

  1. CREATING THE CONTACTS DATABASE
  2. CONVERTING MACROS TO VISUAL BASIC (VBA)
  3. SPLIT THE DATABASE INTO FRONT AND BACK ENDS
  4. CREATING A LOGIN FORM
  5. CREATING THE LOGIN CODE
  6. AUTOEXEC MACRO
  7. FINDING THE BACKEND IF IT GOES MISSING
  8. THE TEMPORARY TABLE FOR MULTI USER ACCESS
  9. THE SAVE CHANGES BUTTON – UPDATE
  10. THE SAVE CHANGES BUTTON – INSERT
  11. POWERFUL LISTBOX
  12. CUSTOM VCR BUTTONS
  13. ADDNEW BUTTON AND ROUTINE
  14. AFTERUPDATE ROUTINE
  15. COLOUR SCHEME/THEMES PICKER
  16. VERSION AND AUTO-UPDATE ROUTINE
  17. REPORT BUILDER AND PREVIEWER
  18. 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.