Closed

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".

Cheers

Skills: Microsoft Access, Sharepoint

See more: 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

About the Employer:
( 0 reviews ) Glasgow, United Kingdom

Project ID: #17717624

12 freelancers are bidding on average £190 for this job

royalcalif

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 More

£20 GBP in 1 day
(57 Reviews)
5.6
alaeddindhahri

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 More

£200 GBP in 5 days
(65 Reviews)
5.7
donnyforu

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 More

£235 GBP in 2 days
(12 Reviews)
5.0
sabyasai1

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 More

£200 GBP in 3 days
(8 Reviews)
4.5
Shuchi144

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 More

£250 GBP in 4 days
(10 Reviews)
4.5
ananda1230

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 More

£222 GBP in 3 days
(6 Reviews)
4.1
Webxpert4u

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 More

£250 GBP in 7 days
(2 Reviews)
3.0
dionisiotumbaga

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 in 4 days
(3 Reviews)
2.9
rekhajshah

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 More

£250 GBP in 7 days
(1 Review)
0.5
paulodayto08

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 More

£100 GBP in 5 days
(0 Reviews)
0.0
bbrianokoyo

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 in 3 days
(0 Reviews)
0.0
sanyukta14

Hi, Give me one day to make POC for your requirement, after that you can decide to award me this opportunity. We are a team of SharePoint developers with experience of more than 5 years. We also have SharePoint Sol More

£211 GBP in 3 days
(0 Reviews)
0.0