Visual Basic Programming

Visual Basic Programmer

Visual Basic Programming Microsoft Access Database

Access Database
SQL Server Database
Microsoft Word
Outlook and Excel

Access and SQL Server Database development Website design and Search Engine Optimisation

Skip Navigation Links
Home
Software Services
ResumeExpand Resume
Programming SkillsExpand Programming Skills
References
Website OptimisationExpand Website Optimisation
All about Visual BasicExpand All about Visual Basic
PC TuningExpand PC Tuning
Software DevelopmentExpand Software Development
Database ChoicesExpand Database Choices
Guest Book

Visual Basic and Database Programming

For
Visual Basic Software, Office automation, Access Database design
click nev@romtech.com.au

Phone
Sydney
(02) 9453-0456

Build Date 16/07/2008

Visual Basic ProgrammingVERTIKOTE CORP. LIMITED



April 2007 to Present

Title:

Microsoft Access Programmer.

Profile:

Vertikote Corp. Ltd. is one of the largest industrial paint and powder coating operators in Australia. They offer a complete range of coatings and textures for commercial and domestic applications.

Duties:

Microsoft Access Database and Visual Basic Programming. Maintaining the PCS Administration database, consisting of over 45,000 lines of code.

Achievements:

  • Created a test environment to emulate the Vertikote PCS system.
  • Using Terminal Services, created a test environment on the Vertikote Server.
  • Installed the PCS system using Access 97, and then converted the databases to Access 2003.
  • Upgraded the linkage of the Sybiz (FoxPro database) from ISAM to ODBC.
  • Analysis of the Access database identified over 30,000 issues. Resolved all issues.
  • Created an Error handling module that records error details to a log file.
  • Added error handling to each procedure in all Forms and Reports. All "Resume Next" statements replaced with error handling. Ensured that all Variables are typecast. Eliminated Variant variables.
  • Created an ADO module, to handle Database access.
  • Upgraded Access 2 and VB5 functions to VB6.
  • Eliminated all Macros.
  • Created a data driven Menu system.
  • Added Microsoft Access and User security to the Access database.
  • Decompiled the PCS database, reducing the size by 60%.
  • Added a procedure to calculate the number of workdays in a period, taking into account weekends and holidays.
  • Created a Form and the logic to Relink to any BackEnd database. Created a Startup Form that controls the BackEnd Relinking.
  • Identified the sources of performance issues.