Completed

Create access database based on excel spreeadsheet

I have an excel to input data, and I need some calculations.

In order to do that, this excel needs to be converted in access database, each sheet must be a table for inputting data.

Then I need 4 dropdown list to extract information for 1 day, 1 week, 1 month or 1 year.

Information will be shown in a report, (1 page)

Calculations are sums of kilos, scrapt, stock and % of consumptions related with input tables.

I can provide a video explanation, and excel source file to be converted in ms access database.

Skills: Data Processing, Database Programming, Excel, Microsoft Access, Visual Basic

See more: create access database vbs, using access database rather excel, create access database , how to create a database in excel 2013, how to create a database in excel 2007, automatically update access database from excel, excel database tutorial, import excel into access 2010, how to create a database in excel 2010, how to create a searchable database in excel, convert excel spreadsheet to access database 2013, create access database table using, create graphs automatically based excel information, create access database using visual basic net, net create access database, create access database logistics, want create access database logistics company, create access database fun, excel vba create access database, create access database tracking excel file

About the Employer:
( 2 reviews ) Rubi, Spain

Project ID: #17881784

Awarded to:

VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl More

$75 USD in 1 day
(110 Reviews)
6.2

46 freelancers are bidding on average $143 for this job

schoudhary1553

Hello, Hope you are doing well. I can help with your project Create access database based on excel spreeadsheet. I can assure you the quality job. I have good experience in Data Processing, Database Programmin More

$150 USD in 2 days
(290 Reviews)
7.6
paris2785

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Access because this is my favorite field and MS Access projects are among the tasks I work wi More

$200 USD in 5 days
(197 Reviews)
7.0
sumon355

Hello, As an expert in ms access as well as VBA, i am very much interested to convert your excel file to ms access database with required reports. Please provide the video explanation if you have along with the existi More

$180 USD in 3 days
(183 Reviews)
6.9
zekovicm

Hi there,I am Miljan,MS Access expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th More

$155 USD in 3 days
(88 Reviews)
6.8
suyashdhoot

Hi I am a very experienced statistician, data scientist and business analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several com More

$350 USD in 3 days
(51 Reviews)
6.4
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on Excel/Access projects extensively and have also worked in transforming excel functionality to Access with usage of forms/reports/vba co More

$88 USD in 3 days
(158 Reviews)
6.2
alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel More

$55 USD in 3 days
(68 Reviews)
5.8
royalcalif

Let me review the spreadsheet with few rows of data for appropriate duration and cost as well. I awaiting for the video too. Thank you very much for your opportunity. Royalcalif Hi Mr. Employer I have lot of experienc More

$30 USD in 1 day
(100 Reviews)
5.9
SPARKtechBD

Expert on Excel and MS Access database system to build any kind of data automation and reporting. I can build Access program or Visual Basic Windows Application for this project to get better output and user friendly i More

$250 USD in 3 days
(12 Reviews)
5.5
satishtl

- Can get converted the current Excel data containing the kilos, scrapt, stock and % of consumptions related with input tables, into the Access Database providing input screens to enter and store data. - Based on th More

$150 USD in 3 days
(54 Reviews)
6.1
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access More

$155 USD in 3 days
(52 Reviews)
6.2
SShtv

I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and constructing information panels. As an example, I bring screenshots of some of my works. More

$150 USD in 3 days
(61 Reviews)
5.7
jonathanpradas

Good day. The time frame and the bid amount are just for the preliminaries and are still subject to change depending on the actual difficulty of the project as the complete details were not yet communicated from the pr More

$150 USD in 3 days
(53 Reviews)
5.4
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

$120 USD in 3 days
(53 Reviews)
5.3
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can exchange data from excel to access database using VBA. I have excellent knowledge and experience of creating More

$120 USD in 3 days
(66 Reviews)
5.2
datakillers

Hi I am expert in Microsoft Office specially Excel, Word and Access Database. Data Entry and Processing is my passion with years of experiences. I am talented and very hard working also know the value of time so More

$49 USD in 1 day
(45 Reviews)
5.2
dvcontact

Hi Do you want to see a sample of your project on entering data in Excel and performing calculations completed before you award the project. You can consider it professionally done in less than 24 hrs. I am confide More

$150 USD in 3 days
(33 Reviews)
5.5
c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.

$140 USD in 3 days
(34 Reviews)
5.0
$50 USD in 2 days
(53 Reviews)
5.1
$100 USD in 3 days
(6 Reviews)
4.0