Hire the Best Microsoft Access Developers
in South Africa

I have been designing databases using Microsoft Access, SQL, C#,, VB and VBA for the past 20 years and can create, customise or amend any Access or SQL/ MySQL database as well as develop front-end applications in .NET or Access. I have developed many databases for such a variety of industries. I have expert knowledge of Excel, Access and Word, including VBA. I have 20 years plus corporate experience in the financial industry using Excel and Access for data modelling and calculations as well as creating complicated Word templates - both for corporate identity and for purposes such as bulk mail merging from client databases. I develop SAGE ERP (Accpac) SQL integration using the Accpac API's within Accpac VBA as well as bespoke app development for SAGE Accpac using C#, VB.Net, VB.6.0 and Microsoft Access. I also have databases that connect directly to PASTEL and enable you to directly Email and SMS your clients from the database for bulk marketing campaigns. Other specialties include Excel financial modelling, automating PowerPoint reports from Excel data as well as creating corporate identities by creating Word templates, TRAINING: I can design customised Excel, Access, Word and PowerPoint training courses based on the needs of your business. With 28 years training experience under my belt, including many years of training needs analysis, it has been proven to me that creating customised training programs rather than sending staff on the standard scheduled course can increase the learning absorption by more than double! I have developed all sorts of courses for many corporate clients – in South Africa, the UK and in New Zealand. In order to make sure that any training down is specific to your needs I can: Identify the training need by means of a TNA (Training Needs Analysis questionnaire or direct questions to identify the specific training requirement). Design the customised course specific to the training need identified Schedule the training – either one-one-one or in small groups. Provide telephone support and backup once the training is complete. Computer Skills: SQL Server programming and administration C# and VB .Net programming Visual Basic 6.0 programming Access Database design & VBA programming Excel VBA programming & templates Word VBA macro programming & templates Microsoft Access – all versions Microsoft Excel – all versions Microsoft Word – all versions Microsoft PowerPoint – all versions Microsoft Outlook – all versions Training Skills: Training Needs Analysis Train the Trainer Microsoft Office (all levels, all versions including Word, Excel, PowerPoint, Outlook and Access) Visual Basic for Applications (Word, Excel, PowerPoint, Outlook and Access) Technical Writing Skills: Courseware (manuals and exercises) for all the above courses as per the MOS syllabuses set down by Microsoft. Instructor notes and reference manuals. Database technical manuals to accompany database projects. Database user manuals to accompany database projects. Training and Work Experience: I have been training delegates to use computers for the past 28 years. I have experience in teaching in South Africa, the United Kingdom and New Zealand and have taught learners from all walks of life. I have been creating database and software systems using VB.Net and SQL Server since 2000. More details of my work experience are available on request.

I offer services expert Data Analytics SQL, Advanced Excel(formulars, Power Query, VBA, dashboarding) and Power BI(DAX, Power Query, dashboarding) across the stack extract, transform ,load and present. This includes advanced formulars, automation and presentation. My Excel expertise includes development, VBA programming, macros, and handling large datasets, allowing me to automate processes and enhance data management. In Power BI, I create interactive dashboards and visual reports that turn complex data into actionable insights. While I possess advanced Data Engineering skills, my Upwork offerings are tailored to deliver high-impact solutions in these specific areas to support your needs. Additionally, I have extensive experience in Software Development modeling and documentation, including creating detailed Requirements Documents, Functional Specifications, Technical Design Documents, and User Manuals. I ensure that each document is comprehensive and clearly outlines the project scope, technical requirements, and implementation strategies. This structured approach to documentation supports effective communication between stakeholders and smooth project execution.

I run my own IT agency from Durban, South Africa, and have done work for clients in various South African provinces, and across the globe. I specialise in creating custom Microsoft Access databases and have worked at small business, corporate, and municipal levels. In Ethekwini I have assisted municipality departments as follows: * Electricity Department: Complaints Management System * Parks Department: Cemeteries Management System * Libraries Department: Database for research results * Parks Department: Palms Database In the corporate world I have created an invoicing system for an international shipping company, as well as a dock pass system. I am currently in negotiations with the same client for creating a job card system for one of their departments. Another project was to create a warehouse management system for one of the biggest fresh produce suppliers to major distributors. In between those projects I have assisted multiple small businesses in migrating from spreadsheets that no longer server their growing businesses to efficient databases. I typically create the specifications with the clients, then build and test the system, and once it is ready, install it on their computers or network and train their staff. In some cases I am retained to further enhance the systems as the businesses grow, and assist the clients with ensuring that system rules are being followed by users and the databases are properly maintained. Apart from the software development side of my business, I also do transcription work. I specialize in delivering 100% accurate transcriptions in the shortest possible turn-around time, provided that the audio is clear. I use professional transcription software. Although my home language is Afrikaans, I am an advanced English speaker and hold a Master's degree in English. Apart from these two main categories of specialization, I offer software support in a number of desktop applications and have an active Helpline, offering support to private clients or companies who may not have in-house IT staff. One of the perks of working independently is the ability to take on new projects in a variety of fields. It enables me to apply what I have learned, but also to learn even more and improve my skills to the benefit of my customers.