offline
Last seen: Jul 30, 2014 8:03 AM EDT
Hire Me!
Rate: $50.00 USD/hour
Follow Invite to Project
 

VBAWhizz

Database Design, Access, Excel and Word VBA Development

Username: VBAWhizz

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Cape Town, South Africa

Member since: March 2011

Reputation:

5.0/5

(13 reviews)

5.1
[see more]

No user has recommended this freelancer.

  • $300.00 USD
    5.0
    Profile image for Seller blomeeii

    blomeeii

    Feb 19, 2014

    Very good product and completed very quickly

    Project Description:Need to create an access database where we can select different freight carriers based on customer shipping needs. Carrier Base City Base State Contact Primary Phone Email Website Fax LTL FTL...
    [more]
  • $125.00 USD
    5.0
    Profile image for Seller AthensMicro

    AthensMicro

    Jun 6, 2013

    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.

    Project Description:Summary: We have an existing Microsoft Access database form (.accdb). We would like to update the form so that: - When the user clicks “Daily Backup Report” from the “Switchboard” form the database checks if certain data has been entered...
    [more]
  • $500.00 USD
    5.0
    Profile image for Seller Joegaudiano

    Joegaudiano

    Feb 13, 2013

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

    Project Description:I have three different reports which will be filled in daily, From here certain information from each report needs to be copy and pasted into a running report log, which will log all reports. Certain information in the running report will be graphed on a separate tab...
    [more]
  • $80.00 USD
    5.0
    Profile image for Seller Compupal

    Compupal

    Jan 26, 2013

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

    Project Description:Simple DataBase Access 2010. Database needs to record clients personal information ( full name, day of bday, address ,City/state/Zipcode, phone numbers, email and a NOTE field.) second information...
    [more]
  • $300.00 USD
    5.0
    Profile image for Seller svet63

    svet63

    Jan 25, 2013

    Very good developer! Recommended!

    Project Description:I need URGENT help with some VBA work. You have to have at least 5 years as VBA developer - and I need a proof - either great reviews on FL or some screenshots from previous work. Also very good knowledge of Excel user forms, formulae, and pivots is required...
    [more]
  • $200.00 USD
    5.0
    Profile image for Seller lindenmj1

    lindenmj1

    Jan 24, 2013

    My second project with this coder, I will definitely use her again!!!

    Project Description:I have an Access database app that runs a query on real estate sold listings to determine market prices for new properties that come up on the market. It then figures out the list price per square foot vs...
    [more]
  • $400.00 USD
    5.0
    Profile image for Seller lindenmj1

    lindenmj1

    Dec 23, 2012

    Great coder, I will definitely use her again for future projects!

    Project Description:I need a piece of database software written for either MS Access or PHP/MySQL (explain your choice) that will dynamically generate a resale price for real estate properties as they are added to the database...
    [more]
  • $200.00 USD
    5.0
    Profile image for Seller scattechnologies

    scattechnologies

    Mar 8, 2012

    Great work. Has been very patient with us to understand the requirements and very responsive about the whole deal.Looking forward to work with you.

    Project Description:I have an excel file with Macros in it to perform a statistical analysis. The file is complete and functional. Currently, to perform the statistical analysis the user has to go back and forth to 3 different worksheets to get the analysis done....
    [more]
  • $120.00 USD
    5.0
    Profile image for Seller bmauers

    bmauers

    Feb 1, 2012

    Fast, accurate and on-budget. A pleasure to deal with - very professional.

    Project Description:This project is being posted for freelancer VBAwhizz to bid on: formatting of an Excel template for the purpose of eliminating duplicate entries.
    [more]
  • $150.00 USD
    5.0
    Profile image for Seller bmauers

    bmauers

    Jan 23, 2012

    Fast. Accurate. On budget. Mel was able to solve a complex formatting issue that had been plaguing our company for months. A genius and a pleasure to deal with; I just sent her info on the next project.

    Project Description:[This is a Private Project. You must be logged in to view the Project Description]
    [more]
    VBAWhizz has not completed any projects.
  • $60 NZD/hr In Progress

    We require a consultant to perform an upgrade of an Access 2003 Inventory Management DB. Ideally this should be moved to the latest version, allowing for future Office upgrades. This will require the consultant to upgrade the DB, repair broken links, tables and or reports, as well as strip out any redundant items.As part of the analysis, we would be open to discussions re modernising the DB and its functionality. These include but are not limited to:• Improve the current transactional function.• Create new transaction functions.• Add items to current tables and reports.• Split DB into front end and backend to allow for multiple different access.• Improve security of DB.Alternatively, we would also be open to discussions on a new DB design, providing the improved functionality we require.More detail of the design and functionalities upon request.

    [more]
  • $700 USD In Progress

    I have several excel data collection spreadsheets and workbooks that push-pull data from each other. I would like to automate the process via excel VBS and design Excel Userfrom Input interface. Please email your bid if my budget is to low. I may have additional follow on work if you are the right person. Eric Brockman

    [more]
  • $20 USD/hr In Progress

    I used another programmer on Freelancer.com They never completed the job, and could not be contacted again. Now I have a project that is 70% done and need someone with advanced Microsoft Access programming skills. What is needed is to allow a user to data enter information into a user friendly platform. We may want this to be something our staff can use out in the field. Then allow the user to have the entered information merged into a word document. It will have to be something that I can update as needed after the project is completed. Non-disclosure and confidentiality agreement must be signed before agreeing to job.

    [more]
  • $250 USD Mar 8, 2013

    Would like a document in which it would prompt for several things and fill in the necessary fields automatically for a standard sale and purchase agreement. It will also insert the necessary pre-set clauses depending on your answer to the questions.I know this can be done via MailMerge and fill-in but fill-in has certain limitations (such as 255 character limit?) and I understand this can be done via VBA and mail merge events?Some Variables:VendorVendor AddressPurchaserPurchaser AddressWhether Vendor/Purchaser is a company or not (and to replace it with the appropriate signature boxes)Property DescriptionIs the property free from encumbrances?Purchase PriceDeposit AmountBalance Purchase PriceWhether there is an existing charge?Should the Deposit Sum or the Balance Sum to be used in discharging the charge?Is Real Property Gains Tax payable?Whether Vendor has option to abort deal by paying back Deposit and a like sum?Who should bear legal fees?Who should bear stamp duties?Also would like instructions on how to do minor edits.A sample of the document is attached which shows the kind of variables involved.

    [more]
  • $1000 USD Feb 26, 2013

    Taking various excel spreadsheets, Develop a database using existing excel spreadsheet data. Write standard queries and reports.

    VBAWhizz does not have any open projects.
    VBAWhizz does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Database designer, VB developer

