Käynnissä

Microsoft Access 2010 Guru required to create project with pivot charts

We require an experienced Microsoft Access guru to create a simple project in which we can record decimal amounts each month for a list of users, and then render the information in pivot charts on a per user / overall basis – showing the calculated averages, and cumulative totals each month.

The table of data is currently in Excel format, and will be supplied when the project is awarded. Data recorded in the spreadsheet is formatted with ‘First Name’ ‘Last Name’ in the left hand column (A), then amounts recorded against each name per month. With each amount are two text fields that could be populated from a lookup table.

Data example:-

-------------------------------------------------------------------------------------------------------------------------------------------------

| Last Name | First Name | Pmt Amount | Pmt Date | PmtType | Pmt Amount | Pmt Date | PmtType |

-------------------------------------------------------------------------------------------------------------------------------------------------

The data set we have represents approximately 90 users, and 24 months of data. The following forms will be required as part of the project:-

> Create / Edit User

> Add / Amend Payment method

> Enter / Amend Payments for a given month.

Pivot charts are required to show the cumulative total from the table presented with a calculated average for each user.

When this project is completed, there will be possible extensions awarded to render the information in PDF reports for each user.

Please only bid if you have previous working knowledge of relational database structures, and pivot tables / charts. Indicate with you bid what your areas of expertise are.

Taidot: tiedonsyöttö, Microsoft Access

Näytä lisää: what is guru, what is data structures in c, what is data structures, what is a data structures, what are data structures in c, what are data structures, what are data entry forms, text guru, set data structures, pivot table pdf, pivot table guru, microsoft access guru, microsoft access data entry forms, list of data structures, list in data structures, list data structures, information guru, guru to, guru method, guru guru, guru forms, guru database, forms guru, excel spreadsheet expertise, data structures set

About the Employer:
( 160 reviews ) Woking, United Kingdom

Projektin tunnus: #4250644

Myönnetty käyttäjälle:

rhomeu

MS Access expert here please see my profile. Thanks

240 $ USD 3 päivässä
(38 arvostelua)
6.5

13 freelanceria on tarjonnut keskimäärin 127 $ tähän työhön

fastudiovw

Hi I received the info by Robert Young, but as said to him, I'm not sure to be able to do it "urgently", it depends on your real desired timeline, in this mmoment I'm a litle busy and I could have this done within Lisää

240 $ USD 10 päivässä
(621 arvostelua)
7.1
Prashantskin

[url removed, login to view] I have gone through your project requirements. I will do the project of pivot charts in access 2010 within 2 days only. Please see PMB for details Thanks for your time Regards Prashant

80 $ USD 2 päivässä
(452 arvostelua)
6.8
amcsummers

Hi Rob nice to see you have a project out there. Not sure if you remember me we worked on a few projects together on VWorker. Last one was 6 months ago Microsoft Access Project - convert from 2003 to 2010. I have Lisää

150 $ USD 7 päivässä
(38 arvostelua)
5.1
mukulsinha25

Greetings Client I will be able to help you with this project. I have over 7 years of experience in excel,access,vba automation and database development and management. I will be able to provide you with accurate an Lisää

125 $ USD 3 päivässä
(1 arvostelu)
2.0
arshadmehmood382

Consider me on this project.

30 $ USD 5 päivässä
(0 arvostelua)
0.0
shairali91

Hi, see your Pm.

30 $ USD 10 päivässä
(0 arvostelua)
0.0
maxvision123

Hi, I've done lot of projects working in different companies for 7+ Years. When It comes the question of performance, No matter even if you have millions or billions of entries in your database, Just give me a chan Lisää

200 $ USD 3 päivässä
(0 arvostelua)
0.0
paultaylor84

I am an expert Access user and can create your custom solution no problem. I am very well versed with Pivot Tables and would like the opportunity to create this for you.

200 $ USD 5 päivässä
(0 arvostelua)
0.0
bubu77

Hi, Ms Access expert having 8+ yrs of IT experience. I will be able to help you in developing your application. Please see your PM for more details.

130 $ USD 5 päivässä
(0 arvostelua)
0.0
R4ndy

Looking forward to hear from you!

150 $ USD 5 päivässä
(0 arvostelua)
0.0
onlineupdatebd

I am experience with my skills. Please see PMB.

50 $ USD 7 päivässä
(0 arvostelua)
0.0
sureshindula

i will do my best...

30 $ USD 3 päivässä
(0 arvostelua)
0.0