Featured Post

TNTET 2017 BREAKING NEWS

TNTET 2017 BREAKING NEWS | ஆசிரியர் தகுதித்தேர்வு நடத்த அனைத்து ஏற்பாடுகளும் தயார்...ஓரிரு நாட்களில் முறையான அறிவிப்பு வெளியாகிறது...| விண்ண...

Tuesday, December 10, 2013

Perform Excel Calculations in Access

The Formulas option in Excel 2007 offers different financial, statistical, logical and functions to help you perform calculations. If you want to calculate sum, average, count, maximum, minimum, standard deviation and variance, FV, depreciation, NPV, IRR, you can use formulas option. If you want to find internal rate of return, you just use IRR function in financial function, then put value and you will calculate it. But to perform all these things in access is challenge.





It is however not possible to do such advance financial calculations in access. But still, we are providing some options in access which will be helpful to perform excel calculations in access.

1. Open ms office access 2007. Make table. Write your different accounting data. For example, you can should sales data or purchase data. Now, go to create option and click query wizard. By clicking it, a new query table will be made by system. Now, click sum symbol function in it. With this, you can perform simple excel calculation like sum, average, count , minimum, standard deviation and variance in it. See above screenshot and understand.

 2. In access, criterion option can be used as formula — it is a string that may consist of field references, operators (operator: A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.), and constants (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.). Query criteria are also referred to as expressions in Microsoft Office Access 2007. 

If you want to perform excel's advance formulas like NPV and IRR and others, you should learn VBA. VBA means visual basic application. In access, when you will click database tool, you should see visual basic in left side first option. By clicking it, you enter in it and use advance excel calculation in it.

No comments: