Wiley.com
Get technical support for this product Print this page Share

Access 2010 Bible

ISBN: 978-0-470-47534-8
Paperback
1392 pages
May 2010
List Price: US $49.99
Government Price: US $25.49
Enter Quantity:   Buy
Access 2010 Bible (047047534X) cover image

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
3 Errata in text
When in Design View for a Table, you will notice a data type selection called Calculated. This data type was introduced with the release of Access 2010. With Calculated type fields, you can build mathematical operations, textual evaluations, or any other calculation directly into your table.

This data type is widely considered to be a horrible addition to the available data types in Access Tables.

Tables, by their very nature, are designed to store raw data. The job of performing calculations is traditionally left to Queries or VBA code. This allows for the separation of the data layer and analysis layer. This separation data and analysis is one of the strengths of Access. It allows for transparency and confidence in data integrity. When you look at the data in an Access Table, you can be sure that the it is in it's purest, most raw form.

The introduction of the Calculated data type completely goes against this paradigm. With a Calculated field, you are locking in a calculation that could be wrong, that could be changed over time, or that could cause errors in later analysis.

We highly recommend you stay away from Calculated fields.
18-Dec-15

Related Titles

More By This Author

Microsoft Access

by Laurie A. Ulrich, Ken Cook
by Alison Barrows, Margaret Levine Young, Joseph C. Stockman
by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison
by Allen G. Taylor, Virginia Andersen
Back to Top