En cours

MS Excel Sheet with MS Access Data

I have a ms access sales order entry database. I Want to have a form that allows a user to select sales by a monthly date range - for example - sales from 01/01/2017 to 01/31/2017. After selecting the data, I want to refresh a MS Excel spreadsheet with the data.

The Spreadsheet chart groups the sales by salesperson, showing a dollar amount and a percentage of total sales (see image attached). I also want to user to be able to save the excel file and send it to others with the data in it.

I can provide a sample database with orders entered, and the form that selects the data by date range. I can also provide a sample excel file that uses a similar chart - I want the data to be on a separate tab instead of how it is now. (see excel file attached)

I need the excel file created, and populated with the access data so it refreshes when a user selects a date range.

After this small task, I have other spreadsheets that need to be created using the same methods.

Compétences : Excel, Microsoft Access, Microsoft Office

Voir plus : link excel to access query, import excel data into access, update excel spreadsheet from access database, how to connect excel to access database using vba, how to use access with excel, link excel to access, exporting data from excel to access using vba, update access table from excel, Data entry in excel, ms-word ,copy paste , DATA ENTRY,EXCESS,EXCEL,MS WORD, excel data entry sheet excel, transfer data access excel sheet, data access class excel, create data input sheet excel, data entry sheet excel

Concernant l'employeur :
( 33 commentaires ) Everett, United States

N° du projet : #14418135

Décerné à :

royalcalif

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS Plus

30 $ USD en 1 jour
(33 Commentaires)
5.0

16 freelance ont fait une offre moyenne de 150 $ pour ce travail

ponnarasiBabu

I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california Plus

200 $ USD en 5 jours
(52 Commentaires)
5.5
renesontiongson

Pleasure to help you. I can handle very well access and excel automation. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel and Access. Proposed Milestones $200 USD Plus

200 $ USD en 1 jour
(40 Commentaires)
4.9
conforti

Give me more details about it

100 $ USD en 5 jours
(8 Commentaires)
3.5
ESOLUTIONSSS

Dear i will complete this project with 100% accurancy I will do my best. Please award me this project. Thank You:) Relevant Skills and Experience Recently I was scrap 40,000 australian data. Please check my profile P Plus

30 $ USD en 2 jours
(11 Commentaires)
3.4
155 $ USD en 3 jours
(2 Commentaires)
3.0
Deenario

I have worked on databases like ACCESS , SQL , ORACLE for 6 years now. I read your post and i can do a professional work. Relevant Skills and Experience I am oracle Certified and Has worked With NADRA Pakistan. Which Plus

155 $ USD en 3 jours
(3 Commentaires)
3.2
VanshikaTulsyan

A proposal has not yet been provided

166 $ USD en 3 jours
(3 Commentaires)
0.8
155 $ USD en 3 jours
(0 Commentaires)
0.0
Hellbat

i have much experience form excel works. I would complete my work with good quality and without the lack of time Relevant Skills and Experience I am well skilled in this job, I had already done many tasks like this P Plus

166 $ USD en 3 jours
(0 Commentaires)
0.0
250 $ USD en 3 jours
(0 Commentaires)
0.0
222 $ USD en 5 jours
(0 Commentaires)
0.0
Developer98

Hello, I loved to work on your project because i am expert in data entry and do this job for you and you loved my work :) Relevant Skills and Experience we are top expert in data entry Proposed Milestones $30 USD - d Plus

30 $ USD en 1 jour
(0 Commentaires)
0.0
quehaceshino

hello, i'm from chile and i'm looking for job about excel like you work.

127 $ USD en 5 jours
(0 Commentaires)
0.0
zim8877

A proposal has not yet been provided

277 $ USD en 5 jours
(0 Commentaires)
0.0
144 $ USD en 2 jours
(0 Commentaires)
0.0