Access Database Project

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.

Attached file

Compétences : Microsoft Access

en voir plus : access database project, project access database, access project database, services database, resource equipment, ram tool, microsoft excel group, microsoft excel consulting services, microsoft excel consulting, microsoft access consulting, l2, consulting excel, access group, access database services, blue host, freespace, market surveys, host project on, file backup tool, excel consulting, develop database, database project, backup database, access database, excel surveys

Concernant l'employeur :
( 3 commentaires ) Roseville, United States

Nº du projet : #1684593

Décerné à:


A number of years in IT SysAdmin and experience in MSAccess. Check my profile and your personal mailbox.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 25 jours
(2 Commentaires)

17 freelance font une offre moyenne de $930 pour ce travail


MS Access expert here please have a look on my profile. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(38 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(21 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(29 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(5 Commentaires)

I have experience in this project, I am very interested in this project, very happy to work with you in this project

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 13 jours
(10 Commentaires)

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]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(3 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(3 Commentaires)

Please see attached file. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)

Hi there, Check out my reviews to evaluate me. That's it. Thanks and Regards, ABBASITECH (IT SOLUTIONZ ISB)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

Hi, Ready to start. Check PMB please.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)

Hi Iam expert excel vba developer. See the attached file in order to start the project. kevin

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(0 Commentaires)

I have a message for you in PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

Dear Sirs, I can't find ant attachment in your project details, please check my private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)