Remote Data Mining And Management Job In Data Science And Analytics

Access DB with Excel Report

Find more Data Mining And Management remote jobs posted recently Worldwide

Hello, we have an existing access database that pulls information from our ERP (Sage 100 (Formerly MAS 200) The database queries sales data from our ERP and compiles it on a table via various queries. From there the information is copied from access and pasted into a excel document that contains pivot tables, calculated fields, and slices to present that information in a digestible format.

Essentially this is sales and cogs information presented in a format that would Sales team can review, it contains monthly breakdowns as well as a prior year comparison.

The access DB and excel already exist; however, we are needing to make modifications to them and are unable to allocate the time to do so.
About the recuiter
Member since May 20, 2018
Iain R.
from Scotland, United Kingdom

Skills & Expertise Required

SAP Crystal Reports Microsoft Access Microsoft Excel

Open for hiringApply before - Sep 7, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$34.39

Cost

Offer to work on this project closes in 46 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Native French Speakers needed for translation and online and light social media research - Hourly
socail media - Hourly
Salesforce Design - Hourly
Costume design - female Diner costume - Fixed
Docusign Expert fort Client Onboarding Project - Hourly
Need a web tool developed - Fixed
Mattermost & Jitsi Integration (mobile and web) - Hourly
I need a Java developer (Not JavaScript) who know OOP as well for a short assignment - Hourly
Need a database and algorithm created - Hourly
Product design in CAD (+ optional 3d) - Hourly
BW4HANA Simple ETL from S4HANA - Hourly
Implementation for Yolov4 in PyTorch - Fixed
Experienced Affiliate Recruiter - Fixed
Looking for someone who has built PBX kind or SIP calling type of System - Fixed
jBPM Installation, Configuration, and Development of Two Applications - Fixed

Similar Projects

Collect info from Golf Course websites

I have a list of golf courses that I need to collect information from. This includes website URL, contact information, course information, and more.

I have been compiling this myself for a bit, so I can provide a sample spreadsheet of what...read more

Need help for Google Sheets

There are 4 jobs which I will share a video link with shortlisted candidates

Job 1: Automatically add timestamp (that wont be overwritten) in column C when column M is filled Job 2: Automatically add timestamp (that wont be overwritten) in...read more

List Scrubbing and Data Enter

Looking for someone who can manage different type of list, and different details for certain list and that are good at meeting deadlines.
Someone is who availability and determined to get the job done at a great pace.

Need a developer for an Excel based BI Dashboard

We are looking for help developing a suite of interactive dashboards driven by excel that easily shareable with clients. We had previously developed a set using Excelsius/SAP Business Objects but it is no longer viable.
We are a healthcare develo...read more

Quantity survey for electrical DWGs

There is a project of residential buildings consist of 300 DWGs of electrical drawings need to quantity survey the ele. Works on excel sheet according the BOQ items