Freelancer logo
Log In Sign Up
Post a Project

EXPLORE

Excel Microsoft Access SQL Visual Basic Visual Basic for Apps
Profile cover photo
User Avatar

Melanie J.

@VBAWhizz

5.0
14

5.1

5.1

100%

Database Design, Access, Excel VBA Development

$50 USD / Hour

・

Flag of

South Africa (4:37 AM)

・

Joined on March 10, 2011

$50 USD / Hour

・

I have been designing databases using Microsoft Access, SQL, VB and VBA for the past 20 years. In addition, I am a certified Microsoft MOS instructor and teach all levels of the Microsoft office, specialising in advanced Excel, Access and VBA training. I have also written many technical and user training manuals to accompany both the software that I have designed and the training courses that I teache - my Access VBA manual is a step-by-step manual that can be used from the comfort of your own home where help is just an email away.

Verifications

On time

100%

On budget

100%

Accept rate

95%

Repeat hire rate

17%

Freelancer Microsoft Access Developers South Africa
See all Microsoft Access Developers in South Africa

Portfolio

Portfolio

12496678
POS and inventory system for a used car parts company designed in Access 365 with a backend in MYSQL stored on the server. Each PC has an individual copy of the accde file which they need to log into for security purposes and for role purposes

Inventory Program

Inventory Program

12496606
The examples in the attached document show how a customised ribbon tab can be created for an access database - hiding the existing ribbon tabs.

Custom Access ribbons

6811904
This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

466870

Access 2007 introductory training manual

466853

Word Fax Template

155172

screen shot samples of Access databases that I have designed

12496678
POS and inventory system for a used car parts company designed in Access 365 with a backend in MYSQL stored on the server. Each PC has an individual copy of the accde file which they need to log into for security purposes and for role purposes

Inventory Program

Inventory Program

12496606
The examples in the attached document show how a customised ribbon tab can be created for an access database - hiding the existing ribbon tabs.

Custom Access ribbons

6811904
This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

This program calculated the financial viability of a construction project and contains at least 20 forms and an equivalent amount of modules to run. It is made up of approximately 15 sheets, plus 5 hidden sheets. All the sheets are locked so that the user does not have access to the formulas or formatting. The system is run by forms - the main form being the main menu where the user can navigate between different forms to move through the stages of the program. I have attached a pdf showing the main menu and one of the other forms, as well as some of the VBA code contained therein. the system is controlled by a license file so cannot be copied without a license, and the data that is inputted is stored in a 'raw' data file - so if that file is 'stolen' - it is useless without the actual program.

Excel spreadsheet program

466870

Access 2007 introductory training manual

466853

Word Fax Template

155172

screen shot samples of Access databases that I have designed

5.0 · 14 Reviews
14 Reviews
User Avatar
Flag of

Nathan M.

5.0

$200 USD

4 years ago

Access database enhancements -- 2

Exceptional work. Properly took time to understand the brief. And output is spot on. Will definitely use again.

Visual Basic
SQL
Microsoft Access
PDF
MySQL

Share

B
Flag of

Dave L.

5.0

$300 USD

12 years ago

Freight Carrier Access Database

Very good product and completed very quickly

Microsoft Access

Share

A
Flag of

Zack L.

5.0

$125 USD

13 years ago

Access Database/Form Updates

She does great work. She's fast, efficient and patient. She was willing to work with me on developing a solution, communicated often and well, offered great advice, a went above and beyond my expectations. I will definitely call on her again for my next Access solution.

Visual Basic
.NET
User Interface / IA
Software Architecture
Microsoft Access

Share

J
Flag of

Joe G.

5.0

$500 USD

13 years ago

Excel VBA help and excel graphing

Provided great help, and communicated during the whole project to meet the requirements. Would hire again

Data Processing
Data Entry
Excel
Visual Basic for Apps

Share

User Avatar
Flag of

Rafael Q.

5.0

$80 USD

13 years ago

Access 2010 Client DataBase

Clean and accurate.I am very impressed.Great work.

Microsoft Access

Share

Experience

Database designer, VB developer

Mar, 2007 - Present

•

19 years, 3 months

Self Employed

Mar, 2007 - Present

•

19 years, 3 months

I have been designing databases using Microsoft Access, SQL, C#,, VB and VBA for the past 18 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 specialise in 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.

Mar, 2007 - Present

•

19 years, 3 months

Director

Jun, 2000 - Feb, 2007

•

6 years, 8 months

Fulcrum Group

Jun, 2000 - Feb, 2007

•

6 years, 8 months

In July 2000 I joined the Fulcrum partnership. We specialised in database design and development using Microsoft Access, Visual Basic and SQL Server as well as customising office solutions using Visual Basic for Applications in Word, Excel and Outlook. We also provided customised corporate computer training and reference manuals which we wrote in-house. I controlled the database and programming side of the business and was involved in all aspects of database design and development.

Jun, 2000 - Feb, 2007

•

6 years, 8 months

Education

University of Cape Town

1991 - 1991

HDE (English and History)

Flag of

South Africa

1991 - 1991

University of Cape Town

1984 - 1986

•

2 years

BA (English and History)

Flag of

South Africa

1984 - 1986

•

2 years

Qualifications

Word

2000

Microsoft

Microsoft Office User Specialist - Word

2000

PowerPoint

2000

Microsoft

Microsoft office user Specialist - PowerPoint

2000

Excel

2000

Microsoft

Microsoft Office User Specialist- Excel

2000

Publications

Word VBA Programming

self

this is step by step guide to teach yourself Word VBA programing including exercises and examples

Excel VBA programming

self

this is a step by step guide to teach yourself VBA programming - including exercises and examples

Access VBA macro programming

self

this is a step-by-step guide including exercises and examples to teach yourself VBA.

Certifications

US English - Level 1

US English

Basic Numeracy - Level 1

Basic Numeracy

E

Employer Orientation Exam

UK English - Level 1

UK English

Freelancer Orientation

Freelancer Orientation

Freelancer logo US (International) / English
Help & Support

Freelancer

Categories Projects Contests Freelancers Enterprise Innovation Challenges AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified

About

About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers

Terms

Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges

Partners

Escrow.com Loadshift Warrior Forum

Apps

Apple App Store logoGoogle Play logo

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2026 Freelancer Technology Pty Limited (ACN 142 189 759)