How to Make a Formula on Database

Hi guys..

Finally I can share with you again. Do you still remember that I have posted about How to Make Database Using Microsoft Access? And in this article I wanna share about How to Make a Formula on Database.

I hope you still remember in the last article we made database to input some information/data likes a test report of student, further more we are not only input those data, but we also can know the average value which is gets by students.

Ok let's check it out.

1. First, open the database file which is has been made by yourself from this tutorial, click Design View.

You can add the Field Name with Total or Average

2. Change the Data Type on Total (Jumlah Nilai) and Average (Nilai Rata-rata) into Calculated. Because we are going to input the formula.

3. For Total's Formula we add all the subject for example, Physics, Chemistry and Biology.

And the formula for Average value (Nilai Rata-rata) we have to input the Total and divided with 3, because the total of subjects are 3.

4.  After that we move to Datasheet View.

In the Total (Jumlah Nilai) and Average (Nilai Rata-rata) columns have been filled automatically, so we don't have to calculate manually.

It's easy to make a formula on database. Thank you for reading this article and don't forget to read another article in this blog. I'm sorry if there was a mistake :D