In Progress

Build Access Database

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)

Skills: Microsoft, Microsoft Access, Software Architecture

See more: build database access 2010, build database access, build job candidate database access, build simple accounting database access, build website database access, build relational database access, build resume database access, build database access companies, database access application, free inventory database access, facilities database access, create database access 2003 access 2007, convert database access exe, inventory database access, mailing list database access

About the Employer:
( 26 reviews ) Las Vegas, United States

Project ID: #12769540

Awarded to:

royalcalif

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

$250 USD in 6 days
(13 Reviews)
3.8

35 freelancers are bidding on average $501 for this job

meet2amitvw

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

$721 USD in 10 days
(58 Reviews)
7.8
illuminesoft

We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years. ID : 12769540 Greetings, We are interested to work on this project, please find my comments i More

$277 USD in 10 days
(331 Reviews)
7.6
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience working on /PHP/MySQL/HTML5/jQuery/Laravel/Wordpress/Magento/Joomla/Drupal/AngularJS/[url removed, login to view] More

$1030 USD in 10 days
(25 Reviews)
7.7
branislavm

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

$554 USD in 10 days
(222 Reviews)
6.7
eperfections

Dear Sir. I am TOP RANKED programmer and database expert. I am interested in doing this project.

$555 USD in 10 days
(108 Reviews)
6.5
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$500 USD in 7 days
(76 Reviews)
6.2
$555 USD in 3 days
(84 Reviews)
5.5
Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further More

$747 USD in 15 days
(5 Reviews)
5.6
prashushinde9

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

$773 USD in 20 days
(15 Reviews)
6.1
jawadaman

Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines More

$500 USD in 10 days
(71 Reviews)
5.6
havit

Dear Client, I am interested in upgrading your MS-Access database. Yes, we can add login security and the the general user can only view their own inputted data and print their inputted records only. However, the A More

$700 USD in 7 days
(6 Reviews)
5.3
dpune

Hi, I have more than 14 years of Access exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please More

$750 USD in 20 days
(65 Reviews)
5.5
zu02

Hi there, if you'd really like to have a professional Ms Access(from your vb6 ) software for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician and a full time developer with a strong More

$863 USD in 12 days
(32 Reviews)
5.9
A2Design

Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here [url removed, login to view] Here’s a little video about our team too! ht More

$750 USD in 7 days
(11 Reviews)
5.8
alaeddindhahri

Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I ha More

$300 USD in 4 days
(11 Reviews)
4.2
sonarkaushik

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

$250 USD in 4 days
(14 Reviews)
4.4
workerbee1974

My passion is building Access Databases. I have built well over 250 custom databases in the past 16 years. I have samples and more reviews at [url removed, login to view] Databases I have built inclu More

$500 USD in 10 days
(8 Reviews)
4.2
DemonDeveloper

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

$250 USD in 1 day
(17 Reviews)
3.6
swarm22

I see requirements. I had many projects done in ms access and vba programming.

$277 USD in 3 days
(2 Reviews)
3.7
VladimirLilenko

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

$300 USD in 6 days
(18 Reviews)
3.9