Key Services :
Expert in Microsoft Access VBA and integration with :
Office Applications (primarily Excel and Outlook)
SQL server
Sage Line 50 via SDO (Sage Data Objects) and ODBC
Web API (REST/JSON) – Google Maps, MailChimp, txtLocal, DPD and more
Development of online extranet portals with database integration
Website Development – HTML, ASP, CSS, AJAX, JS, ASP.NET RAZOR
Sage Line 50 Integration
Over 15 years of experience integrating software with Sage Line 50 for many different clients in various industries. Thorough knowledge of Sage Accounts Line 50. Installation of Sage software on multi-user systems (various versions/platforms including Terminal Services).
SQL Server Development
SQL Server is a relational database management system (RDBMS) from Microsoft. It can be used effectively to host large data tables for Microsoft Access database applications or a Web/Extranet Applications. Skills include : T-SQL – Tables, Views, Stored Procedures, Functions, Indexing SSMS – SQL Server Management Studio SSMA – Microsoft SQL Server Migration Assistant Security – SQL Authentication or Windows Authentication.
Integration with 3rd party Web Services via Web API
Enhance your database with Web API integration, bringing web services from Google Maps, MailChimp, txtLocal, DPD and more, directly to your database application.