login
Forgot?
Login with Facebook

Don't have an account? Register one now!

Access Database Creation from Excel Spreadsheet

Bids 
34
Avg Bid
$101 USD
CLOSED
  • Project ID:

    580955
  • Project Type:

    Fixed
  • Budget:

    $30-$250 USD

Project Description:

I have an excel spreadsheet with US Census data for approximately 900 metropolitan areas, and I need the information converted to a Microsoft Access Database. The spreadsheet is attached.

The spreadsheet has the city information as columns instead of rows, and each contain several datasets. For example, each city has datasets, labeled in the lighter green, covering numerous topics such as populations and employment data.

This data will be used later on to link with a variety of content, to link content with a variety of information on different geographic regions.

I need an Access DB that can house this information. The main tables will be to establish structure, and provide the linking functionality.

A table to the States, a two column table with the proper name and the two letter abbreviation.

A table of cities, located in the dark green, at the top of the excel document. This table will include the city name, the state, and the Census classification. There will also be three optional fields for “subcities.” There are a few city areas that will have two states selected, these cities will need to come up under searches for both states.

I will be importing lots of data, and I need some tables to manage how everything links up. For example, some sites might list San Francisco as San Fran., San Francisco Bay, SF, etc., and we need some tables to manage that.

I need a table for the alternative names for the states to add in variations, so all of the records will match up under state regardless of source.

I need a cities table with the same purpose.

Each of the variations tables needs to allow links to multiple selections, so several entries could be created under “Southern Califonia” for example, so that record would link to all of the cities.

I need data tables created as well. The datatables are included in the document and colored light green. I need a table created for each one of the headings (Basic Variables, Age: Total, etc.). The tables need to include the city and state, and have them linked to the appropriate master table.

Finally, I need a query set up to identify any records that are not linked to a city or state.

I am looking for someone that can get started quickly.

Skills required:

Excel, Microsoft Access

Additional Files:

Sample.xlsx

Project posted by:

mikemonk United States
(6 Reviews)

Last seen:

Public Clarification Board

4 messages

  • RandyKrupa

    Greetings:

    I have been looking for Microsoft Office positions that I can do from my home office. I noticed that you posted an 'Access Database Creation From Excel Spreadsheet position', position number (580955), on Freelancers that matches my skill set.

    The data in your spreadsheet can be converted to an Access database, although not with a wizard converter. The converter would have to be created to read the spreadsheet in. Either that or I would write a macro that swapped the columns with the rows and then use the wizard. Either way there will be some custom importing to accommodate things like the subcities. I have a table that has the US Zip codes which I might incorporate to help import cities like San Francisco along with cross-reference tables. If you can get them classified, I like your idea of the "subcities" for searches like Southern California, etc.

    I'm assuming that you are either getting your percentages directly or you are calculating the percentages - I can accommodate either way. I would like to work with you on this project. I can start it on the 4th of January and expect it to take about 1 week to deliver a working package.

    I am a US Citizen and English is my first language. I live in the Eastern Time Zone (GMT-05). I look forward to hearing from you!

    Thank You,
    Randy Krupa

    over 2 years ago

  • narendrakush18

    i MADE ON DATABASE, PLEASE CHECK IT

    Attachment: US+Census.mdb

    over 2 years ago

  • sachindrasangal

    this is a demonstration of work we can offer for you.

    over 2 years ago

  • najib0s

    Hello,

    I'm an experienced freelance programmer , just check my profile on SL :

    https://www.scriptlance.com/cgi-bin/freelancers/feedback.cgi?p=najib0s

    Regards,
    Najib.

    over 2 years ago


If you are the project creator or one of the bidders, please Log In for more options.


All Bids ()

HussienSharaf Egypt
Hussien.jpg
HussienSharaf
Egypt From Egypt     Gold Member     Offline
  Freelancer Orientation (85%, 99th percentile)
  Foundation EUFreelance.com Member
$180 in 4 days 
0
over 2 years ago
5.0

5.9

28 Reviews
91% Completion Rate
hi, i m the best DB expert. I will provide u a very dynamic tables structure and friendly GUI Hussien Sharaf
lucky2gaf Bangladesh
DataLancer_logo_1.JPG
lucky2gaf
Bangladesh From Bangladesh     Offline
  Foundation Freelancer.co.uk Member
  Freelancer Orientation (75%, 94th percentile)
  Employer Orientation (75%, 97th percentile)
  General Freelancer Orientation (90%, 98th percentile)
  Foundation LimeExchange Member
$200 in 4 days 
0
over 2 years ago
4.4

5.4

