I am new to Microsoft Access. Please me on how to build Accounting soft with it

I think you have an unrealistic expectation of how a site like this works. You are asking for a tutorial on how to build an accouting system using Access. That's just beyond the scope of a site like this. If you have specific questions as you develop your system we can help with that.

But you should take some courses in Access development before you start tackling a project like that.

However, if you need an accounting program, you might look at Quickbooks instead of trying to build your own.

I think you have an unrealistic expectation of how a site like this works. You are asking for a tutorial on how to build an accouting system using Access. That's just beyond the scope of a site like this. If you have specific questions as you develop your system we can help with that.

But you should take some courses in Access development before you start tackling a project like that.

However, if you need an accounting program, you might look at Quickbooks instead of trying to build your own.

I agree with ScottGem on this one. Access is a Database Management System, not accounting software. It won't do calculations other than sum, average, count, min, max. It just stores related information. I was trying to think of a SQL statement that would calculate and I can't offhand. I don't think there is syntax. Relational Algebra, like sum, etc. that's it. Having SQL knowledge helps to create these relations.