HELP!
Im Making a Database for a landlord who manages 7 properties. Each property has 5-6 rooms in which an individual student lives in.
I want the database to
- Hold information for each student.
- Hold information (address) for each house.
- Have a query to bring up an individual student and how much they have paid and how much they have left outstanding.
- To show when the next payment is due and when the last payment was made
I think I need to add somesort of transaction table or payment form. I am new to access and I would really appreciate the help.
Im Making a Database for a landlord who manages 7 properties. Each property has 5-6 rooms in which an individual student lives in.
I want the database to
- Hold information for each student.
- Hold information (address) for each house.
- Have a query to bring up an individual student and how much they have paid and how much they have left outstanding.
- To show when the next payment is due and when the last payment was made
I think I need to add somesort of transaction table or payment form. I am new to access and I would really appreciate the help.