
In Progress
Posted
Paid on delivery
I already have an MS Access database with all of the tables fully built and linked to SharePoint. What I need next is a polished dashboard inside that same file so everyday users can work with the data without digging through the back-end structure. Here’s what the dashboard should do: • Present a clean opening form where users can upload spreadsheet files (xlsx, csv) straight into the appropriate SharePoint-linked tables. • Offer simple option selectors—think drop-downs, radio buttons, or checkboxes—so the user can filter or trigger predefined queries before exporting. • Generate instant exports to both CSV and Excel formats; the file names and save location should be handled automatically or via one prompt, whichever is cleaner. If it makes sense to surface quick tables, charts, or graphs for on-screen feedback, I’m open to that, but the core priority is the “upload → select options → export” flow. Please build this natively in Access (VBA or macros are fine) so it runs from a single ACCDB, keeping the SharePoint connection intact. Once complete, hand over the working file plus brief notes on any references or libraries that need enabling. I’ll validate by uploading a sample spreadsheet, running an export, and confirming record accuracy in SharePoint and both output files.
Project ID: 40567043
134 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs