Building simple MS ACCESS database.

Creating invoice but its not working..  I think I am screwing up in relationships. Attached you will find simple database, please let me know if I would have done this differently.

We are the institution hires examiners and tutors for student. Examiners and Tutors Charges us certain amount( every Tutor or examiner charges different) and the we charge our students ( that billing part i still have to work on) I am stuck in very beginning.

Thanks in advance
Roger GillManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Check my attachment

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Hamed NasrRetired IT ProfessionalCommented:
I think you need to focus on building the database structure. Use recommended naming for objects.
Use Invoices for table and also for form. You may use tblInvoices frmInvoices if you prefer.

To whom the invoice will be sent, it is not obvious from the table>
IDInvoice      InvoiceDate      InvoiceAmount      PaidAmount      Balance
1      5/4/2018      $0.00      $10,000.00      $0.00
2      5/5/2018      $0.00      $0.00      $0.00
3      5/8/2018      $0.00      $0.00      $0.00
4      5/7/2018      $0.00      $0.00      $0.00
5      5/10/2018      $0.00      $0.00      $0.00
6      5/11/2018      $0.00      $0.00      $0.00

Spend some time in building the right structure before building more objects with a weak structure.

Start with an invoice as it is printed on paper, then follow the normalization process for the database. (Search for database normalization).
This will help you in building the right relationships that will simplify data retrieval.
Roger GillManagerAuthor Commented:
hnasr thanks for the advice, Mr. :John Tsioumpris than alot taking time to solve this question for me. I was able to close that particular small project. Thank alot Mr. John...
Roger GillManagerAuthor Commented:
Mr. :John Tsioumpris thanks alot taking time to solve this question for me. I was able to close that particular small project. Again Thank alot Mr. John
John TsioumprisSoftware & Systems EngineerCommented:
Glad i helped you..
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.