Loan System

**delta** · 02-06-2023, 12:39 PM

Sir,
I want to create loan system in MSAccess. I am not getting idea to setup for daily routine work flow.
I hope you will support me.

Let me explain :
There are housing complex group. This group will be in 18 different places. Each one have name as : Apple1, Apple2, Apple3 so on... upto 18.
In each group there will be 20 headcount.
An organisation is giving loans for this 18 grups. Each and every group will apply for loan. Loan will be not more than hundred thousand dollars. Each one can take loan as follows :
One's saving should be 1/3 of loan amount the required. For example one person have 10,000 dollars in Organisation. In this case can apply for 30,000 dollars.

Every person have to go to Organisation to pay not less than 200 dollars each week. In the same time he/she can pay amount more than 200 dollars.
The one who took loan should as repayment 1/10 (one by ten) each month by paying weekly basis totally four times in a month.
In MSAccess there will be 3 items :
- DEPOSIT
- LOAN
- REPAYMENT
Please remember again : In case of a guy taking loan his fund should be there 1/3 of loan amount applied.
- required person will go to organisation every week to pay part of the loan repayment he took.
- some people will go to organisation every week (the one who need loan)
- whenever somebody want to deposit amount again and again he can deposit any week/s or any month/s.

Once I check I want uptodate report after auto calculation along with data base.
In case of any further explanation required I will write to you.

From my end :
- Want to get full weekly, monthly, yearly report of DEPOSIT, LOAN, REPAYMENT and balance for single person

out of each housing complex. I mean I want to monitor seggregated account system.

Awaiting for reply.

**Micron** · 02-06-2023, 01:53 PM

Not sure what you expect from here. I don't pretend to speak for everyone but for the most part we're here to help you when you get stuck or guide you to the information pertaining to your specific issue or question. We don't do homework as a rule, and we don't build full blown applications for free. If you want guidance (links) to a lot of database subject matter I can provide that to get you started.

**delta** · 02-06-2023, 11:51 PM

Yes Micron. I agree. What problem I am facing is I have all data. I know some MSAccess. But I do not have knowledge in full. As you said I need I need links as guide to lot of database subject matter and related to the problem I am trying to solve. First of all tell me how to create this data base by creating tables and so on...
There will be form and sub-form I guess. Tell me how to begin. How to connect relationship ?

**CJ_London** · 02-07-2023, 03:58 AM

sounds like you need to start from the beginning. Suggest google something like 'how to use ms access' to start with, then refine your search for specific topics as required

Here is an example link to get you started found from the above search term
https://duckduckgo.com/?q=how+to+use...%3D57jBdK3YVJo

Before starting, make sure you understand the concept of 'database normalisation' (google it) which is about how your data needs to be organised. You say you already have your data. If in Excel, then almost certainly it will need to be reorganised to work effectively in a database.

**Welshgasman** · 02-07-2023, 07:01 AM

Go on to youtube and search for 'access database'
Lots of tutorials.
Also search for a template. That might give you a head start.

**delta** · 02-07-2023, 08:24 AM

Sir,
I have learned a lot from youtube and books so on...
I would like to discuss about the Loan System as I mentioned in this discussion.
As per my details and idea I do not know how to arrange relationship. First of all just tell me about
relationship. The step by step I can develop along with advice of this forum.
I dont have much idea about creating relationship for table to table. Have small idea.
Please.

**Micron** · 02-07-2023, 08:38 AM

Reading and understand these is a must - especially normalization. IMO, most templates are poorly designed as they don't adhere to many of the following concepts:
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/

Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.com...ng-part-i.html

How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.com...cation-in.html

Important for success:
Naming conventions - http://access.mvps.org/access/general/gen0012.htm
https://www.access-programmers.co.uk...d.php?t=225837

What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html

About Auto Numbers
- http://access.mvps.org/access/general/gen0025.htm

The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - https://www.isladogs.co.uk/multivalu...lds/index.html

**delta** · 02-11-2023, 03:25 AM

Sir,
I would like to know more about table connecting. I know lot of things about tables and relationship. In case of 2 tables there and both are one to one and in both table should be primary key? If so why connecting with primary key and foreign key in case of one to many ? Please comment.