48 Reviews
59% Completion Rate
Hi, please view my PM, thanks.
dev3dworx Pakistan
3dwOrX Official Logo.jpg
dev3dworx
Pakistan From Pakistan     Gold Member     Online
  General Freelancer Orientation (80%, 90th percentile)
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$135 in 7 days 
0
over 2 years ago
5.0

4.6

17 Reviews
93% Completion Rate
At your service. Kindly check PMB for details.
DBguy United States
image1767.png
DBguy
United States From United States     Offline
  US English Level 1 (98%, 88th percentile)
  SQL Level 1 (90%, 85th percentile)
  General Freelancer Orientation (95%, 100th percentile)
$100 in 2 days 
0
over 2 years ago
5.0

4.2

14 Reviews
58% Completion Rate
Good Evening, Please check your PMB. Thank you for the consideration. Best Regards.
nmppatel United States
nmppatel
United States From United States     Offline
$40 in 1 day 
0
over 2 years ago
4.9

4.0

13 Reviews
70% Completion Rate
I am Ms-Access expert developer. I have very good experience with Ms-Access 2000/2003/2007. I have completed many projects on GAF in Ms-Access & Excel skill. I will provide quick & professional service.
KellogITSolution India
SAI.JPG
KellogITSolution
India From India     Offline
  Foundation EUFreelance.com Member
$30 in 0 days 
0
over 2 years ago
4.8

4.0

17 Reviews
47% Completion Rate
Hello Ready to start right now. Please see your PMB for details. Thanks
syslogic Germany
M.png
syslogic
Germany From Germany     Gold Member     Offline
  WordPress (78%, 82nd percentile)
  General Freelancer Orientation (85%, 95th percentile)
  Foundation EUFreelance.com Member
$200 in 14 days 
0
over 2 years ago
4.2

3.9

2 Reviews
86% Completion Rate
please see the PMB
Varun1981 India
1.jpg
Varun1981
India From India     Offline
$100 in 3 days 
0
over 2 years ago
5.0

2.4

3 Reviews
62% Completion Rate
Hi Sir, Please allow me to take this project. Please check my PM for more details. Regards Varun Sharma
asaikiran1979 India
asaikiran1979
India From India     Offline
  Foundation Freelancer.co.uk Member
  US English Level 1 (95%, 71st percentile)
  General Freelancer Orientation (100%, 100th percentile)
  Foundation EUFreelance.com Member
$50 in 1 day 
0
over 2 years ago
5.0

2.1

7 Reviews
77% Completion Rate
Ready here...! Expert..Let's Start.....!
neelu7779 India
logo1Modified.JPG
neelu7779
India From India     Offline
  Foundation Freelancer.co.uk Member
$30 in 2 days 
0
over 2 years ago
5.0

2.0

2 Reviews
50% Completion Rate
hi, My bid is less than 30 but I can not enter 30 in the amount. So I can do one more job for you...in same project
snuwanlk Sri Lanka
Logo_MONOSocial.gif
snuwanlk
Sri Lanka From Sri Lanka     Online
  US English Level 1 (88%, 36th percentile)
  General Freelancer Orientation (90%, 98th percentile)
$100 in 5 days 
0
over 2 years ago
5.0

1.8

1 Review
67% Completion Rate
Hi There, I am good in MS Access. I can complete you the project. I have worked on Access 2000, 2003 and 2007 as well, with a software development background. I can get the database developed with the way you want..... more
Hi There, I am good in MS Access. I can complete you the project. I have worked on Access 2000, 2003 and 2007 as well, with a software development background. I can get the database developed with the way you want...Can start immediately. less
narendrakush18 India
naren.jpg
narendrakush18
India From India     Offline
$30 in 10 days 
0
over 2 years ago
5.0

1.3

1 Review
33% Completion Rate
i can do it, please see my pm
balabeena United Arab Emirates
balabeena
United Arab Emirates From United Arab Emirates     Offline
  Foundation Freelancer.co.uk Member
  Foundation EUFreelance.com Member
$30 in 2 days 
0
over 2 years ago
5.0

1.0

2 Reviews
33% Completion Rate
I would like to take up the project
osky2009 Philippines
osky2009
Philippines From Philippines     Offline
  Foundation EUFreelance.com Member
$200 in 15 days 
0
over 2 years ago
I am currently available to start on your project. Please refer to my PM. Thank you
ccisne Nicaragua
foto_cisne.JPG
ccisne
Nicaragua From Nicaragua     Offline
$150 in 5 days 
0
over 2 years ago
Ok. The FrontEnd is Microsoft Excell, and the DB MSAccess.
RandyKrupa United States
RandyKrupa
United States From United States     Offline
$250 in 7 days 
0
over 2 years ago
Greetings! Please see my entry on the Project Clarification Board. Thanks, Randy
SangKwok United States
SangKwok
United States From United States     Offline
$85 in 0 days 
0
over 2 years ago
I have been doing this for 10 years. I can turn it around fast and accurate. I'm reliable and experience. It's very important to setup the table structure correctly to ease the future maintenance issues.
mahaveerprasad India
gaitictl.png
mahaveerprasad
India From India     Offline
$30 in 1 day 
0
over 2 years ago
0.0

