Question

Faulty information gathering usually adversely affects the decision-making process. Discuss ways of ensuring that faulty information is not gathered and how to solve problems when faulty information has become part of the overall information database.

Answer 1

database: it is structured collection of records or data.(used to store large amount of data,allows easy access to data)

consequences from improperly collected data include:

1) inability to repeat and validate the study.

2) compromising decisions for public policy.

3) misleading other researchers to pursue fruitless avenues of investigation.

4) distorted findings resulting in wasted resources.

how to solve problems when faulty information has become part of the overall information data base:

technology is designed to minimise errors and buffers the consequences of errors by:

Eliminating error and adverse events.

Reducing occurance of errors

Detecting errors early , before injury occurs.

Mitigating the effects of errors after they occur to minimise the injury.

Mental Technics to rectify database faults:

1) restore the database from a backup file.

2)delete the .ldb file that is auto created by the jet database.

3)use the JET COMPACT UTILITY that has been specifically designed to rectify minor faults in access database.

4)remove all complied VBA code.

5)use the built-in access 2010 COMPACT& REPAIR feature.

Open MS access and go to database tools ->compact& repair database.

Locate the corrupted database file and click on OK.

The selected database file will be rectified on completion of the process.

6) If even after all the above techniques,the database corruption persists, the recommended solution would be to buy a premium quality third party access database repair software or else send database to an access repair company.