what is the difference and similarity between Cell and Field in access ?
Answers
Total Access Detective finds data differences between tables and queries in your Access databases. The data can be from an Access database or any linked table. New, deleted, and modified records are detected. For modified records, the different fields are identified.
Results are shown in forms for you to view, export to a table in your database, or print. A powerful Combine feature lets you merge data from your two source tables into a new table in your database.
Compare Different Data Sources
Find changes to your data from:
Any two tables in one database (MDB, ACCDB, or ADP)
Any two SELECT queries in one database (MDB or ACCDB)
Any or all identically named tables in two databases (MDB or ACCDB)
Data Comparison Results
Keyed Tables
For keyed tables (so matching records are compared), these differences are found:
Records in one table and not the other (could be new or deleted)
Modified records with their individual field differences
The results are presented in these formats:
Records in one table but not in the other
A summary for each modified record where all the differences (no matter how many fields) are shown in a text field on one record.
A detailed field-by-field list of modifications, showing each field value side-by-side.
Unkeyed Tables
For tables without a key field or queries where the first field is not designated as the primary key, records are compared sequentially and the first record that's different is documented.