“Manually comparing databases, even small ones, is not an easy task. The good news is that several comparison tools are sold by third-party vendors for comparing the contents and structure of Access databases. The Microsoft Office MarketPlace on Microsoft Office Online features several such tools. Visit the Database management section of the Office MarketPlace to check out the currently featured database management tools.”
From MS Access Help: “Hide duplicate data in a report “
Hide duplicate data on a report with only sorted records:
1. Open a sorted report that might contain duplicate values in Design view.
2. Select the text box that might contain duplicate data and click Properties on the toolbar.
3. Set the HideDuplicates property to Yes.
In a text box for which HideDuplicates is set to Yes, Microsoft Access prints a value in the first record in which that value occurs and, if records with the duplicate value continue onto another page, at the top of a new page.
Hide duplicate data on a report with grouped records:
1. Open a grouped report that might contain duplicate values in Design view.
2. Move the text box for the field you're grouping on from the group header to the detail section.
3. Select the text box and click Properties on the toolbar.
4. Set the HideDuplicates property to Yes.
5. Remove lines and all other controls from the group header.
6. Double-click the section selector of the group header to display its property sheet.
7. Set the Height property of the group header to 0.