Excel Pivot Tables Report to be Converted into an Access Database
$30-250 USD
Paid on delivery
Excel Pivot to Access Database Conversion Project
I want to take the existing Excel document with pivot tables and convert it to an Access database, but with the addition of pulling the data from the [login to view URL] report: 1 Named Account Portfolio Planning (in [login to view URL] as “[login to view URL] Account Portfolio Planning”). A sample of the data is in the tab, “1 Named Account Portfolio Plan”. Please include a function to map the data to this report in a dashboard. I want this link to the [login to view URL] report to be dynamic so that the report in the future can be pointed to a different [login to view URL] report. The data is to be loaded into a table and will be refreshed only when the user requests. Only active customers are included (“Active Customer?”). Also, additional datasources can be added at a future date. The refresh function will update each datasource individually (one per datasource) and a date will indicate the last time the data was refreshed. Report data must filter by Account owner. Because this is default filter for the database, please include Account owner as a combo box in the dashboard. The database will compact and repair at the optimal time automatically (either at open or at close- this is the programmer’s choice).
Project ID: #16920774
About the project
Awarded to:
I wish to know little bit more about the project requirements. Please pm me for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner wi More
13 freelancers are bidding on average $175 for this job
Hello, I can help with you in your project Excel Pivot Tables Report to be Converted into an Access Database. I have more than 5 years of experience in Database Programming, Excel, Microsoft Access, Visual Basic, Vi More
Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
I am here freelancer first to discuss the details of Excel Pivot Tables Report to be Converted into an Access Database then i can sure about my price and the deadline. My way of working is not only to complete but al More