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.
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.
A number of years in IT SysAdmin and experience in MSAccess. Check my profile and your personal mailbox.
17 freelance font une offre moyenne de $930 pour ce travail
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
I have 15 years exp designing custom databases in access. I can build the database you need. I am attaching a sample of a database I did. Thanks Donna
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 Plus
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. Plus
I have experience in this project, I am very interested in this project, very happy to work with you in this project
Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]
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.
Hi there, Check out my reviews to evaluate me. That's it. Thanks and Regards, ABBASITECH (IT SOLUTIONZ ISB)
Xala Consultants a Norway based ICT firm, established in 2006, is one of the leading providers of end-to-end IT solutions and services to a variety of clients across the globe. We are bidding for this project and c Plus
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 Plus
Dear Sirs, I can't find ant attachment in your project details, please check my private message.
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 Plus