Excel VBA & SQL Server Automation Specialist (Server-Client Accounting System Setup)

Posted 3 days ago

Worldwide

Summary

Project Overview We have an existing Excel-based Accounting System that uses: - Microsoft Excel - VBA Macros - SQL Server Express - SQL Server Management Studio (SSMS) - Power Query - Data Scripts - ODBC Driver - Multi-user Client-Server Architecture The system is already developed and documented. We need an experienced specialist to configure, troubleshoot, and document the setup on the Server PC and Other PCs. The goal is to have: - One Server Computer hosting the SQL database - Multiple Client Computers connected to the database and all the Excel Form per Department - All Excel forms and workflows functioning properly and syncing with each computer, given that the transactions made are posted into the Ledger The system uses a dedicated SQL database and custom login permissions. The freelancer should be comfortable working with SQL Server security and network settings.

  • $5.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Financial Report
Chart of Accounts
Activity on this job
  • Proposals:Less than 5
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Apr 13, 2020
  • Philippines
    Cavite6:22 AM
  • $1.1K total spent
    53 hires, 14 active

Explore similar jobs on Upwork

Balance Sheet HelpFixed-price‐ Posted 4 months ago
Accounting
Balance Sheet
Intuit QuickBooks
Bookkeeping
Business Analysis
QuickBooks Online
Polish Accountant for Sp. z o.o.Hourly‐ Posted 4 weeks ago
Accounting
Data Entry
Tax Preparation
Bookkeeping
English
Balance Sheet
Polish

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