Ask Experts Questions for FREE Help !
Ask
    jacintowesly's Avatar
    jacintowesly Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 4, 2009, 11:24 AM
    Tuition on Students and Clases
    I have been trying to include tuition (monthly payments) on the Students and Classes database that comes with Ms Access. What tables should I add and How should I relate them.

    Jack
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Aug 4, 2009, 11:36 AM

    Assuming you are just tracking payments you would add a table like so:

    TblTuitionPmt
    TuitionPmtID (PK Autonumber)
    StudentID
    ClassID
    PmtAmt
    PmtDate

    I would then create a subform bound top this table. You can embed that subfom top your students form to show a record of payments for the currenmtly displayed student. You can also do the same for the class table.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Tuition behind [ 1 Answers ]

Hello If your child goes to Catholic High school and you are behind in tuition can they withhold her diploma and transcripts?

Tuition for middle school students [ 1 Answers ]

Hello everyone, My 8th grade student has been accepted to a private boarding school in Georgia, does anyone know of any programs that help fund private school education? Scholarships, loans. He is a great student! Thanks

H1B Tuition Fee ? [ 3 Answers ]

Hi, Can anybody give me an answer to this question pleaseee.. Here is my situation time line - I came here in US. In 2000 (F1), Graduated undergrad in Dec 2005 - Got an OPT on Jan 2006 - Start working with my first company - Got H1B on Oct 2006 from my first company - Quit and move to...

Tuition fee and Tax for F1(CPT) [ 1 Answers ]

I'm a postgraduate student under F1 visa and working fulltime for CPT(Curricular Practical Training). I wanted to file 2006 tax return but not sure whether to include the tuition fee or not. Am I eligible to include my tuition fee in the federal tax return?

Tuition [ 5 Answers ]

I seriosly need to know the pros and cons of tuition(extra classes).I am joining a debate:eek: Please send me links to other websites which r related to what I need to know.Please do help and thank you.

View more questions Search