Mar 2007 - Present (7 years)

Self Employed

Since returning to South Africa, I have continued to work as a freelance database designer, Visual Basic developer and Microsoft Office trainer.

Director

Jun 2000 - Feb 2007 (6 years)

Fulcrum Group

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.<br />I controlled the database and programming side of the business and was involved in all aspects of database design and development.

Education

BA (English and History)

University of Cape Town

1984-1986

HDE (English and History)

University of Cape Town

1991-1991

Certifications

Master Instructor

Microsoft

Master Instructor for Microsoft Office - Word, Excel, PowerPoint, Outlook, Access

Visual Basic 5 Advanced

Microsoft

Mastering Visual Basic 5

Microsoft Office Master

Microsoft

Office Certification Microsoft Office User Specialist - Access, Excel, Word, Outlook, PowerPoint

Access

Microsoft

Microsoft Office User Specialist - Microsoft Access

Outlook

Microsoft

Microsoft Office User Specialist - Microsoft Outlook

Excel

Microsoft

Microsoft Office User Specialist- Excel

PowerPoint

Microsoft

Microsoft office user Specialist - PowerPoint

Word

Microsoft

Microsoft Office User Specialist - Word

Publications

Access VBA macro programming

self

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

Excel VBA programming

self

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

Word VBA Programming

self

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