 HI-RISE
ACCESS
February 2006 to Present
Title:
Microsoft Access Programmer.
Profile:
Hi-Rise Access is a consulting and engineering company specialising in height safety,
fall protection and suspended access. They offer turnkey solutions including design,
fabrication and installation.
Duties:
Microsoft Visual Basic for Applications programming.
Achievements:
Completely revamped an amateur Microsoft Access database into an efficient and maintainable
system:
- Converted linked text files into Microsoft Access Tables
- Converted repeated code into global Procedures
- Removed all Macros and added "Option Explicit" to all Visual Basic modules
- Added error handling and error logging to all procedures
- Removed redundancies and improved data integrity by reorganising the Database into
a normalised form
- Added an option to Compress the database
- Removed spurious Events
- Added security to prevent users changing Tables and Queries
- Extended the Switchboard Menu from 8 to 16 options with Sub Menus
- Ran an Access analyser and eliminated errors, inefficiencies and problems
- Created a Diary System
- Created an Enquiry system
- Split the Access Database into FrontEnd and BackEnd databases
- Created routines to import CSV files from an accounting package
- All Forms now conform to global Formatting, with consistent Colour, alignment and
Size of Controls.
Added the following Visual Basic Modules:
- modADO - Microsoft Access Database handling routines
- modDialog - Folder browse routines
- modFile - File handling routines
- modForm - Form handling routines
- modGlobal - System Information, Error Trapping and Global procedures
- modReport - Report handling routines
- modShell - Facility to run external programs
- modLink - Programmatic Linking to a BackEnd Database
- modSecurity - Security routines for the User and Programmer
|