calculating on 2 terms

[Guest]

we collect fees in 2 terms. Can I implement this in access. When I select
term1 all the fees pertaining to that should be displayed and the student has
the option of paying in installments too. i.e term1 fees = 5000, he can pay
the same in installments. So when the student pays for the 1st time say 1000
then the balance amount should be shown as 4000 and again when he comes and
pays the remaining balance the balance amount should be zero. If at all any
balances still remain then the same has to be carried forward to the 2nd term.

I also like to generate reports for the following:
1) Balances due
2) Invoice Statement - mailed to the parent
3) Receipts
4) Ledger


Thanking you in advance

 

[Joseph Meehan]

we collect fees in 2 terms. Can I implement this in access. When I
select term1 all the fees pertaining to that should be displayed and
the student has the option of paying in installments too. i.e term1
fees = 5000, he can pay the same in installments. So when the student
pays for the 1st time say 1000 then the balance amount should be
shown as 4000 and again when he comes and pays the remaining balance
the balance amount should be zero. If at all any balances still
remain then the same has to be carried forward to the 2nd term.

I also like to generate reports for the following:
1) Balances due
2) Invoice Statement - mailed to the parent
3) Receipts
4) Ledger


Thanking you in advance

You certainly can do that in Access and there may be some very good
reasons to use Access. However I suggest there may be a better tool for
what you are doing.

Microsoft Money Small Business version does everything you list and is
already programmed for what you want. You could easily save the cost of the
program when you consider the cost of programming Access.

My second idea would be to look around for a sample Access application
that is close to what you want. Try a Google search. Even if you can only
find something close it should help you understand what you need to do and
you may be able to modify it to fit your needs.

Specific instructions on your project is beyond the usual range of a
newsgroup. We are better with addressing specific questions about Access.
We will be happy to try and help.