Scenarios driven execution of heavy operations in MS Access

by SergeyKyiv
Portfolio

(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

25+ years experience in programming: Assembler, Pascal, SQL, VBA, Ruby, bash, HTML5/CSS3, JS. User friendly, easy in use and time saving solutions: - databases: developing and supporting (MS Access, Excel based, MySQL) - automation (shell scripts, daemons) - data syncing, encryption, backuping Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later.

$18 USD/hr

16 reviews
4.8

Tags