Microsoft Access 2010 Guru required to create project with pivot charts
$30-250 USD
Paid on delivery
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.
Project ID: #4250644
About the project
Awarded to:
13 freelancers are bidding on average $127 for this job
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 More
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 More
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 More
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.
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.