Build Access Database
$250-750 USD
Paid on delivery
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)
Project ID: #12769540
About the project
Awarded to:
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. More
34 freelancers are bidding on average $499 for this job
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 More
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 More
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 More
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 More
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 More
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. More
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 More
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 More
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