SHANIT Menu

Information Technology

Consulting


Microsoft Access Database, VBA
2011 - 2012

- France (Besancon)

Image, Barcode Integration, Zebra TLP
2003 - 2010

- Australia (Sydney)
  • Nestle Inc.
  • Rentokol Initial
  • ABI Group
  • Nexus Lexus

Anti-virus Development, C++
2001 - 2002

- Australia (Sydney)
  • vCIS

Web Development, HTML
1996

- Australia (Sydney)
  • Online Systems

POS Casio Cash registers, Arcnet, C++
1995

- Australia (Sydney)
  • Mobex

Document Management, Visual C++
1992 - 1994

- South Africa (Johannesburg)
  • Q-Data
  • Exsol
  • Related Systems
  • Micrographics (MGX)

Computer Security, Turbo C/C++
1991

- South Africa (Johannesburg)
  • First National Bank

Borland Turbo C, C++ Development
1989 - 1990

- South Africa (Johannesburg)
  • Teklogic

Tablet/Mobile website
Tablet/Mobile website

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 administrative operations.

Rolled-out software into a multi-user production system with parallel 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]

Analysis Diagram - Agencement

Database Relational 3NF Diagram

Database Administration

LIAL website
2011 - 2012

©2005-2024 Shanit
English
Francais
Unmute