Understanding Primary And Foreign Keys In Microsoft Access

Access is designed as a simple way to build databases for people who are not necessarily technically minded. You do not have to learn an extensive and complicated coding language to create or manage the database. It has an advantage over excel as statistics can be outputted along with reports at the touch of a button via a professional front-end you can create through the use of simple wizards. It is far easier to manage and protect the data in Access than in Excel and can provide a professional front end to your data allowing complete data entry control. There are a few concepts it is important to understand before designing and building the database. One such concept is the use of Primary and Foreign Keys.

The full article appears here:
http://www.microsofttraining.net/article-788-understanding-primary-and-foreign-keys-in-microsoft-access.html

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