Customised RMA/Warranty Management using MS Access Template Database and/or Sharepoint Integration

I am looking for freelance support to take the initial customer service template that comes with MS Access and make adjustments that will enable us to use the database as our warranty returns database. This is currently handled on an Excel spreadsheet but could do with improvements. Additionally the basic data entry or lookup part should also work on our Sharepoint Foundation 2010 Intranet (hence the use of the MS Access Template as an idea, however we are not needing to use MS Access if everything can be achieved with Sharepoint alone).

The project centers around our Warranty Return process. If a technical advisor identifies a bigger issue that is worth capturing they add this to a spreadsheet. Should a return be required an incremental number is the unique identifier for the customer.

The current spreadsheet captures basic information such as source of contact, customer information (name, address, phone, email...) as well as the product and the customer reported issue. Once the product is returned the technical advisor goes through a number of quick tests to identify if it is a valid issue and then decides if it is returned, replaced, etc.

The fault code and description and the serial number are captures. Very basic reporting in the spreadsheet allow us to identify issues.

This speadsheet is difficult to manage and advisors make mistakes entering data. Additionally customer details should be kept in a separate database so they are searchable by previous cases, information etc.

When looking at the MS Access Customer Service template a lot of this information and functionality is already there.

What I feel like is missing for us to fully use it:

- a product database, also a database of related product issues. I dont know if that could be one DB or different ones. In the forms I would like to see cascading or dependent dropdowns so that technical advisors can find an issue very quick

- a "tests" database that lists all the tests bases on products.

- Added Reports to identify appearing product issues

- Changes to the input form. We dont have many repeat customers so the technical advisor would not go and create a customer first, to then look it up. I would like the New Case form to have all customer information entered (as well as lookup optional). When the form is saved this then writes a new customer entry into the customer DB.

- Changes to the Knowledgebase element: This should more act as "canned responses" pool where advisors can quickly look up and copy and paste common responses.

- A way to email or print an overview for the customer: unique identifying number, customer details, product issue reported, product tests done by staff, outcome of tests, decision of staff

- Changes to to New Case form to reflect these changes and make it user friendly.

For the start this would be it. I would be happy to receive quotes for this initial work and agree an hourly rate for all work that is "out of spec".


Keahlian: Microsoft Access, Sharepoint

Lihat lebih lanjut: customize ms access template existing data, inventory management vb ms access, ms access close database specific time vba, access templates for small business, microsoft access web app templates, access web app examples, access 2016 web app, microsoft access templates, access web app discontinued, access database templates library, access 2016 templates, ms access good database web based application, ms access gym database, ms access risk database, ms access roofing database, ms access sample database shop, ms access template data entry, outsourcing ms access db database, project inventory management vb ms access, school management system ms access

Tentang Pemberi kerja:
( 0 ulasan ) Glasgow, United Kingdom

ID Proyek: #17717624

11 freelancer menawar dengan rata-rata £188 untuk pekerjaan ini


I wish to discuss about the project. please pm me. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. Let me know the full Lebih banyak

£20 GBP dalam 1 hari
(62 Ulasan)

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL, SharePoint and VBA. I have read your project description and I'd like to he Lebih banyak

£200 GBP dalam 5 hari
(72 Ulasan)

This letter is to express my interest in your posting("I love pandas") on Freelancer for an experienced SharePoint Developer(SP 2010,SP 2013) It will be my pleasure if I can build this website for you.I have develop Lebih banyak

£200 GBP dalam 3 hari
(9 Ulasan)

Hello, I am a Senior Sharepoint solution architect with 16 years of vast IT experience.I have worked on more then 1000 sharepoint projects for the clients across the globe. I have read your complete job descripti Lebih banyak

£250 GBP dalam 4 hari
(14 Ulasan)

Hello, I am a senior Microsoft certified solution architect with 16 years of experience in top IT companies based in the USA,like Microsoft and Sandisk. All my life ,i have been managing software development proj Lebih banyak

£235 GBP dalam 2 hari
(12 Ulasan)

I am ready to take your MS access DB and will make adjustments if require to enable to use the database as warranty returns database. I can do it with with Sharepoint alone. I need to discuss in detail before starting Lebih banyak

£250 GBP dalam 7 hari
(6 Ulasan)

Hello , I have got your job posting on “Customized RMA/Warranty Management using MS Access Template Database and/or SharePoint Integration” and am interested to work in your project. I'm a SharePoint Consultant, exper Lebih banyak

£222 GBP dalam 3 hari
(6 Ulasan)

I have 10+ years of SharePoint experience. We can achieve this requirement by using SharePoint no need to use Access anymore. Migrate old data into the new system is part of this scope? as well data entry is part of Lebih banyak

£250 GBP dalam 7 hari
(8 Ulasan)

Greetings, I am interested in this project. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirements. Regards.

£190 GBP dalam 4 hari
(5 Ulasan)

Hi Good Day! I am Sharepoint Admin/Developer and PMO Analyst of Accenture for 6 years after I resigned and focused in freelancing. I can help you to complete this work in 5 days. We can use and utilize the sharepoi Lebih banyak

£100 GBP dalam 5 hari
(0 Ulasan)

Hello, I am very competent with MS Access and I can help with your task. Also, I can write additional SQL queries to come up with accurate reports for this task. Kindly hire me.

£150 GBP dalam 3 hari
(0 Ulasan)