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 pekerja bebas membida secara purata $49 untuk pekerjaan ini
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.
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