0.0

0 Reviews
50% Completion Rate
pls chak p
sthan Nepal
Santosh.JPG
sthan
Nepal From Nepal     Offline
  Foundation Freelancer.co.uk Member
$200 in 2 days 
0
over 2 years ago
i have worked on several projects on excel to access so i am interested working in this project.please.
falakawan Pakistan
falakawan
Pakistan From Pakistan     Offline
$70 in 10 days 
0
over 2 years ago
It will be my pleasure to have this project
sachindrasangal India
sachindrasangal
India From India     Offline
  Foundation LimeExchange Member
$200 in 15 days 
0
over 2 years ago
have done several projects in access, will get it done to ur specifications!
srikanth1234 India
srikanth1234
India From India     Offline
  Foundation EUFreelance.com Member
$91 in 3 days 
0
over 2 years ago
Respected Sir, With reference to the your website I am Ready to do the online work Sir I am having computer with Broad Band Internet connection I have completed Diploma in computer Science and Engineeri... more
Respected Sir, With reference to the your website I am Ready to do the online work Sir I am having computer with Broad Band Internet connection I have completed Diploma in computer Science and Engineering and I am Shortly complete my B.Tech so I am having the full Knowledge of M.S. Office software. So I requesting you I will complete your work within given time period Thanking you sir Yours Sincerely  less
asiftufail76 Pakistan
asiftufail76
Pakistan From Pakistan     Offline
$150 in 7 days 
0
over 2 years ago
team of tqm professionals can do it timely.let us work for future
RajaAbhishek India
RajaAbhishek
India From India     Offline
$30 in 1 day 
0
over 2 years ago
I am a professional who works extensively with various databases and can handle this project easily. Regards, Raja Abhishek
aadibn India
Dheeru.jpg
aadibn
India From India     Offline
$45 in 2 days 
0
over 2 years ago
Have a nice day and hapy new hear 2010
najib0s France
ASSISTANCE.jpg
najib0s
France From France     Offline
  Freelancer Orientation (80%, 97th percentile)
  Employer Orientation (75%, 97th percentile)
  General Freelancer Orientation (75%, 81st percentile)
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$30 in 0 days 
0
over 2 years ago
0.0

0.0

0 Reviews
65% Completion Rate
It can be done with very high quality of work. refer to PM.
racheldsegui06 Philippines
racheldsegui06
Philippines From Philippines     Offline
$30 in 0 days 
0
over 2 years ago
Hi! Kindly check my PM. I am professional and has people that are trained very well to do projects exactly what you want.
dreamtree India
dreamtree
India From India     Offline
$80 in 7 days 
0
over 2 years ago
Hello Sir , We gone through Your requirment, We are a software development company in new delhi.. and we want to develope this software for u
igatetechno India
igatetechno
India From India     Offline
  Foundation EUFreelance.com Member
$60 in 25 days 
0
over 2 years ago
i will complete the project within 25 days for 60 US $
uttamdikshit India
uttamdikshit
India From India     Offline
$30 in 0 days 
0
over 2 years ago
Respected Sir, I can do this work very easily so please give me a chance for prove to me.
rani55555 India
rani55555
India From India     Offline
  Foundation EUFreelance.com Member
$30 in 2 days 
0
over 2 years ago
I CAN SIR, IF YOU ALLOW ME TO DO. I HAVE WELL EXPERIENCE IN DATA MINING ,MAINTAINING AND DELOPMENT OF DATABASES FOR YEARS. I HAVE ALSO 4 LEADING WEBSITE OF MY OWN.NOW YOU CAN DECIDE.
javedfl Pakistan
javedfl
Pakistan From Pakistan     Offline
$200 in 10 days 
0
over 2 years ago
My advice for you is php/mysql is best combination for you. And it is help ful you to for webpages. If you want then contact me
ShubhabrataKarma India
ShubhabrataKarma
India From India     Offline
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
  Foundation TycoonTalk.Freelancer.com Member
$150 in 4 days 
0
over 2 years ago
I am confident of doing your project.
applespie Philippines
applespie
Philippines From Philippines     Offline
$100 in 2 days 
0
over 2 years ago
0.0

0.0

0 Reviews
0% Completion Rate
im ready for that please count me in