Database will be a student list for a school - student name, teacher, classroom, and grade level - all this information is already in database format and ready to go.
Also added to that database will be a list of unique identifiers - 3-digit numbers starting from 101, which allows each student to be easily identified and accessed.
Basically we print fundraising order forms with the student's name and information pre-printed and when the order form is turned back in to the school all they have to do to input the number of products the student sold is to enter that three digit number to bring up the student's name and information.
Fields in the input form should be 3-digit "reference number" that controls and calls up the student name, first and last name, the teacher, the classroom, and the grade level. Then there will be inputs for each of our products - If possible I would like to be able to easily add/remove products so that customers only selling 3 products don't have to skip over the other products that they're not selling. Once they input the # of products the student has ordered per product, the form should automatically calculate the amount owed - # of items * $7 - and then there should be an input field for the customer to enter the amount ACTUALLY received with the order (because sometimes people turn in too much or too little). There should be a field next to that that either says "*PAID*" "$x money due" or "Overpaid $x". Then next to that field there should be a button that says "Issue A Discrepancy Notice" that links to a form that the student's name, teacher, classroom and how much they owe - I will customize that discrepancy notice for the data input.
I would also like to have a seperate "data page" that shows the total # of products sold - the total $ collected - $ sold by teacher/classroom - and $ sold by grade.
I would like to make this entire project easily uploaded to a url web site that I will purchase and reserve specifically for this database project. I would like to make it a "log-in" password type of system so that I can upload multiple school databases to the same web site but make it available only to those who have permission.
I have a sample excel file that already does most of this stuff, if that would help in the creation of this access program.
52 freelancers are bidding on average $346 for this job
hello sir my name is renu.i am very experienced person .i hv 2 year experience in this work.plz provide me detail of this project.i can don very well. thanks renu