Suoritettu

Database Graphics generator easy dataprocessing

I have an access database with 1 table and I want to generate some graphics. Its is a simple database that has a table with members including the date they started, date they quit and date of birth.

Database: Access

1 table with the following fields:

ID

Name

Gender

Date of birth

Starting Date

Ending Date

Zipcode

Rank

Now I want to be able to generate a report with graphics from the database. I want to be able to make nice report containing the following graphs:

1. Line graph that shows the number of active members per month for the last 5 years. The graph should show 5 lines( 1 for every year) and on the X-axe it shows jan…dec. Active members per month can be counted by looking at the period they are member ( Between Starting Date and Ending date)

2. Bar graph showing the number of members per age that they have started. ( for example 4 people started at the age of 5 and 10 people started at the age of 11 …

3. Bar graph showing the number of members per age that they have stopped. ( for example 4 people stopped at the age of 5 and 10 people stopped at the age of 11 …

4. A bar graph with two bars, one for male and one for female..showing the average duration of a membership in years, grouped by gender

5. A Pie graph that shows the number of members grouped by zipcode

6. A bar graph showing the avg. duration of a membership grouped by age they started

7. Bar graph showing the number members that have stopped ( ending date is before today() ) grouped by Rank

8. The average duration of a membership all members in the database. For those who have not quit and the endingdate is empty..should be considered as today()

You can do the programming in access or vb.net but I want you to use the access database so that it is easy for me to add clients to the database. Also I will get the source code if you use vb.net. You may use the database attached to start from if you like...Most graph are there but not all

No payment at project start but full payment on completing the project.

Taidot: Tietokannan hallinto, Microsoft Access, VB.NET

Näytä lisää: networking graphics database, car graphics database, form generator typolight database, easy front end database tables, easy input access database forms, flash dynamic graphics database, doll generator graphics, book cover graphics database, sentence generator word database, graphics database, graphics database photoshop, easy mailing list database, graphics database program, random question generator php database, easy oop php database query

Tietoa työnantajasta:
( 7 arvostelua ) Maastricht, Netherlands

Projektin tunnus: #12283858

Myönnetty käyttäjälle:

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 Lisää

€30 EUR 1 päivässä
(17 Arvostelua)
3.9

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

zu02

I'll make ms Access interface with dynamic graphs... Hi there, if you'd really like to have a professional Ms Access software for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician Lisää

€222 EUR 3 päivässä
(26 arvostelua)
5.7
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 Lisää

€44 EUR 1 päivässä
(59 arvostelua)
5.4
kolosibalint

Dear Sir/Madam, I have 4 years experience in Excel and Access VBA programming and reporting. I currently work as BI analyst at Ford Motor Company where I make plenty of automated reports in Excel files that pull th Lisää

€170 EUR 5 päivässä
(5 arvostelua)
3.4