We are seeking a qualified MS Access Developer for an Access project. This Access project is intended to centralize current fragmented data files and produce valuable reports with a reasonable degree of automation.
Key Skills :
Relational databases modeling, analysis, design and development using MS Access and VBA programming (knowledge of MS SQL Server would be an asset), as well as ability to develop ETL (extraction, transformation, and loading) procedures.
Requirement Details :
Expert level of experience as a MS Access / VBA Developer working with database analysis, design and development, including applications and data migration / conversion
Expert in addressing performance issues in a MS Access based solution and optimizing MS Access performance in a corporate network setting
High ability in working with MS Access integration with other information systems, (i.e. Sharepoint)
Asset : Ability to convert MS Access queries and VBA code to SQL Server functions and stored procedures to improve performance and transaction handling