Student Fees

[Guest]

I have created 3 tables -
1) Receipt having receipt id, stu_code & amount paid
2) Students having stu_code & Stu_name & Class
3) Fees Master where in I have all the fees heads which we have to collect
and stu_code as a foreign key.

We collect fees in 2 terms. I term and 2nd term with different heads. The
fee structure differs class wise. Like eg. for class XI Commerce with
computers we have an additional fees for computers and class XI Science
taking computer or without computer a different fees. We send invoice to the
parents before hand what they have to pay. Could anyone please help me on how
to do this

Thanks
Srikanth

 

[maurrieske]

What is it that you need help with?
A complete invoice program in Acces?
Or what?

Is it a report that you want to send as an invoice to the parents?

Maurrieske

 

[Guest]

yes, and i want the fees to keep on chaging based on the class selected and
the outstanding amount of 1st term should be carried to the 2nd term. Please
help out maurrieske.

 

[maurrieske]

You can't expect me to make a complete invoice program. Then you would take
quiet a risk when the application fails in the future. And that can't be
something you want. So I advise you to be more carefull in the future.
What I can do is help you with acces and VBA. But that means that you will
have to desing the applciation itself. How good is your knowledge of forms,
wueries, reports and VBA? If you are a beginner at VBA then it will take
several weeks for you to build such an application since you will have to
learn about VBA.
It is much to simpel to think that 3 tables will be enough for all you want.
For example, you want for each student a seperate record, but also it is
possible that one student has several records because the student attends
different classes. Therefore you need an summary of all these fees.
What way do you want to insert records? Through a form (that would be best
since you can maken a user interface with alle de information you need to
insert. You can lookup records if they already excist. An even you can work
in different tables in one form (yes that is possible).

So you see building a application isn't that easy.
First you will need to think out your wishes and what the applciation should
be able to do. You should even specify if you want to work with a form and
how thjat form shoul look like.

And if you are willing to learn a lot about VBA then I am able to help. If
you just want someone to build you an application then you should hire
someone. That way you can ask for a guarantee of correct working and an
after sale service. But even then you will have to specifiy everything.

So let me know what is is that you want to do (hiring me would be a possible
if your company is in the Netherlands or near the border in Germany. In
other cases you should look for other people to help you).
Don't get me wrong. I'm not looking for paid work. My preference is that you
want to learn about the use of forms and VBA. And with that I can help you
for free. It woul be a challenge for me to communicate in a language that is
not my native language (which would be Dutch). You even have to be patient
since I have a fulltime job.

You can mail me at
m a u r r i e s k e at h o t m a i l d o t c o m
No spaces and at = @ an dot = .

Greetz
Maurrieske

 

[Guest]

Thank you very much for your prompt and elaborate reply. I indeed worked on
VBA and Access earlier. I then used only one table. But the problem was I
could not have the records being stored. It was just used for a particular
term and once I update the 2nd term the 1st term records gets lost and more
over It was just used to take out invoices and send to the parents rather
than having a computerised receipt. The receipt generation is till manual and
once after the fees are paid I take up the receipts and then feed in the
amount paid to arrive at the outstanding amounts.

So now you tell me how do i incorporate generating a receipt and keeping on
the data year after year.

Is that I definitely require a VBA program or can I just use access and
finish the job. If No, then how do i go about linking different tables and
having the receipt

Thanks and hope for a positive reply
Srikanth

 

[maurrieske]

My advise is to use tables, forms, reports and VBA. Send me your Email
address to m a u r r i e s k e at h o t m a i l dot c o m
no spaces
at = @
dot = .

I will think about a setup for an application with the next basics
you can insert students
you can insert classes with fees
it will make an overview per sudent of the whole debt that you can sent to
the parent
you can split the debt in 2 different terms bases on a % (that you can
change)
for each debt there will be made 2 invoices with a unique number (on of the
first rules of invoicing)
you can insert payments with an invoice number
there wil be an overview of all students wit their rest debt (whole debt - 2
terms - payment 2 terms - rest payment - rest debt)

What I need from you is your database (you may alter the names of the
students)
Information on the numbering of invoices
you will have to desingn the format of the overview for the parents
you will have to desingn the format of the invoice
a lot of patience, for I have a fulltime job as well
you must be interested in Acces, forms, reports, queries and vba or else it
won't work the way you want


Then I might be able to help you.

Greetz Maurrieske

 

[Guest]

okay i will send u a mail what I have done. Just go thru it


srikanth