Build a database

Use only Ms access 2003-2007 (strictly)


Umoja organisation is a self-help group intended to improve the economic status

of its members through pooling of financial resources. The organisation sustains

itself through registration fees of its members, monthly contributions, interest

accrued through loans given to members, and penalties for delayed payments.

The members benefit by getting cheap loans from the organisation.

Membership to the organisation is by registration. There are two types of

membership; individual and group. Group membership constitutes two or more

individuals who have common interests. An individual member pays a registration

fee of Kshs. 2,000 while a group pays Kshs. 5,000. During the registration of

individuals, personal details are captured. When registering a group, details of the

group and those of its individual members are captured.

An individual member contributes a monthly share of not less than Kshs. 1,000 to

the organisation. For those registered under a group, each member contributes a

monthly share of not less than Kshs. 1,000 where Kshs. 200 is the group share

contribution by the member. All monthly contributions are treated as shares for

the contributor and attract annual dividends.

Members can borrow loans from the organisation based on their total shares.

Members registered as individuals can be loaned up to three times their share

contribution. The repayment period does not exceed three years and the loan

attracts interest at a rate of 1.2% per month on the principal amount borrowed.

Members registered under a group can be loaned up to four times their individual

share contribution. The repayment period does not exceed four years and the

loan attracts an interest at a rate of 1% per month on the principal amount

borrowed. A group can also get a group loan, amounting to three times the

group’s total share contribution which attracts interest at a rate of 0.8% per

month payable within five years. All payments to the organisation are monthly

and must be made by the last day of the month. Any defaulted payments are

penalised at a rate of 10% per month.

Every end of the year, the organisation determines the total interest charged on

all loans and total penalties on defaulted amounts. 60% of this amount is paid as

dividends to the shareholders each getting an amount proportional to their total

share contributions. The balance is retained to run the organisation.

Design a computerised database system with its documentation for the Umoja

organization that should be able to:

1. Maintain records of members and groups.

2. Maintain records of registration fees.

3. Maintain records of monthly contributions.

4. Maintain records of loan borrowed.

5. Compute loan repayments and interest.

6. Compute income for the organisation.

7. Compute dividends to each shareholder.

8. Generate reports on demand

Evner: Microsoft Access

Se mere: 10 ways to use a pencil other than writing, ready use front end database, build database front end java, sql, excel, microsoft access, build ftp web front end, without database use login form using php, database demo front end, build database website, build database csv, setup database use asp gridview, build database, build database scraper, build database access companies, sharepoint build database, open source database ajax front end, build database creloaded

Om arbejdsgiveren:
( 0 bedømmelser ) Kenya

Projekt ID: #15058635

6 freelancere byder i gennemsnit $90 på dette job


Hi, I'll enhance your DB juston your need. Relevant Skills and Experience vba, Excel, sql, ado, Access Proposed Milestones $333 USD - default

$333 USD in 10 dage
(40 bedømmelser)

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See my portfolio on Access. Email sending with MS Access. https://youtu Flere

$30 USD på 1 dag
(41 bedømmelser)

Dear Sir, Your company recently advertised for website developer . After reading the job description I am confident that I would be a perfect fit for this position as my experience and abilities precisely match your r Flere

$25 USD på 1 dag
(0 bedømmelser)

Please review my profile. Relevant Skills and Experience I have 7 years and 9 months experience in SQL. Proposed Milestones $24 USD - MS ACCESS Please let me know more details and when we will start. Sky pe: jikenj Flere

$24 USD in 0 dage
(0 bedømmelser)

I understand the job that needs doing *and the price is negotiable* Relevant Skills and Experience I have a degree in Computer Network and Security and have a lot of experience in Cyber Security as well as Ethical Hac Flere

$25 USD på 1 dag
(0 bedømmelser)
$100 USD på 1 dag
(0 bedømmelser)