MS Access & Visual Basic & MySQL Workflow App

Заказчик: AI | Опубликовано: 19.12.2025

I need a compact MS-Access solution, backed by MySQL and driven by Visual Basic code, that tidies up the way my small business handles information. Right now our data is scattered; the goal is one place where staff can store, find, and update records without wrestling with spreadsheets or duplicate entries. What I’m picturing • A clean Access front-end with intuitive forms and search screens • Solid table design in MySQL—relationships, indexes, and constraints set correctly for fast, reliable data storage and retrieval • Visual Basic routines that automate common actions (open-form buttons, record validation, import/export helpers) so staff can stay focused on work instead of wrestling with the database Deliverables 1. Access front-end (.accdb) linked to a MySQL database schema 2. All VBA modules and queries, fully commented 3. A short read-me explaining how to install the schema, relink tables, and add new users If you have built similar Access-to-MySQL setups and can hand over a tidy, well-documented file, let’s chat and get this running quickly.