Access Analyzer: know More About The Microsoft Access Table Analyzer Wizard Tool

Access Analyzer: know More About The Microsoft Access Table Analyzer Wizard Tool

You may not be aware that Microsoft Access has a collection of tools to help build, maintain and optimize your Access database and one feature is the Access Analyzer (or also known as the Analyze Table wizard).

Take a look at this well delivered video tutorial which is just short of 6 minutes and covers the power behind this wizard tool…

Access Analyzer: know More About The Microsoft Access Table Analyzer Wizard Tool

This video explains some of the pre steps used when importing external data into Microsoft Access. The Access analyzer tool then steps your through to create the table joins it suggests creating not just primary keys (for the unique ID – ‘one’ side) but foreign keys (for the ‘many’ side of a table join).

Once you have completed the wizard and included or excluded exceptions for mis-matched values, you can now manually add and tidy up additional tables maintaining RDBMS (a relational database management system) taking advantage of Microsoft Access’s rich features.access analyzer

Learning about the Access analyzer tool will take away the guessing games that inexperienced Access users may find when creating relational databases.

To learn more about Access relationships and other eBooks that I offer, check out my eBooks page. You may want to download my FREE eBook on how to import data into Microsoft Access to get your started.

SIGN UP AND GET FREE EBOOK
SignUp Now and Get FREE EBOOK in your inbox and Every Friday, we send out amazing Tips and Tricks to help you master Microsoft Access.

3 Replies to “Access Analyzer: know More About The Microsoft Access Table Analyzer Wizard Tool”

  1. The process that describes the splitting of tables into ‘one-to-many’ and ‘many-to-many’ relationships is one of the processes (or forms) called Normalization. This term may help you learn more about other aspects to creating your RDBMS.

    1. Hello Luke,
      Many thanks for your suggestion.
      I would be happy to write a review on my site here.
      I’m always interested in Access tools and utilities that add value to administrative areas of maintaining an Access database.
      Regards
      Ben

Leave a Reply

Your email address will not be published. Required fields are marked *