Access Database UI & Analytics Upgrade
Publicada el 2026-07-29
Descripción de la oferta
I have a working Microsoft Access database that runs fine on the data-side but falls short on usability and insights. I’m ready to take it to the next level by: • Re-thinking the entire front end with a cleaner, more modern feel • Replacing several clunky default forms with purpose-built custom forms, including inline validation and helpful tooltips • Building a clear, role-based navigation menu (think switchboard or ribbon-style) so users can reach common tasks in one or two clicks • Adding robust analytics and reporting: summary dashboards, drill-down reports, export-to-Excel options and a few predefined ad-hoc queries The back-end tables, relations and most of the existing queries will remain; your focus is the interface layer and new reporting modules. I’m comfortable granting you a copy of the current file (split front/back) plus a short walkthrough video so you can map existing objects to the new design. Key technologies expected: Microsoft Access 2016 or later, VBA, SQL, and any lightweight UI add-ins you prefer. If you can leverage charts, pivot views or other native Access visualization tools, even better. Deliverables (all must compile and run without missing references): 1. Redesigned main menu / navigation form with stubbed security levels 2. 3–4 custom data-entry forms replacing current generic ones 3. A set of analytical queries feeding at least two printable reports and one interactive dashboard form 4. Brief deployment notes so I can roll the new front end to users I’m happy to answer schema questions, supply sample data and test early builds. Let’s craft an interface my users enjoy and give management the reporting they’ve been asking for.
Skills
Fuente original: freelancer