How To Create Calculated Fields In Access 2010 Tables

If you've used previous versions of Microsoft Access you might be aware that you can only create calculation fields in queries and not in tables. The query can then be used in place of the table to create forms and reports which show the values of calculation fields. For example if you have a table with a list of staff, including dates of birth, you can create a query to show the same table and an extra field to show staff ages, calculated from the dates of birth. In Access 2010 that's all changed and now youcan create calculation fields in a table. This article describes how to do this with examples and summarises some key benefits.

The full article appears here:
http://www.microsofttraining.net/article-1738-how-create-calculated-fields-in-access-2010-tables.html

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