// 5 Ways To Stop Duplication

Clean Up Your Data

  1. Talk

Talk with other staff members. This is important to make sure you understand what data they are collecting, once you understand what data other staff members collect then you can adjust your data accordingly to avoid duplication.

  1. Agree

Agreeing on fields that work for all parties when collecting data is a simple way to stop duplication. This stops unneeded data being stored, an example of this would be having a column of data for each field in excel. If the fields are agreed on universally, it will drastically reduce the amount of data in the columns that are duplicates or unneeded.

  1. Repetitive Data

This is working out each field that need to be entered multiple times to stop you collecting the same data several times. Examples of this include customer details, stock data. Information that can be easily entered multiple times can be addresses, contact numbers etc. Having things such as “Address 1/Address 2” could stop this quite easily.

  1. Unique Codes

Having a unique code allows the odds of a duplicate not being possible. This is done to stop the margin of user error when inputting new details. An easy example of using unique codes is having one generated for a new customer. The customer Paul Jones could be given JONES01, but if another customer with the surname Jones is added, the previous number can be coded to give a +1 with whoever has the same surname giving the next Jones a code of JONES02.

  1. Relationships

This is using your unique codes to link to the related data, see the example below.

// Drop us a line! We are here to answer your questions 24/7


// our clients

We are Trusted
Throughout Leicestershire

Emilia Clarke
Vision Windows
"We needed a brochure website, which Amsoft kindly did for us. We wanted some branding too, so Amsoft created a new logo and designs for our van. Ady was very helpful throughout the whole process. We look forward to working with you again in the future. Thank you."
Emilia Clarke
Label Apeel
"From the moment that you call Amsoft and get them involved, Amsoft use their, can-do-attitude, to tackle the problem. Working with Amsoft for over 15 years, they have created many time saving database solutions to minimise our repetitive tasks. I would definitely reccommend Amsoft."