Scenarios driven execution of heavy operations in MS Access

by SergeyKyiv
Image not found

(this was a part of a project under NDA, so I put just a sample form with approximate names) The challange was to automate performance of very different operations with big volumes of data: link files, run queries, compare, analise results, run other queries and so on. So, user got lost doing it manually. To automate user's job, a solution was found in between a checklist and "GNU make" - like approach: - there are several types of actions are predefined, every one is easilty configurable - different "actions" are organised into Scenarios under a predefined sequence of execution AND with dependencies established - system keeps status of each action, so (1) doesn't allow any action to run earlier then it should, (2) omits those actions that are already performed, (3) rerun dependent actions if any, so user always use the shortest way. Finally, in a dashboard user gets 2 small subforms that allow not only to perform everything he needs, but also to see easily the s

image of username SergeyKyiv Flag of Ukraine Kiev, Ukraine

About Me

Master of Computer Science with 25+ years experience. Database Development: Backend & Frontend, SQL, query profiling, VBA. MS Access, SQL Server, MySQL, PostgreSQL. Developing and supporting DB for Finance/Accountancy, DM, CRM, ERP, ETL etc. MS Office automation: Access/Exce/Word/Outlook. Macros, VBA, API integration. Google Docs automation. System administration tools for Linux using bash, ruby. Data syncing, encryption, automation. The key focus is to deliver time-saving, user friendly and easy to use applications.

$24 USD/hr

18 reviews
4.8

Tags