ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital
تاريخ النشر: 2013/06/25
IBRAR AHMAD
من قبل IBRAR AHMAD , ADMIN./OFFICE ASSISTANT cum I.T COORDINATOR , NAC INTERNATIONAL

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

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

Concentrate on your work.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

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
من قبل 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
من قبل 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
من قبل 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
من قبل Jayson Aglubat , Graphic Designer/Information Technology , Local Government

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

kamran bashir
من قبل 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.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

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

المزيد من الأسئلة المماثلة