Freelancer logo
Log In Sign Up
Post a Project
EXPLORE
Excel
Microsoft Access
SQL
Visual Basic
Visual Basic for Apps
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
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 (11:19 PM)
・
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

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
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
Changes saved
5.0 · 14 Reviews
Reviews
User Avatar
Access database enhancements -- 2 • $200 USD
Exceptional work. Properly took time to understand the brief. And output is spot on. Will definitely use again.
Nathan M.
@Astera
•
Flag of
Burnham on Sea, United Kingdom
•
2 years ago
Share
B
Freight Carrier Access Database • $300 USD
Very good product and completed very quickly
Dave L.
@blomeeii
•
Flag of
Signal Hill, United States
•
11 years ago
Share
A
Access Database/Form Updates • $125 USD
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.
Zack L.
@AthensMicro
•
Flag of
Nationwide, United States
•
12 years ago
Share
J
Excel VBA help and excel graphing • $500 USD
Provided great help, and communicated during the whole project to meet the requirements. Would hire again
Joe G.
@Joegaudiano
•
Flag of
Stamford, United States
•
12 years ago
Share
User Avatar
Access 2010 Client DataBase • $80 USD
Clean and accurate.I am very impressed.Great work.
Rafael Q.
@Compupal
•
Flag of
Brentwood, United States
•
12 years ago
Share
Experience
Database designer, VB developer
Mar, 2007 - Present
•
17 years, 9 months
Self Employed
Mar, 2007 - Present
•
17 years, 9 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
•
17 years, 9 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
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo Jamaica / English
Help & Support
Freelancer
Categories Projects Contests Freelancers Enterprise AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App
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
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.