Posted 27 August 2009 - 01:08 AM
I work for an alarm monitoring company and I want to design a database that would include all of our customers (about 350). The information that I need to track includes user passcodes (in some cases up to 15 per account). The real reason that I would like to do this is that we have multiple paper copies to fill out and I would like to alleviate that. The biggest thing that I am concerned about is tracking changes to those accounts. I need to be able to assign user names to everyone where I work (about a dozen), see all changes any user has made or just simply find the change and when it was made.
I'm also wondering if it would be possible to update the database based on changes made in the alarm monitoring software (although I fear that task would not only be above my capabilities but impossible to get through the red tape).
I only have a basic understanding of Access (what our company uses) and I am wondering if it is even a good idea for me to bring up. I am a quick learner but I also don't want this to take forever.
Comments, questions, and ideas are all appreciated.