How To Use The Analyze Table Tool In Access

An experienced database designer knows there are certain rules when deciding what information to put in one table. People paid to clean up after them will know the huge problems mistakes often caused by sloppy design can cause. Take for example, a sales database. Each sale has some sale information such as sale date, sales person and sale value. Also recorded for each sale is the customer name and address. Now a novice user who has had little on or no training may well decide to put everything in the one table. This means that each time a sale is made the user must manually enter the full customer and salesperson details regardless of how many time this has been done before.

The full article appears here:
http://www.microsofttraining.net/article-999-how-use-analyze-table-tool-in-access.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com