I'll explain in brief. My wife works in pharmaceuticals industry. She serves a function in a department called regulatory cell. Sometimes, she discusses some problems at work with me. Here is the case (based on what she told me, I have not seen):
1. There is a particular document which is issued to administrative bodies.
2. They (She & Her Colleagues) prepare a dated Word document for this purpose based on product, customer and admin body to be addressed. The format is fixed for each admin body.
3. The Word copy thus created is stored in a folder for future reference.
4. A log is maintained manually in Excel which shows:
Product (s) | Customer (s) | Customer's Addresses.| Authorities | User | Date
As it was apparent there are (will be) glitches in step 3 and 4. So I suggested they contract a software solutions provider to create a program to handle precisely. I do not know what brewed in between but they got a program at place but it is clumsy behemoth and have to use 2007 office. That set them little back as the user interface is changed.
So when at home, when we discuss sometimes it seems to me:
1. The persons who interpreted the requirements from her side were not exactly knowing what they wanted.
2. The software solutions people misinterpreted some part of it.
So the whole project has gone awry. I want to take it up as self improvement program (since I had suggested it) to improve my programming abilities with VB. There is no "official" pressure and deadline.
I hope to pick up some valuable advice as to how to approach it? Right from choice of application: Word, Excel, Access or combination etc.