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


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

Квалификация: Microsoft Access, PHP, Программирование баз данных, MySQL, SQL

Показать больше project database online quiz, php mysql simple project database, project diagram inventory system, java exe project database, access sample database inventory taking, free project database vb6, project database files mega retail store, filemaker project database sound, astroempires project database, introduction online bookstore project database systems, design database inventory chemicals, project database manager, project database fact sheets bidding jobs, web setup project database, visual studio project database inventory, project database car inventory, php inventory management project database

О работодателе:
( 87 отзыв(-а, -ов) ) CHITTAGONG, Bangladesh

ID проекта: #21268890

7 фрилансеров(-а) в среднем готовы выполнить эту работу за $49


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 Больше

$43 CAD за 7 дней(-я)
(17 отзывов(-а))

All of our programming skills: *Front-end: - HTML, HTML5, JSON. - JAVASCRIPT (Ajax, AngularJS / 2 / 4 / 5 / 6 / 7, ReactJS - Redux, Jquery). - CSS, CSS3, Twitter Bootstrap, Less, Sass, Scss, Responsive, Material. - M Больше

$43 CAD за 3 дней(-я)
(1 отзыв)

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.

$100 CAD за 2 дней(-я)
(1 отзыв)

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 Больше

$40 CAD за 1 день
(1 отзыв)

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 Больше

$40 CAD за 7 дней(-я)
(0 отзывов(-а))

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 Больше

$40 CAD за 3 дней(-я)
(0 отзывов(-а))

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

$40 CAD за 4 дней(-я)
(0 отзывов(-а))