I have been trying to fix my access document as I am wanting to track inventory on merchandise gifted by people as well as track their monetary donation. I am starting a non-profit organization and want to be able to tracked gifted items for less fortunate families. I don't have a lot to spend on this so what can be done is truly appreciated.
I have 3 tables setup
1. Donor Information (name, address, telephone, etc)
2. Inventory (contains items, size, gender, etc)
3. Monetary Donation (tracks who donated what)
I do not want to rely on table entry but rather form entry, so I have created 3 forms.
1. Add Donor
2. Add Inventory
3. Add Monetary Donation
My vision for this is: I want to be able to add a donor into the Donor form, that then updates the donor's table. I then would like to (first) add a monetary donation which I can choose the donor's name, enter the amount, and date received and this information updates on the Monetary Donation Table. Also if I wanted to add the donor's donated merchandise under inventory, I would like to add all the information in the inventory form that would then update on the inventory table.
What's going wrong: So far, the Monetary form is not associating itself correctly with the Donor Information. It is only grabbing the ID instead of the ID and name.
I have not tried the Inventory form yet as I have been trying to work the Monetary form first.
I would like to have the following Reports created:
- Donations by Year
- Donations by Company
- Donations by People
- Total Value of Inventory
- Total Value of Monetary Donation
- Items donated away (pull from the checked box under inventory tab)
- Inventory by Category
- Inventory by Bin Location
- Inventory by Gender
- Inventory by Generic Size
- Bin Value
This all works so simply in my head but Access is very tricky when putting it to work.
**Side note: I've removed some private information to protect the donors information, so please know a lot of records have been deleted
What I Need from you:
- Fix this database
- Add style to it if not different from mine
- Build the reports above
- Fix any issues that come about
7 freelance font une offre moyenne de $49 pour ce travail
Hi, My name is Alexander. Thanks for your job posting. I have read your descriptions carefully and understood clearly what you want. I have 5+ years of experience in Web Development. Now I'm waiting for your answer wit Plus
Hi, sir. I checked your project carefully. I have many experience in mysql database. I can complete your project successfully. I look forward to working with you! Best Regards.
Although it’s my new profile in freelancer but I have been doing this work for last 5 years. I can deliver you the work on time and it will be quality work for sure. Please award me the project so that we can discuss i Plus
Thank you for your post, sir. I have served on the web for many years and have superior knowledge and function in managing the database. I have a good chance of bidding your project. I want to share opinions about you Plus
i will make all the forms working properly and also i will make reports system I've read the project details and ready to start it right away. I am available with complete expertise in web development in php WORDPRESS Plus
Hi, I'm excited about this your project. i'm an IT consultant with skills on MySQL, Microsoft Access, DBMS. it will be my pleasure to work with you, as i anticipate your favorable response. Thanks