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
Shharat Sharma
from Connecticut, United States

Skills & Expertise Required

SAP Crystal Reports Microsoft Access Microsoft Excel

Candidate shortlisted and hiredHiring open till - Jun 5, 2022

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$25.02

Cost

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

Manage Engine Implementation Consultant - Hourly
Data entry of Medical centers contract information in the Rockhampton Queensland area. - Hourly
Fess Parker Winery residence - Hourly
Neo4j + React for production analytics dashboard. - Hourly
Image modifications with Php-ImageMagick - Hourly
SHOPIFY PAGE EASY EDITING FOR PRESENTATION (Modifying Height of Police & very EASY LITTLE TASKS) - Hourly
Need Lead generation/ Virtual assistant - Fixed
Networking configuration recovery, cisco -> debian server -> magento/odoo - Fixed
Set up Odoo Accounting and Inventory - Hourly

Similar Projects

Create a small online database for collecting construction inspection report

This is a report to inform the creation of a Database for input while out in the fields. Below are suggestions thus far:

Add a Request ID field for the Cityworks number
Add a Timestamp field for each address
Ask the City for input...read more

Sales Analysis of an Ecommerce business

Sales analysis data from QB data
1) Churn rate
2) Customer acquisition cost
3) Sales / % increase MOM (Month on Month) + Graph
4) Average basket size
5) Transactions / % increase MOM + Graph
6) Revenue / % increase MOM + Grap...read more

Scraping European video games publishers over the web

Looking for someone to scrap all the public email of European video games publishers over the web. Most important are the French, English and German one.

I need all those data store in an Excel files with this structure :
Company name -...read more

API Development (Connect Distributors website site product with my site)

Connecting my shopify store to my distributors. Products updates from the distributor should flow to my store. Which includes, New product, Price, Qty, Etc. Orders should be able to flow from my shopify store to my vendor of my choice. I work with...read more

Brother PT-P900 integration with excel with VBA P-bac.

Im looking to integrate buttons into the excel workbook that takes specific information and prints a sticker with corresponding info, we use the brother PT-P900 and we have printer templates for the stickers but Im lost when it comes to the VBA int...read more