O'Reilly logo

Access 2013 For Dummies by Ken Cook, Laurie Ulrich Fuller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 21

Analyze This!

In This Chapter

arrow Converting a flat file to relational tables with Table Analyzer

arrow Documenting your database

arrow 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:

check.png Convert flat files into relational databases automatically.

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

check.png 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required