MS Access & Visual Basic & MySQL Workflow App
Budget: $8 – $15 CAD
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.
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.