Microsoft Support Number OR Call Toll-Free @ 1-844-478-2887

Thursday, August 19, 2010

How to Create Calculated Fields in Access 2010

Overview: You can manipulate data fields in many ways in Access 2010. You can apply constraints, change data types, create relationships and so on. You may also find that creating calculated fields in Microsoft Access 2010 is of the great use. With it you can easily calculate field values based on other field's data in real time. This tutorial is to tell you how to create calculated fields in Access 2010.

Software you’ll need :

* Microsoft Access 2010
* Microsoft Office 2010

This is a guide to create calculated fields in Microsoft Access 2010.

Step 1. Launch Access 2010

First you need to launch Access 2010, and then go to Create tab and click on Table.
How to Create Calculated Fields in Access 2010-open

Step 2. Make a simple marks table

We will make a simple Marks table, carry marks of students in different courses and Total field, contain total marks. Just right click Table1, and click Design View.

How to Create Calculated Fields in Access 2010-marks table

Step 3. Name the table

Now you need to enter an appropriate name of table name and click OK.

How to Create Calculated Fields in Access 2010-name table

Step 4. Select Number as data type

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

How to Create Calculated Fields in Access 2010-data type

Step 5. Calculated should be selected

Change data types of each course field to Number, except of ID and Total field. Under Total data type list options, select Calculated.

How to Create Calculated Fields in Access 2010-calculated

Step 6. Add all the marks

Now Expression Builder dialog appears. 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.

How to Create Calculated Fields in Access 2010-marks

Step 7. Close the marks field and save the changes made

From navigation pane, you need to double click the table and you will open it in data sheet 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.



Source:- http://tutorial.downloadatoz.com
Post a Comment