Microsoft Access 2010 Guru required to create project with pivot charts
$30-250 USD
货到付款
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.
项目ID: #4250644
关于项目
授予:
有13名威客正在参与此工作的竞标,均价$127/小时
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 更多
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 更多
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 更多
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.