Microsoft Access - Database Analysis and Development
LIAL - Laboratoire Interprofessionnel d'Analyses Laitières, France
Migrated databases and applications developed in Access 97 to Access 2010.
Implemented a Front-End / Back End Access system, separating data from application code.
Redesigned, 3NF normalised tables and developed code using transactions with roll-back
where/if needed to ensure database integrity. Provide full security log, for all
Rolled-out software into a multi-user production system with paralel test/development
systems, ready for further rapid development.
Tested system operation using the Access Runtime, in Windows XP and in Windows 7 both 32 and 64 bit,
with concurrent operators. [VBA, SQL]
- LIAL website
- Analysis Diagram - Agencement
- Database Relational 3NF Diagram
- Database Administration
2011 - 2012