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 photoundefined
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 user.
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 4:07 AM here
Joined March 10, 2011
0 Recommendations

Melanie J.

@VBAWhizz

5.0 (14 reviews)
5.1
5.1
$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

Contact Melanie J. about your job

Log in to discuss any details over chat.

Portfolio Items

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
Access 2007 introductory training manual
Word Fax Template
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
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 months ago
5.0
$300.00 USD
Very good product and completed very quickly
Microsoft Access
B
Flag of Dave L. @blomeeii
9 years ago
5.0
$125.00 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.
Visual Basic .NET User Interface / IA Software Architecture Microsoft Access
A
Flag of Zack L. @AthensMicro
9 years ago
5.0
$500.00 USD
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
10 years ago
5.0
$80.00 USD
Clean and accurate.I am very impressed.Great work.
Microsoft Access
User Avatar
Flag of Rafael Q. @Compupal
10 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!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection
Loading preview