Build Access Database
$250-750 USD
Pagado a la entrega
Access database
Attached is a database started with the needed information. The most important function needed to be created is the Login Security Level (see details below) and the reports (see attached database for examples and details below).
Purpose: Maintain, track and report on non-for profit sponsorship requests.
Login Security Level
1. When user Login as “admin”: S/He will have full access to view, modify (add-edit-delete) all records
2. When user login as “User”: S/He will only have access to view s/his own records only . S/she reports & queries will only have access to their records.
Reports:
1. Group report (for Admin access only) that contains information on all PA Administrator &Divisions. Report to have dashboard with charts that will compare amounts given to Categories, Divisions, & Nonprofit Organizations.
2. Individual reports that can be ran daily or quarterly that will provide PA Administrator, Division, Category, Nonprofit Organization, Reason for Contribution, & Amount. Providing a total amount at the bottom of the page . Also providing a dashboard with charts comparing categories.
Foundation request form to include:
Date: [enter/select from calendar] 1/12/2017
PA Administrator: [select from drop down] Norma Gutierrez , Lorraine Woodbury, Elyse Gresnick-Smith, Tameika Ortiz, Debi Gallo
Division: [select form drop down] Central Arizona (CAZ), Southern Arizona (SAZ), Northern Nevada (NNV), Southern Nevada (SNV), Corporate (CORP), California (CA)
Category: [select from drop down] Health and Human Services, Youth, Education, Civic, Arts and Cultures, Environment, Community Activities
Nonprofit Organization: [enter] Name “Example Education Org”
Contact Name: [enter] Name Example Jones
Local Address: [enter] Address, City, State, ZIP
Reason for Contribution: [enter] Detailed description on purpose for contribution
Amount : [enter] “$5000” Dollar amount requested
Website: [enter] [url removed, login to view]
Vetted: [check] Yes/No
Company Territory : [check] Yes/No
Ruling Year: [enter] Year ”1999”
IRS Determination Letter: [check] Yes/No
Form 990: [check] Yes/No
Annual Report: [check] Yes/No
Overhead Ration-Less than 35% Admin Fundraising : [Formula]=+(X2+Y2)/Z2] (see excel doc)
Admin Cost: [=V2] (see excel doc)
Services per $1: [=V3] (see excel doc)
Admin Expenses: (see excel doc for formula)
Fundraising Expenses: (see excel doc formula)
Total Expenses: (see excel doc formula)
Total Contributions: (see excel doc formula)
Nº del proyecto: #12769540
Sobre el proyecto
Adjudicado a:
Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. https://drive.google. Más
34 freelancers están ofertando un promedio de $499 por este trabajo
Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat.....I will share some demo as well for recent works if you want to check. You can also c Más
Hello! Here is my offer. Adding security is an easy part, it will just need some time making it work. The reporting part will take most of the time. Both are doable and I think I will need around 3 days to complete Más
Dear Sir. I am TOP RANKED programmer and database expert. I am interested in doing this project.
Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Más
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit Más
Hello , I have solid experience in software development using access (tables, query, forms and reports) recently i completed compare to access dbs and copy data from one to another Thanks
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Más
HI Happy Greetings, I checked your detail and happy to work on it. Please message me for more clarification. Thanks
We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for project Más
Hello, I am a fully certified Official Microsoft Office Specialist who works as a data analyst, specialising in SQL, Excel and Access. I can create interactive dashboards, databases, and custom formulas / programs f Más
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
Hello, i have a decent experience with this field , i believe i can provide an excellent work quality in record time , i am available immediately. Best regards