Create Calculated Fields In Access 2010

In Access 2010, you can manipulate data fields in many ways by applying constraints, changing data types, creating relationships and so on, but creating Calculated fields would be of great use, as you can easily calculate field values based on other field’s data in real time. In this post we will guide you through the procedure of creating a Calculated field, which will take values from other fields to evaluate result.

To start out with creating calculated fields, launch Access 2010, navigate to Create tab and click Table.

We will be making a simple Marks table, carrying marks of students in different courses and Total field, containing total marks. For this right-click Table1, and click Design View.

design view 1

Enter an appropriate name of table name and click OK.

marks

Start entering field names, i.e, name of courses and under Data Type, click drop-down button to select Number as data type.

data  type number

Change data types of each course field to Number, except of ID (which is unique identifier) and Total field. Under Total data type list options, select Calculated.

calculated field

It will bring-up Expression Builder dialog. For illustration we will be adding all the marks secured in different fields in Total field. For this start entering all the field names enclosed in square brackets, separated by plus sign. Click OK to continue.

calculated field 1

Now close the marks field and save the changes made. From navigation pane, double click the table to open it in datasheet view. Start entering marks obtained and you will see that the on filing out one complete record, Total field will add up marks obtained in corresponding record.

datasheet view

You can also check out previously reviewed guides on How to export Access 2010 table to XML Data file & How to Export database Table to Plain Text in Access 2010.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

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