Microsoft Access Developer Needed to Enhance Existing Inventory Management Application

Posted last week

Worldwide

Summary

We are looking for an experienced Microsoft Access / VBA Developer to improve and extend an existing Access-based inventory and materials management application. The application is already in use. We are looking for a developer who can understand the existing database and VBA code and implement several targeted improvements. Key Tasks - Main Menu / UI: Create a user-friendly menu that opens automatically when the Access application starts and provides access to the main functions. - FTP Inventory Data: Retrieve current stock/inventory data from an FTP server using login credentials and integrate/link the provided data file into Access. - Purchase Orders by Email: Purchase orders are currently generated as Access reports. Add functionality to review/approve an order and then send it directly by email, ideally as a PDF attachment. - UDI Barcode Processing: Implement parsing of UDI (Unique Device Identification) barcodes. The UDI code contains the product/item number and other information that needs to be split into separate data fields and processed within Access. What We’re Looking For Strong experience with Microsoft Access, VBA, forms, reports, queries and database development is essential. Experience with FTP integration, Outlook/email automation, barcode processing, UDI or GS1 standards would be a strong advantage. This is an existing application, so we are specifically looking for someone comfortable with reviewing and improving existing Access, rather than building a new system from scratch. Please briefly describe your experience with similar Microsoft Access projects and, if possible, provide examples.

  • Less than 30 hrs/week
    Hourly
  • < 1 month
    Duration
  • Intermediate
    Experience Level
  • $10.00

    -

    $30.00

    Hourly
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Microsoft Access
Microsoft Access Programming
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:yesterday
  • Hires:
    1
  • Interviewing:
    2
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Sep 3, 2016
  • Switzerland
    Zurich5:15 AM
  • $31K total spent
    78 hires, 22 active
  • 1,422 hours
  • HR & Business Services
    Mid-sized company (10-99 people)

Explore similar jobs on Upwork

BASEROW Database Creation SpecialistHourly‐ Posted 5 days ago
Database Development
FileMaker Developer for Database DesignHourly‐ Posted 3 weeks ago
Claris FileMaker
Database Design
Microsoft Access Programming
Database Programming

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo