All individuals, companies and organisations can benefit from the functionality and results in using the Data Consistency Checker.   This easy to use; but vital data application solution will allow you to improve the performance of your data processing. You will be amazed at how effective its performance really is, and most importantly, you will see how easily it allows you to increase the efficiency of data importing by checking these areas and returning any discrepancies.

The main features of the Data Consistency Checker are:

• Greatly Increase the accuracy of your clients data improving Data Management.
  
• Excel Import Spreadsheet a loading process, that takes all of the columns and rows then assigns a data type if possible (reserved words).
  
• Find and Replace when any issues have been returned this will allow the user to quickly update large amounts of the same data (without going into the spreadsheet and running the built in find and replace).
  
• Discovery or Pattern Matching this will find words or data types that match a set pattern that can be set by the user.
  
• Reserved words this will be functionality allow the user to assign similar words to mean the same i.e. e- mail, email, e-mail, electronic mail (we will code a large majority of these for the user).
  
• Checks to see if the imported excel worksheet is a valid one: correct tabs, is an excel file.
  
• Checks for missing data: no blank rows or columns unless specified.
  
• Checks the data consistency: the data type is as specified for the row/column; are there any spelling mistakes, redundant data, duplication.
  
• Checks for unique values: data from one column must be the same as specified for other rows/columns (primary/foreign keys) - see Unique Checks image.
  
• Checks to see if foreign keys that are set as orphan records are not shown.
  
• Data Consistency Checker user guide with these added features in the form of a Help section

The Data Consistency Checker is due for release early 2008 - go to the Data Consistency Checker website to find out more!