Access 2013 For Dummies

Chapter 21

Analyze This!

In This Chapter

Converting a flat file to relational tables with Table Analyzer

Documenting your database

Fine-tuning your database with Performance Analyzer

The Access Analyzer tools promise to help you set up, document, and fine-tune the performance of your database. Sound too good to be true? Well, like most software tools that promise the blessings of automation, the Analyzer tools do some things well — and others not so well.

Here is what the Analyze tools promise to do:

Convert flat files into relational databases automatically.

Document the database and all its parts (including tables, queries, forms, and reports).

Analyze the structure of your tables to make sure everything is set up in the best possible way.

So which Analyze tool makes good on its promise? That would have to be the Database Documenter. To do manually what the Database Documenter does ...