Suoritettu

Creating a Smooth/Stylish Access Database for Inventory & Monetary Donation

For the last 3 days, 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

****************

PLEASE NOTE:

****************

What I am asking is well below $250. My budget is no more than $75.00

Taidot: Microsoft Access, PHP, Tietokantaohjelmointi, Excel, MySQL

Tietoa työnantajasta:
( 5 arvostelua ) GRAND PRAIRIE, United States

Projektin tunnus: #21268505

Myönnetty käyttäjälle:

Rajaraz1

Hi We already discuss About it in chat Db have some issue need to be solved and Fix this database - Add style to it if not different from mine - Build the reports above - Fix any issues that come about and if any Lisää

$75 USD 3 päivässä
(5 Arvostelua)
4.2

28 freelanceria on tarjonnut keskimäärin 129$ tähän työhön

fattahaabdul

I can create a smooth database for you. I have 8+ years of experience in php and mysql. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.

$250 USD 7 päivässä
(126 arvostelua)
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have an Access database. All that you write in your brief makes sense and I have no q Lisää

$75 USD 2 päivässä
(264 arvostelua)
7.5
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible Lisää

$75 USD 2 päivässä
(159 arvostelua)
6.5
ludwig333

I am ready for your project now. I can do it and start right now and available for you with fulltime manner. I would like to have a more detailed discussion with you on the chat. Thanks.

$150 USD 7 päivässä
(49 arvostelua)
6.1
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r Lisää

$30 USD 1 päivässä
(108 arvostelua)
6.2
jonyahmed105

Hi I can handle it. Thanks

$75 USD 7 päivässä
(153 arvostelua)
6.4
zu02

Hi, there I hope all's well with you. I can enhance/fix your [login to view URL] today. You can text me on s k y p e zura_e I'm Ms Access/VB/SQL/Excel programmer since 1997. Real Lisää

$75 USD 1 päivässä
(56 arvostelua)
6.2
VBAautomation

Hi, I am a professional MS Access and SQL database developer with 10+ years of corporate experience. I am developing MS Access since 2008 and SQL server database since 2012. I can provide you best and long term suppor Lisää

$200 USD 3 päivässä
(30 arvostelua)
5.3
pinesucceed01

Dear Lamar J., This letter is to express my interest in your posting on your website for an experienced, detailed-oriented, front end web developer. With 6 years of hands-on experience efficiently coding web sites and Lisää

$155 USD 7 päivässä
(21 arvostelua)
5.0
Mexi2705

Hello I hope you are doing well! I have walked through your note and enough confidence that I can develop your project in php. Due to my vast experience in php, I can easily handle technical and log Lisää

$500 USD 7 päivässä
(19 arvostelua)
4.8
dionisiotumbaga

Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

$75 USD 5 päivässä
(7 arvostelua)
3.8
techobrie

i can create databse as neeed High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a Lisää

$100 USD 7 päivässä
(46 arvostelua)
5.2
topexpert713

Hi, Nice to meet you! I am very interesting your project and I am confident of I can help your job. I am confident of this project as I'm a professional expert with over 7 years of experience. Seems to be an interesti Lisää

$70 USD 7 päivässä
(8 arvostelua)
3.4
alokes

Hi, I am a Software Professional developing software in MS Access with VBA for last 22 years. I would like to develop the database using MS Access as per your requirement and input provided by you.

$75 USD 3 päivässä
(4 arvostelua)
3.3
finest2019

Hello! Over the last 10 years, I have developed data-driven applications mostly for the web using advanced backend with PHP/MySQL/NodeJS/Firebase and rich frontend HTML/CSS/JavaScript(angularJS, vueJS, reactJS). My exp Lisää

$140 USD 3 päivässä
(6 arvostelua)
3.0
SnakeGeneral

⭐⭐⭐Dear sir!⭐⭐⭐ ✅I am very interested in your project and I am exciting. ✅I read your project details carefully and I though that I am the best fit developer for your project. ✅I have rich experience about your project Lisää

$100 USD 3 päivässä
(5 arvostelua)
3.2
ExpertSoul

Hello! I am very interested in your post project. While I read your description carefully, I was excited with feeling that I would be able to satisfy for your requirements in this job. We can negotiate on price/Budget Lisää

$140 USD 1 päivässä
(7 arvostelua)
3.4
tutulsoft

--- MS ACCESS DATABASE EXPERT ----------------- Wish to do your work ............................17 Years Experience....................

$75 USD 3 päivässä
(3 arvostelua)
2.9
AntonKozel

***** MS Access Expert ***** Hello . I have read your job description carefully. I have full experience in MSAccess. If you give me a chance, I will deliver good result. I hope to discuss more via chatting. Thank you Lisää

$100 USD 1 päivässä
(2 arvostelua)
2.2
chenmingbiz

Hi, Nice to meet you! I have read your description and attach file. I am very interesting your project and I am confident of I can help your job. I'm a professional web/database developer with over 7 years of experienc Lisää

$150 USD 6 päivässä
(2 arvostelua)
1.8