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.


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 ) FAYETTEVILLE, United States

Project ID: #12769540

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. More

$250 USD in 6 days
(35 Reviews)

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

$721 USD in 10 days
(59 Reviews)

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)

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/node.js/CSS3/Java/Python/Django/Javascript/i More

$1030 USD in 10 days
(27 Reviews)

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
(225 Reviews)

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
(91 Reviews)

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

$555 USD in 10 days
(108 Reviews)

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
(70 Reviews)

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
(81 Reviews)

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
(6 Reviews)
$555 USD in 3 days
(114 Reviews)

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
(40 Reviews)

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)

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
(7 Reviews)

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an More

$555 USD in 10 days
(6 Reviews)

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

$555 USD in 4 days
(15 Reviews)

Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to 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
(53 Reviews)

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 [login to view URL] Here’s a little video about our team too! ht More

$750 USD in 7 days
(12 Reviews)

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 [login to view URL] Databases I have built inclu More

$500 USD in 10 days
(18 Reviews)

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
(36 Reviews)

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

$388 USD in 7 days
(7 Reviews)