Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital
Date de publication: 2013/06/25
IBRAR AHMAD
par IBRAR AHMAD , ADMIN./OFFICE ASSISTANT cum I.T COORDINATOR , NAC INTERNATIONAL

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

Ali Albasri
par 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
par ختام 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
par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Concentrate on your work.

Utilisateur supprimé
par Utilisateur supprimé

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

Utilisateur supprimé
par Utilisateur supprimé

- 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