Create excel/access form

Cerrado Publicado Jul 31, 2014 Pagado a la entrega
Cerrado Pagado a la entrega

I have created this form ("survey") through Microsoft Excel for our employees to fill out each day: [url removed, login to view]

The benefit of this excel form is that it can be hosted on my office 365 account and accessed via the internet as you see.

Once the form is filled out, the data is deposited onto an excel sheet within my office 365 account (you can see the excel sheet attached in the files). However, I don't know how to manipulate the data now. I would think potentially using pivot tables may help search/sort/filter the data, but I don't know how to create pivot tables.

If you believe the same work can be accomplished using Access, then I am open to trying Access as well.

We need to be able to search/sort/filter this data once it is deposited onto the excel sheet, and the form needs to be accessible via the internet as it is currently. Please tell me how you believe this should be done, and what your cost for doing the work will be.

Thank you!

Procesamiento de datos Administración de bases de datos Desarrollo de base de datos Excel Microsoft Access

Nº del proyecto: #6257195

Sobre el proyecto

20 propuestas Proyecto remoto Activo Sep 6, 2014

20 freelancers están ofertando un promedio de $67 por este trabajo

elboukharimu

Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio Más

$100 USD en 3 días
(23 comentarios)
5.1
rlpenn

I put together an example of your Excel app in an Access App on Office 365. Contact me and I will send you an invite to my site. After you have deployed the app you can link to the SQL Azure tables from a desktop ver Más

$100 USD en 1 día
(3 comentarios)
3.1
joseluiselp

Hello i can do this for you. We can take all that data to a database. I can make you a little script that take care of that. Let me know if you are interested.

$60 USD en 2 días
(2 comentarios)
2.9
dipakmoliya

I have been in this industries for 6 years and I can create a new access database which will works online and your employees can fill out the form each day. We can make pivot table and also we can sort, filter or searc Más

$61 USD en 1 día
(4 comentarios)
2.8
saleh2291

hello i can help with what you're requiring since i have a free one week that will help be committed and hand in a flawless work.

$61 USD en 1 día
(0 comentarios)
0.0
kishoreiitpatna

This can be achieved using Pivot Tables. Other thing you can do is by adding a button to sort the data which can be achieved by using Macro functionality. There are many other ways to achieve. I have placed my bid. Fee Más

$100 USD en 1 día
(0 comentarios)
0.0
mohanrajbe

Hi This is Mohan From INDIA I Have Good Knowledge in Your Requirement I will do Honestly With in 1 days Regards, Mohan

$60 USD en 1 día
(0 comentarios)
0.0
solanki005

A proposal has not yet been provided

$55 USD en 2 días
(0 comentarios)
0.0
rawatgaurav

A proposal has not yet been provided

$15 USD en 3 días
(0 comentarios)
0.0
venkatmaran

Office 365 is based upon the SharePoint Technology which interacts with Excel/Access and Infopath forms. We can do lot of data manipulation based upon the data submitted via form to the database. Using simple tools lik Más

$83 USD en 1 día
(0 comentarios)
0.0
Alexandra87iu

A proposal has not yet been provided

$61 USD en 1 día
(0 comentarios)
0.0
sigmunt

Dear Sirs, The task seems to be easy because you can use consolidation feature from Excel. Give me more info and I will teach you how to do it. Regards - Marcin

$61 USD en 3 días
(0 comentarios)
0.0
Thevog

It should be possible to import the doc into excel online. Excel online is a free service and is also available to other users on the net. Please contact me for ore info. Kind regards

$61 USD en 1 día
(0 comentarios)
0.0
hadded

A proposal has not yet been provided

$61 USD en 1 día
(0 comentarios)
0.0
bindaasvw

It will be better to have have more details discussed like what is the final output/ summary data you want to see out of these forms. Excel and Access both are doable as data can be easily exchanged between these. I di Más

$54 USD en 3 días
(0 comentarios)
0.0
AshleighWaters

Good morning I'd be delighted to assist you with the excel work you require. I have vast experience in analytics and business intelligence. I am also able to design and develop access databases although I do belie Más

$100 USD en 5 días
(0 comentarios)
0.0
markonym

I believe I am a good fit for your project as a freelancer! I have plenty of experience in entering, analyzing and processing huge amount of information. I also have a lot of experience in statistical data processing Más

$50 USD en 4 días
(0 comentarios)
0.0
Bernie777

hi im a uk business based analyst and working with large excel sheets im happy to help you with this thanks

$66 USD en 1 día
(0 comentarios)
0.0