Freelancer logo How It Works Browse Jobs
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
$40 USD / hour
Flag of SOUTH AFRICA
cape town, south africa
$40 USD / hour
It's currently 11:23 PM here
Joined March 10, 2011
0 Recommendations

Melanie J.

@VBAWhizz

 5.0 (14 reviews)
5.1
5.1
95%
95%
$40 USD / hour
Flag of SOUTH AFRICA
cape town, south africa
$40 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
17%
Repeat Hire Rate

Database Design, Access, Excel VBA Development

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.
Freelancer Microsoft Access Developers South Africa
See all Microsoft Access Developers in South Africa

Contact Melanie J. about your job

Log in to discuss any details over chat.

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

Reviews

Changes saved
Showing 1 - 5 out of 14 reviews
Filter reviews by:
5.0
$200.00 USD
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
User Avatar
Flag of Nathan M.
@Astera
•
2 years ago
5.0
$300.00 USD
Freight Carrier Access Database
Very good product and completed very quickly
Microsoft Access
B
Flag of Dave L.
@blomeeii
•
10 years ago
5.0
$125.00 USD
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
A
Flag of Zack L.
@AthensMicro
•
11 years ago
5.0
$500.00 USD
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
J
Flag of Joe G.
@Joegaudiano
•
11 years ago
5.0
$80.00 USD
Access 2010 Client DataBase
Clean and accurate.I am very impressed.Great work.
Microsoft Access
User Avatar
Flag of Rafael Q.
@Compupal
•
11 years ago

Experience

Database designer, VB developer

Self Employed
Mar 2007 - Present
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.

Director

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.

Education

HDE (English and History)

University of Cape Town, South Africa 1991
(Less than a year)

BA (English and History)

University of Cape Town, South Africa 1984 - 1986
(2 years)

Qualifications

Word

Microsoft
2000
Microsoft Office User Specialist - Word

PowerPoint

Microsoft
2000
Microsoft office user Specialist - PowerPoint

Excel

Microsoft
2000
Microsoft Office User Specialist- Excel

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.

Contact Melanie J. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

us_eng_1.png US English 1 95%
numeracy_1.png Basic Numeracy 1 94%
employer_orientation.png Employer Orientation Exam 1 80%
uk_english1.png UK English 1 80%
freelancer_orientation.png Freelancer Orientation 1 75%

Top Skills

Microsoft Access 12
Visual Basic 4
Excel 4
Visual Basic for Apps 3
SQL 2

Browse Similar Freelancers

Microsoft Access Developers in South Africa
Microsoft Access Developers
Visual Basic Developers
Excel Experts

Browse Similar Showcases

Microsoft Access
Visual Basic
Excel
Visual Basic for Apps
Previous User Next User
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 Singapore / English Help & Support Freelancer Categories Projects Contests Freelancers Enterprise 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 © 2024 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.