10 min read
The Table Analyzer and Database Documenter
Two review tools: one suggests a better-normalized table structure, the other generates a detailed report describing an object's properties and relationships.
Field Notes: Two Built-In Reviewers
Table Analyzer — Database Tools, then Analyze Table — reviews an existing table for repetition problems, and can suggest, and even help build, a better, properly split set of related tables.
Database Documenter — Database Tools, then Database Documenter — generates a detailed report describing every chosen object's structure, properties, and relationships, genuinely useful for reviewing your own work, or for handing off a database to someone else who needs to understand how it was built.
More lessons in Microsoft Access · Next: Compacting and Repairing a Database · Previous: Linking to External Data Sources