VB Programing support Access Database Microsoft Office VB.Net & SQL Server nev@NevVB.com.au Sydney, Australia (612) 9453-0456 Contact Details 23/02/2012
National National Union of Workers - NSW May 2010 to Present
May 2010 to Present
Job Description:
Maintenance of the NUW Access Database system for the Administration of NUW Membership.
Company Profile:
The National Union of Workers (NUW) was formed by an amalgamation of unions, providing pooled expertise and resources to their members.
My Duties:
Microsoft Access Database Programmer.
Achievements:
Fixed a printer problem with membership card reports. Changed the membership card reports. Removed the magnetic stripe error message. Compacted the Front-End database, contracting it by 93%. Set the database compression to occur on exit. The configuration of the system was inefficient and not Microsoft recommended. Reorganised the configuration and eliminated some user problems whilst improving performance. Upgraded the NUW system from Access 2003 to Access 2007. Fixed problems relating to undeclared references. Deleted countless unused variables. Typecast all fields. Removed redundant code. Removed code created for Access 2003. Cleaned up countless code procedures. Hid the new Ribbon and Navigation pane. Optimised the Back-End database, removing the "Auto" option and adding Unicode compression. Deleted old records from the Back-End database, reducing the size by 50%. Added fixes to NUW system, due to Microsoft's new security procedures. Imported a new listing of Post Codes and Suburbs from Austral Post. Created a Post Code selection form – also a search by State and Suburb. Dramatically improved the response time of the NUW system.
Fixed a printer problem with membership card reports. Changed the membership card reports. Removed the magnetic stripe error message.
Compacted the Front-End database, contracting it by 93%. Set the database compression to occur on exit.
The configuration of the system was inefficient and not Microsoft recommended. Reorganised the configuration and eliminated some user problems whilst improving performance.
Upgraded the NUW system from Access 2003 to Access 2007.
Fixed problems relating to undeclared references. Deleted countless unused variables. Typecast all fields. Removed redundant code. Removed code created for Access 2003. Cleaned up countless code procedures. Hid the new Ribbon and Navigation pane.
Optimised the Back-End database, removing the "Auto" option and adding Unicode compression. Deleted old records from the Back-End database, reducing the size by 50%.
Added fixes to NUW system, due to Microsoft's new security procedures.
Imported a new listing of Post Codes and Suburbs from Austral Post. Created a Post Code selection form – also a search by State and Suburb.
Dramatically improved the response time of the NUW system.