Concluído

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

Habilidades: Microsoft Access, PHP, Programação de Banco de Dados, Excel, MySQL

Acerca do Empregador:
( 5 comentários ) GRAND PRAIRIE, United States

ID do Projeto: #21268505

Concedido a:

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 Mais

$75 USD em 3 dias
(5 Comentários)
4.2

28 freelancers estão ofertando em média $129 para esse trabalho

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 in 7 dias
(126 Comentários)
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 Mais

$75 USD in 2 dias
(264 Comentários)
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 Mais

$75 USD in 2 dias
(159 Comentários)
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 in 7 dias
(49 Comentários)
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 Mais

$30 USD em 1 dia
(108 Comentários)
6.2
jonyahmed105

Hi I can handle it. Thanks

$75 USD in 7 dias
(153 Comentários)
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 Mais

$75 USD em 1 dia
(56 Comentários)
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 Mais

$200 USD in 3 dias
(30 Comentários)
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 Mais

$155 USD in 7 dias
(21 Comentários)
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 Mais

$500 USD in 7 dias
(19 Comentários)
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 in 5 dias
(7 Comentários)
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 Mais

$100 USD in 7 dias
(46 Comentários)
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 Mais

$70 USD in 7 dias
(8 Comentários)
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 in 3 dias
(4 Comentários)
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 Mais

$140 USD in 3 dias
(6 Comentários)
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 Mais

$100 USD in 3 dias
(5 Comentários)
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 Mais

$140 USD em 1 dia
(7 Comentários)
3.4
tutulsoft

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

$75 USD in 3 dias
(3 Comentários)
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 Mais

$100 USD em 1 dia
(2 Comentários)
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 Mais

$150 USD in 6 dias
(2 Comentários)
1.8