Page 38 - ModularV1.1 _c8_flipbook
P. 38
05 ADVANCED FEATURES
OF MS ACCESS
Your Aim
to learn about:
l Performing Calculation l Searching Records
l Sorting Records l Applying Filters in a Table
l Importing Data from Other Applications l Exporting Data from MS Access
In the previous chapters, you have learnt about the basic concepts of database and MS Access
2010. You have also learnt how to work with a table. This chapter introduces some advanced
features of MS Access 2010.
PERFORMING CALCULATION
You can perform calculations in MS Access by using the Totals command. The Totals command
allows you to perform different types of calculations like sum, average, maximum, minimum,
standard deviation and covariance. Follow these
steps to perform calculation in the table:
Step 1 Create a new table or open an existing table
in which you want to perform calculation.
In this case, we have created a new table
named Items.
Step 2 Click on the Totals command under the
Records group of the Home tab. A new row
with the text Total will be added after the last
record in the table. Performing calculation
Step 3 Click on the cell where you want to perform the calculation.
Step 4 Click on the down-arrow. A list of functions appears.
Step 5 Select the desired function. In this case, we have selected the Sum function. When you
select the Sum function, the sum of values appears in the cell.
Result after using Sum function
36 Modular (Ver. 1.1)-VIII

