Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Ms access and VBA. upload of Excel tables + computations between access tables

    - or -

    Post a project like this
    3542
    $$
    • Posted: 10 years ago
    • Proposals: 8
    • On-site in City of London, GB
    • #244057
    • Awarded
    Sorin B.
    Sorin B.
    Access Developer
    United Kingdom London
    Carl W.
    Carl W.
    Design and Build Turnkey Data based business solutions and process streamlining for SME's
    Top Endorsed
    United Kingdom Birmingham
    Olatunde A.
    Olatunde A.
    VBA Access Developer
    United Kingdom City of London
    Steve B.
    Steve B.
    Microsoft Access and SQL Server Developer
    Top Endorsed
    United Kingdom Orpington
    Dr David H.
    Dr David H.
    Chartered engineer specializing in back end databases and API's
    Top Endorsed
    United Kingdom City of London
    Adam K.
    Adam K.
    Software Developer - iPhone - Android - WordPress - Databases - C# .NET
    Top Endorsed
    United Kingdom Wymondham
    Simon F.
    Simon F.
    IT Systems Specialist
    United Kingdom Hereford
    Nathan S.
    Nathan S.
    VB(A) and C# Developer and Consultant
    Jamaica Kingston
    1098432258127844154643297891436523438875187343
    Sorin B.
    Carl W.Olatunde A.Steve B.Dr David H. + 3 others have already sent a proposal.
    • 1
    • 1

    Description

    Experience Level: Intermediate
    This is a MS-Access and VBA database work. Purpose is to elaborate a prototype to validate the feasibility and performance of a concept.
    The output tables will be fed to an MySQL server within a prototype WebSite.
    This database prototype will be used by 1 person only during 6 months.

    Job:
    1/ create a simple user interface to automate the upload of predefined Excel tables in MS-Access (1 user) (up to 8 different tables).
    2/ apply defined rules and make computations between the MS-access tables. These computation must be launched by a simple menu (one button)
    3/ Generate 3 output tables that will feed a MySQL database on an ftp server. The structure of these tables is already defined
    4/ Test and debug, very limited documentation.

    There is no technical complexity, and the user interface is to be kept very simple and limited as there will be only 1 user for 6 months.
    The main difficulty is on the data availability and field definition and format between the tables. The Excel tables comes from extraction of different existing systems.
    Linking the tables as we want may be sometimes tricky and require sometimes data formatting. The first analysis has been done, but will need to be tuned depending of the actual data availability and reliability we will face.
    One of the expectation is your capacity to understand the output content and adapt the planned computation when required.
    If there was no issue, I would expect the jib to take 30 hours. But I expect some need of brainstorming. that's why the job is per hour.

    Timeline:
    Job would start early May and must be finished by May 31st.

    Organisation:
    It would start by a half day or day meeting with me to review the specification, expectations and available excel tables and data structure/format.
    Ideally, you could work from our office 2 or 3 days at the beginning, so I could be with you.The rest of the time you could work from your own place. Our Office is located near London Bridge.
    Laurent D.
    Laurent D.
    100% (1)
    Projects Completed
    1
    Freelancers worked with
    1
    Projects awarded
    100%
    Last project
    18 Jun 2013
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    3542
    $$

    - or -

    Post a project like this
    Laurent D.
    Laurent D.
    100% (1)
    Projects Completed
    1
    Freelancers worked with
    1
    Projects awarded
    100%
    Last project
    18 Jun 2013
    United Kingdom

    Related project Searches


    mysql analysis automation data structures database debugging documentation extraction File Transfer Protocol (ftp) microsoft access user interface (UI) VBA programming language website prototyping

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies