Sign in

Access Developer

Company:
MSys Inc
Location:
Little Rock, AR
Posted:
November 05, 2019

Description:

Title: Access Developer

Location: Little Rock, AR, United States

Length: Long term

Restriction: W2 or C2C

Description:

Interview Type: Skype very long term project; initial PO till 11/30/2020 with multiyear extensions

seeking a contractor to modify existing Access systems to work with 64-bit Office 365 environment.

Responsibilities include: Serve as the lead developer for an existing Microsoft Access database/application. Will perform ongoing database and form maintenance, develop future enhancements, and support potential migration to a Commercial-Off-The-Shelf solution. Participates in working groups to refine new requirements, develop and test solutions, and to identify short and long-term product modification strategies.

The successful candidate would be familiar with all aspects of Microsoft Access development including Forms, Visual Basic for Applications (VBA), ActiveX Data Objects, MS Access SQL and Query design, and advanced methods for exporting\importing data in CSV, Text and XML formats. Ability to use and create ODBC connections.

Knowledge, Skills, and Abilities Requirements. .

Significant experience (5-7 years) in the design, development, and documentation of MS Access-based applications.

Split MS Access Databases into Front Ends and Back Ends for multi user functionality. Back Ends (BE) to be converted to SQL tables for security and stability.

Translating the business logic from macros/modules/queries to SQL and other programming language so that the GUI can work flawlessly.

Strong in SQL Server with writing stored procedures, pl/sql and migration of tables from MS Access to SQL Server.

Converting MS Access Forms/ Reports to any Web based application.

Database design, implementation, and documentation.

Visual Basic for Applications

ActiveX Data Objects

MS Access SQL and Query design

Experience splitting MS Access Databases into Front Ends and Back Ends

Experience translating the business logic from macros/modules/queries to SQL

Experience writing stored procedures, pl/sql and migrating tables from MS Access to SQL Server

Experience converting MS Access Forms/ Reports to any Web based applicationAble to work independently to achieve outcomes in an expedient and professional manner

Flexibility and positive attitude.

Exception oral, written and interpersonal communication skills

Knowledge of SharePoint and SharePoint development would be a plus.