Looking to have an Access Database designed that can do the following.
Overview: Mytech is an IT consulting firm that provides IT infrastrucure and Managed Services to the SMB market. We are looking to develop a tool that we can use to assess our customers\prospects infrastructure\reources on a reoccuring basis (Quarterly) and compare to a standard that we have developed.
Defitiions:
Blue Standard - Is a standard that will be used to compare and rate the customer current state against the defined standard.
Category - Like equipment that is group together. Example (Host Servers, Virtual Servers, Workstation, Network, Services, Applications, Backup etc) each customer resource will be named when added.
Assest - An assest is child of the catgegory. Assests will be added by category. Each Assest will be given an ID.
ID - An ID is created when an assest is added.
Component - A component is a child of the assest based onthe category of equipment. Each category will have defined components based on its category type. Example (Category = Host Server: Components (Manufacturer, Host OS, Age, Warranty, Resources)
L1 Component - An L1 component is a child of a Component. Not all components will have L1 components. L1 Components may be added if the Blue standard changes and is required for evaluation. Example (Component =Reources: L1 Component (Disk, RAM, CPU)
L2 Component - An L2 component is a child of a L1 component. Not all L1 components will have L2 components. L2 Components may be added if the Blue standard changes and requires it. Example (L1Component = Resources: L2 Components (Disk, RAM, CPU)
L3 Component - An L3 component is a child of a L2 component. Not all L2 components will have L3 components. L3 Components may be added if the Blue standard changes and requires it. Example (L2Component = Disk: L3 Components (Config, FreeSpace)
Survey\Evaluations - Each customer will have multiple surveys\evaluations. Typically performed quarterly.
Each Survey will have a scoring systems that will be used to evalute the current state of the client.
Score will calucated by the lowest number for any Component, L1, L2 L3. and rolled up to the categorey level. Survey will need to retained
Please se attached file for more information EXCEL. It wil give an idea of my concept.
HI,
I m best expert in Analysis and design and in MS Access.
I have design and developed complete systems using MS Access.
Plz check PM for demos
Dr. Hussien Sharaf
We would propose a more involved solution based on recursive programming to cover the current business need in a totally flexible way allowing the application to work not only in the dimension of the hard coded "1 to 3 children" but "1 to N".
Hi, I have 20 years experience in applications development using Access and Excel. Please see feedback. UK based native English speaker with good communication skills. Initial thoughts on table relationships attached. I would like to do this. David
Hello. I am an MS Access expert with a UK BSc. Computing degree, and over eight years of professional IT work experience. Please refer to my private message for further information on my bid. Thank you. Kind regards.
Hello, I am very much interested on your project. I have read your requirements and I am quite confident that I will be able to get your work done within the given time.I am very keen to discuss further. You can reach me at any time on online but make sure you notify me. Thank You Very Much Indeed.
Hi,
We have reviewed the details and clearly understand your requirements. We have more than 13 years experience in database designing & development. Our main expertise are in MS Access, MySQL and MSSQL. In past we have provided database and software development solutions to JPMorgan Chase, Bayer, and Siemens. Please review the details at our parent company Imptrax Corporation Website.
We will provide you the solution as per your requirement. As you mentioned that there is Excel file attached but we didn't found any, please provide us that file as we like to review it.
We are quality database solution provider in MS Access and currently we would like to go over your project in more details to better understand it. So let's discuss it in more detail.
We are ready to start the project immediately only need is your confirmation. Please feel free to contact us, don't hesitate if you have any query.
Looking forward to hear from you.
With Warm Regards,
GuruTrax Business Team