I want to create m s access database for tracking payment transaction and collection and bank balanc

Occasional Visitor



i am new to the ms access, i want help for create the database where i want to trace fund allocated date wise , fund remitted on date wise and balance fund of that project, also fund received from main branch.

kindly do the needful.





2 Replies



Arnel is right. You can start with some examples, such as that template.


I would also recommend you invest time learning how relational database applications work. If you plan to use Access, then you MUST understand relational database design. There are lots of resources to help you do that, including many videos on YouTube and elsewhere.


The single most important concept you must learn is Normalization, the design principle for relational database applications.