The best point to start any journey is at the beginning.  
Start with the beginning courses and follow them in order learning as you go.  VBA is covered starting in the Developer courses.  If you don't have a good base knowledge you will not understand the Developer.  You have to learn to crawl before you can walk or run.
There is the issue in addition of language barrier.  Your posts may make sense to you but they are not understandable as to what you are asking so far.

The Amortization template is not meant to just jump into and learn with out that base knowledge I spoke of previously.

i want to learn append date through vba , set with related record, in loan amortization when click on apply payment , the result is value set in amount paid filed, with calculation wise more then installment amount set next row, only this code i want to learn , i don't know what u use in this database ,either VBA Or Either Query, show please help me

please teach me payment set append query in loan amortization

Append Queries are covered in Expert 14.
Also see SQL Seminar Part 2.

Amortization Seminar.

i know basic append query but ,u use in loan amortization on click event payment setup, i learn this type of query , like more then value , divide and set ex 10000 paid and value is 2000 its set separate filed ,like this append query