Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are the best and suitable ways to prevent data entry errors or mistakes?

what do you suggest to prevent any mistake occurrence during data input tasks?

user-image
Question added by Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital
Date Posted: 2013/06/25
IBRAR AHMAD
by IBRAR AHMAD , ADMIN./OFFICE ASSISTANT cum I.T COORDINATOR , NAC INTERNATIONAL

KEEP UR ATTENTIONS100% ON WORK WHEN U R DOING YOUR WORK

Ali Albasri
by Ali Albasri , Human Resources Director , BRP Constructions and civil engineering company, BRP Factory.

focus on the reading, review all before confirm, take small rest with coffee or tea.

ختام almanaseer
by ختام almanaseer , مساعد مبرمج\مدخل بيانات , وزارة الصحة

من الصعب عدم حدوث اخطاء لكن التقليل قدر الامكان من الاخطاء وذلك التركيز والانتباه وعدم العمل في جو ازعاج او مكتض بالناس وخاصه المتحدثين وعدم العمل وانت تعبان او مرهق Difficult but mistakes do not occur minimizing mistakes and focus and attention and not to work in an atmosphere nuisance or Moktd people, especially non-speakers

Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Concentrate on your work.

Deleted user
by Deleted user

This would depend on the tools being used.
If data is captured through technologies, then exported to any data files, an aggregate checking should be done to compare frequencies of both output.
And if your very much familiar with how your data would look like, and achieve different result in your aggregation, then you can possibly caught an error.
When data is entered manually in a database, SQL is a very useful tool to check for errors.

Fahad Hussain
by Fahad Hussain , Asst. Manager Production Planning , Yunus Textile Mills (PVt.) Ltd.

* Data validation is awesome tool in Ms Excel to shorten the human typo errors.

Javed Iqbal
by Javed Iqbal , Director , Randhawa & Co

Lock the fields for unique values.
Put validation checks on data at application interface.
Be vigilant during data entry

Shiraz Ahmad
by Shiraz Ahmad , IT Manager , Habib Bank Limited

1) Put validation checks on data at application interface before submitting data to storage..2) Apply contraint checks at DB level to ensure data integrity.

Jayson Aglubat
by Jayson Aglubat , Creative Artist , Sadeem International Co.Ltd.

familiarization of keyboard and review all the data input using Ms word review or excel..

kamran bashir
by kamran bashir , Assistant financial manager , Verage Ltd

One of the powerful features in excel is data validations.You can set up different types of validations on data entry.Secondly, you can use conditional formatting to highlight any deviations.Thirdly, you can use trace changes feature available in excel whereby an independent manager will review you data for a final check and would accept all the right changes and reject the ones that are not necessary.Finally, you can lock different sections of a worksheet to avoid people messing about with irrelevant sections.Try using formulas and excel automation features where possible.

Deleted user
by Deleted user

- Avoid stress and don't do work in a hurry.
This is the main cause of errors.
- Create a good work environment, keep you office in order.
- Use validation techniques.
- Use quality control procedures.

More Questions Like This