TIP: Your best source of Microsoft Office Suite information is,

surprise, from Microsoft.com itself! You can learn about VBA code!

 

http://office.microsoft.com/en-us/access/HA010345581033.aspx?pid=CL100570041033

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.

The group name will appear only at the beginning of a new group or at the top of a new page if the group continues for more than one page.

 

http://www.accountingweb.com/cgi-bin/item.cgi?id=103794

Want to learn about Excel pivot tables? Start here.

A Pivot Table is a snapshot of your data. You can make a Chart from a Pivot Table. Many accountants use this method for manipulating their data.